2

I have a local instance of the Pentaho Report Designer running on my box and it has a local development database configured as its data sources. (2 datasource configs, both pointing to the same local data server; source and target databases.)

Obviously, when I publish this report to the production BI server the reports fail because my local datasources are no longer reachable.

Clearly configuring the report to rely on the production databases would resolve any identity crisises (crisi?) but I live in the sticks so network is slow and I don't want to impact the production DB for development purposes.

In Kettle, I have updated the kettle.properties file to provide localized datasource variables (Great for unit testing my transformations!) and was wondering if there is a similar method for localizing variables in PRD?

demongolem
  • 9,474
  • 36
  • 90
  • 105
Lorin S.
  • 754
  • 8
  • 29

2 Answers2

3

In PRD, you use JNDI connections to have the same sort of abstraction. You can find the JNDI configuration in $HOME/.pentaho/simple-jndi. Create a datasource there and a datasource with the same name in the BI-Server's admin-console. Then define your connection as "JNDI" connection type and mention that name you given your datasources.

Then, depending on whether you run local or on the server, the engine will lookup the connection info from the runtime context.

But one warning: Given the fact that SQL is not a real standard, make sure that your local and remote environment use the same database type. Otherwise, if you - for instance - use MySQL on the client and Oracle on the server, your SQL created for MySQL will not be accepted by the oracle driver and vice versa.

Thomas Morgner
  • 412
  • 2
  • 2
  • Ok.. great. I was thinking JNDI was the direction but wanted to make sure I wasn't creating any extra work or missing something obvious. Thanks! – Lorin S. Feb 17 '12 at 14:30
  • and, what about mongodb? since mongodb is not a relational database, there is no JDBC driver. So, there is no way to configure a jdbc datasource. – KikoV Jan 08 '14 at 17:34
  • @thomas can you please tell me how this will work (depending on whether you run local or on the server, the engine will lookup the connection info from the runtime context.)? i mean how it will distinguish on url part whether to use localhost or specific serverip. – Helping Hand.. Jan 18 '16 at 07:19
0

On Windows you find the jndi config file here:

C:\Users\(username)\.pentaho\simple-jndi
Markus
  • 1,360
  • 1
  • 16
  • 22