Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Add mysql Datasource in cde

  1. #1

    Default Add mysql Datasource in cde

    Hi,
    Need suggestion regarding adding mysql database for running dashboard using cde,as there are many entities in left panel like below.Wizards,Legacy Datasources,Community Data Access,SPARKL Endpoints,MDX Queries,OLAP4J Queries,Compound Queries,KETTLE Queries,MQL Queries,SCRIPTING Queries,SQL Queries.

  2. #2

    Default

    I'm new on pentaho and I use "sql over sqlJdbc" in "SQL Queries". it works fine.
    set your connection properties as below :

    Name give_your_connection_name
    Driver com.mysql.jdbc.driver
    User name yourMySQL_userName
    Password yourMySQL_password
    URL jdbc:mysql://localhost/your_DataBase_Name
    Access Level Public
    Query select field1, field1, ... from Table (write your Query)
    Parameters []
    Output Options []
    Output Mode Include
    Columns []
    Calculated Columns []
    Cache Duration 3600
    Cache True

  3. #3
    Join Date
    Nov 2009
    Posts
    688

    Default

    When you declare a datasource in the Administration Console then you can use sql over sqljndi. Then jndi is the name of the datasource.

  4. #4
    Join Date
    Sep 2017
    Posts
    9

    Default

    hello

    I know this seems foolish but can you explain me why I cann't use sql over jndi without having at least one cube on that connection?

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.