Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: use of SQL under Database Connections ->Advanced

  1. #1
    Join Date
    Sep 2012
    Posts
    17

    Default use of SQL under Database Connections ->Advanced

    Hi,

    I am wondering, what SQL stements window is doing under "Database Connections ->Advanced"? I wrote a query there but not able to see any effect on table I have selected.

    Can someone enlighten me here?

    Regards,
    Jayesh

  2. #2

    Default

    Dont know if this is exactly what you need as I have never done this before, but I know most of the issues I have with Databases in Pentaho came from two things (all my experience has been with BI-Server).

    1) The correct DB driver must be installed in pentaho/administration-console/jdbc, as well as pentaho/biserver-ce/data/lib, and finally pentaho/biserver-ce/tomcat/lib
    2) if you use are trying to connect to a MySQL database you will want to open you mysql database and run SET GLOBAL sql_mode='ansi_quotes';

    I hope one of these helps, if not at least I tried.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.