IBM Infosphere BigInsights v2.1 supports integration with Tableau v8.0.0 for Business Intelligence reporting.
Below steps are outlined for Integration
1. Create customized Tableau/Biginsights configuration file "bigsql.tdc" with contents as below
|
<?xml version='1.0' encoding='utf-8' ?> <connection-customization class='genericodbc' enabled='true' version='7.10'> <vendor name='IBM BigInsights Big SQL' /> <driver name='IBM BIG SQL ODBC DRIVER' /> <customizations> <customization name='CAP_SUPPRESS_DISCOVERY_QUERIES' value='yes' /> <customization name='CAP_ODBC_USE_NATIVE_PROTOCOL' value='yes'/> <customization name='CAP_ODBC_BIND_SUPPRESS_PREFERRED_TYPES' value='yes'/> <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLCOLUMNS_API' value='no'/> <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLFOREIGNKEYS_API' value='yes'/> <customization name='CAP_ODBC_FETCH_CONTINUE_ON_ERROR' value='yes'/> <customization name='CAP_ODBC_ERROR_IGNORE_FALSE_ALARM' value='yes'/> <customization name='CAP_ODBC_METADATA_STRING_LENGTH_UNKNOWN' value='yes'/> </customizations> </connection-customization> |
-
Copy the tableau customized file bigsql.tdc to the path
C:\Users\<logged in user>\Documents\My Tableau Repository\Datasource
-
Download BigSQL Client package from BigInsights Web Console
"Quick Links" panel is provided in the Console welcome page
In the 'Quick Links' panel "Download the Big SQL Client drivers" link is available.
Save the client package on the local disk
-
ODBC Driver installation
Execute odbc installer "biginsights_odbc.exe installer exe"
Provide the DSN name
Provide the appropriate details and click on Next.
Click on Install.
The DSN created will be added to the odbc.ini file located at
C:\Program Files (x86)\IBM\IBM Big SQL Driver\win32\cfg\odbc.ini
[bigsql_poc]
HOST=<hostname>
PWD=<pwd>
UID=<uid>
DATABASE=<dbname>
FRAMED=0
PORT=7052
-
Configure Tableau for BigInsights
By using the above installed Big SQL ODBC driver, the tableau tool can connect to Big SQL server.
I) Launch Tableau Desktop Tool
II) Select ‘Connect to Data’
This will provide list of drivers to connect to database.
III) Select "Other Databases (ODBC)" option
IV) Select the DSN from the Drop down list and Validate the connection by using connect tab.
V) Select appropriate schema and table option. Click on OK
VI) Click on OK.
VII) Select Connect Live
VIII)Function usage
Select From Analysis -> Create calculated fields
Select the functions as shown in screen shot below appropriately
The required report can be developed, executed and saved in the Tableau.
