MS PowerBI and MS Gateway require an ODBC Driver to bridge to a JDBC data source such as INDEXIMA CLUSTER.
Create & Setup a DSN to identify and authenticate the INDEXIMA data source
Once your ODBC driver installed, run :
- MS ODBC Data Sources (64-bit)
- or ODBC Data Sources (32-bit) only if you have installed PowerBI in 32bit
Select the tab "System DSN" and the corresponding driver. Click the button "Add..."
The "DSN Setup" dialog appears. Fill the appropriate fields according to your authentication policy.
Setup Part 1 (General Parameters)
- Name your DSN
Keep the Data Source name simple. You will have to type this name each time you will use the connector.
- Fill in the fields with the information your INDEXIMA administrator provides you.
- Host, Port
- Authentication Mechanism
- The database can be left blank for allowing MS PowerBI to navigate in the dataspace schemas.
Go to "Password Options":
And select "All users of this machine":
Make sure your workstation is already set up for Kerberos authentication.
Select Kerberos if your INDEXIMA Data Engine is using Kerberos authentication and fill the fields: Realm, Host FQDN and service name with values provided by your security administrator as shown as below:
- Make sure you have a valid Kerberos ticket issued before using this DSN connection.
Setup Advanced Options
Click on the button Advanced Options.
Make sure the following options are ticked:
- Use Native Query
Get Tables With Query
Unicode SQL character type
Click on the OK button to validate the configuration change.
Setup Thrift Transport & Proxy options
Check Thrift Transport value: default value for indexima cluster is SASL
Make sure the SSL option is not enabled when there is no SSL.
Test the Setup
Click on the Test button to verify if your data source is reachable as shown in the following dialog.