Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: From Pentaho Report having issue in joining multiple tables from multiple servers

  1. #1

    Default From Pentaho Report having issue in joining multiple tables from multiple servers

    Hi Team,

    I am using Pentaho Report for generating PDF's. Right now I am facing issue with Report to get data from multiple MySql server tables joining together.

    Let me explain the problem: I need to show some data on the report by connecting multiple MySql servers (Server#1, Server#2) from different database tables (Database#1 Table#1, Database#2 Table#2) and join those tables to get the desired results. Right now, from pentaho report designer when I was trying to execute the query by joining with different tables. it is not able to recognize the other server and so not executing the query. I created separate JNDI connections to connect to two MySql servers in Pentaho report designer.

    I am able to connect and get the information from two different servers when I execute them with separate queries, but if I join both queries together I am not able to get the results when I tried to preview the query. Even I tried to add Connection Name/JNDI Connection name before database and table name like below but no luck.

    DevServerConnection.DB1.Table1
    DevServerJNDIConnection.DB1.Table1

    Environment Details:
    MySql Community edition
    Connecting to MySql from Pentaho Report using JNDI configuration

    Please help me out regarding this issue ASAP.

    Thanks,
    Mahesh

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    You can use PDI as a datasource in your report and join the 2 tables within PDI

  3. #3

    Default

    Hi,

    Thank you for the reply. I don't want to use PDI or other tools. From Report designer only I want to join multiple tables from different MySQL servers.

    Thanks,
    Mahesh

  4. #4
    Join Date
    May 2017
    Posts
    20

    Default

    From your primary Server, make sure you have linked servers, and that you can write your SQL query within your MySQL tool(WorkBench, etc.) if your query is successful there, you can write it directly into your report in the data section.

    But if your query will not work when you run\test it directly on your Server, within your tools, then it will not run successfully within Report Designer.

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.