• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates
  • Administration
  • Log in to participate

▼ Tags

 

▼ Archive

  • January 2014
  • September 2013
  • December 2012
  • July 2012
  • March 2012
  • November 2011
  • October 2011

▼ Blog Authors

IBM Big Data

View All Entries
Clicking the button causes a full page refresh. The user could go to the "Entry list" region to view the new content.) Entry list

Integrating IBM Infosphere BigInsights with Tableau.

RaviPrasad.Pentakota 270006J3KR | ‎ | 3 Comments ‎ | 14,455 Views

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>

  1. Copy the tableau customized  file bigsql.tdc to  the  path
    C:\Users\<logged in user>\Documents\My Tableau Repository\Datasource
     
  2. Download  BigSQL Client package from BigInsights Web Console
    "Quick Links" panel is provided in the Console welcome pageimage

 

      In the 'Quick Links' panel  "Download the Big SQL Client drivers" link is available.

image

 

Save the client package on the local disk

  1. ODBC Driver installation
    Execute odbc  installer "biginsights_odbc.exe installer exe"
    image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Provide the DSN name

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Provide the appropriate details and click on Next.

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

  1. 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

image

 

 

 

 

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

II) Select ‘Connect to Data’

This will provide list of drivers to connect to database.

image

 

 

III) Select  "Other Databases (ODBC)"  option

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

IV) Select the DSN from the Drop down list and Validate the connection by using connect tab.

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

V)  Select appropriate schema and table option. Click on OK
image

 

 

 

 

 

 

 

 

VI)  Click on OK.

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


VII) Select Connect Live
image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

Modified on by RaviPrasad.Pentakota 270006J3KR
  • Add a Comment Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry
Notify Other People
notification

Send Email Notification

+

Quarantine this entry

deleteEntry
duplicateEntry

Mark as Duplicate

  • Previous Entry
  • Main
  • Next Entry
Feed for Blog Entries | Feed for Blog Comments | Feed for Comments for this Entry