How to Connect Tableau With Infor LN Data Lake

Hi ,

I have a requirement to connect Tableau or Power Bi with Infor LN Datalake. Please let me know the possibility solution to establish connection between tableau / power BI with Infor LN.

Thanks in advance,

Vadivel

Find more posts tagged with

Infor Data Fabric

Accepted answers

unknown

Hi Vadivel,

Are you looking to connect Tableau Desktop or another Tableau product to get data from Data Lake?

Typically, analytics is as much about beautiful content and designer experience as it is about performance and speed. To that end, it's usually wise to implement a data warehouse between something like a big data platform (e.g. Data Lake) and solutions with typically speedy expectations of performance such as analytics and reporting.

In any case, I would recommend starting with getting a copy of the Compass JDBC driver and ensuring you've acquired your ION API credentials file (.ionapi). For more details, see the Compass JDBC setup How To guide.

Afterwards:

Place a copy of the Compass JDBC driver into the appropriate Tableau driver directory
1. For Windows, the Drivers folder is in: C:Program FilesTableauDrivers
2. For MAC, the Drivers folder is in: /Users/<username>/Library/Tableau/Driver
Place a copy of your .ionapi file into the same Tableau driver directory
Using your favorite text editor, create a new file named "datalake.properties" and within the file:
- On the first line of the file, type: "ionApiCredentials="
- On the second line, enter the left curly brace: "{"
- On the next line, enter in the contents of your .ionapi file
- On the final line, enter the right curly brace: "}"
- Save your file
Place your "datalake.properties" file into the same Tableau driver directory

Here's an example of what you should expect with the file you've created:

And, here's a snapshot of what you should see in your drivers directory for Tableau:

Once you launch Tableau Desktop, you can use their JDBC driver connection and pass your tenant URL using the SQL92 dialect. You shouldn't need to enter a username or password.

Again, I would definitely recommend that if this is really an enterprise analytics scenario, going directly to big data platforms may not make your analytics users as happy as a data warehouse. The two typically end up being complementary to one another

All comments

unknown

Hi Vadivel,

Are you looking to connect Tableau Desktop or another Tableau product to get data from Data Lake?

Afterwards:

Place a copy of the Compass JDBC driver into the appropriate Tableau driver directory
1. For Windows, the Drivers folder is in: C:Program FilesTableauDrivers
2. For MAC, the Drivers folder is in: /Users/<username>/Library/Tableau/Driver
Place a copy of your .ionapi file into the same Tableau driver directory
Using your favorite text editor, create a new file named "datalake.properties" and within the file:
- On the first line of the file, type: "ionApiCredentials="
- On the second line, enter the left curly brace: "{"
- On the next line, enter in the contents of your .ionapi file
- On the final line, enter the right curly brace: "}"
- Save your file
Place your "datalake.properties" file into the same Tableau driver directory

Here's an example of what you should expect with the file you've created:

And, here's a snapshot of what you should see in your drivers directory for Tableau:

Once you launch Tableau Desktop, you can use their JDBC driver connection and pass your tenant URL using the SQL92 dialect. You shouldn't need to enter a username or password.

lbarbour

HI Mike,

Thanks for your guide. It is quite straight forward to follow.

I am having an issue with logging in via Tableau as it cannot find the ionapi file. The file is in the same directory as the .jar file and the name is correct. Are there any more tips you can provide for trouble shooting?

Thanks!

unknown

Hey Michael, did you end up creating that datalake.properties file and store it in the same directory?

lbarbour

Hi Mike, I have created that one and stored it in the same directory. I've followed the instructions here, but still receive the error. Could it have something to do with folder/file permissions?

unknown

Hey all,

I've made a minor change to reflect some updates from our development team. When creating your datalake.properties file, ensure that the contents of your .ionapi file are on a single line and not pretty printed or otherwise formatted.

Alternatively, you can leverage some new authentication methods with the Compass JDBC driver. Documentation on how to do exactly that

Copyright © 2025 Infor. All rights reserved.