Home Partners Company
Integrating Your Cassandra NoSQL DB with TARGIT BI via ODBC

Integrating Your Cassandra NoSQL DB with TARGIT BI via ODBC

June 08, 2016 0 Comments

In this latest post from our tutorial rumble, Sanjeev Aggarwal guides you through integrating TARGIT with Apache Cassandra via DataDirect ODBC.

TARGIT is a business intelligence solution with dashboards, analytics, reporting and a data discovery platform that is accessible on all devices and platforms. Apache Cassandra is a NoSQL open-source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.

Connecting TARGIT and Cassandra with DataDirect ODBC

As an organization, you want to feed as much relevant data into your business intelligence solution as possible in order to come up with more informed decisions/predictions. However, currently TARGIT does not offer any native connectivity to Cassandra.

Luckily, Sanjeev Aggarwal has developed step-by-step instructions on how DataDirect ODBC can help you easily integrate your Cassandra data with TARGIT and make it look like any other relational database. While this guide is for Cassandra, these steps can also be applied to any of the data sources on our ever-expanding list of ODBC connectors.

Getting Started

Download the free 15-day trial of the DataDirect ODBC driver for Cassandra. TARGIT BI is a 64-bit application, so download the 64-bit driver and create a 64-bit data source.

  1. Open ODBC Data Source Administrator (64-bit) and select the "System DSN" tab.
  2. Click on "Add" to create an ODBC data source for Cassandra.

    Click on Add to create an ODBC Data Source for Cassandra

  3. From the "Create New Data" source window, select "DataDirect Apache Cassandra" and select "Finish."

    From the Create New Data source window select DataDirect Apache Cassandra and select Finish

  4. Configure the data source by entering the "Data Source Name," "Host Name," "Port Number" and the name of the Cassandra database ("Keyspace Name") to which you want to connect. The "Schema Definition Path" will be automatically generated for you, but feel free to specify your own location for where you would like the schema files to be generated. Make sure you have full permission for this folder.


    Schema Tool Note
    : The DataDirect Cassandra driver will automatically generate a schema for you without you having to open up the Schema Tool.

    Click on "Test Connect" and ensure that your connection is established.

    Click on Test Connect and ensure that your connection is established

  5. Refer to the DataDirect Cassandra ODBC user's guide for details on other connection options under the "Advanced" and "SQL Engine" tabs.

Configuring DataDirect ODBC Driver with TARGIT and Building the Data Model

  1. Download and install TARGIT DecisionSuite.
  2. Run TARGIT Management, select the local server and click on “Manage Server.”

    2.	Run TARGIT Management, select the local server and click on “Manage Server”.

  3. Select "Connections" from the left-side menu, right click somewhere on the right side and choose "Add."

    Select Connections from the left side menu, right click somewhere on the right side, and choose 'Add'

  4. Choose "Relational Database" from the "Connection Type" window.

    Choose "Relational Database" from the Connection Type window.

  5. As you see in the list, TARGIT does not support native connectivity to Cassandra. Therefore, you will select "Generic" to setup an ODBC connection.

    select Generic to setup an ODBC connection

  6. Enter the name for your connection. We will call it "Cassandra." The "Description" field is optional.

    Enter the name for your connection. We will call it Cassandra. The Description field is optional.

  7. To generate the ODBC connection string using the ODBC DSN you created earlier, select "Change connection string."   

    To generate the ODBC connection string using the ODBC DSN we created earlier, select "Change connection string".

  8. In the "Data Link Properties" window, go to the "Connection" tab and choose "Use data source name." Then from the drop-down menu, select the ODBC data source that you created earlier ("Cassandra," in this example).
  9. If your database requires authentication, then provide the user name and password and select "Allow saving password." Select "Test Connection" to make sure your connection is successful.

    Right click on the Cassandra connection you just created and select Edit data model.

  10. Press "OK" to exit from Data Link Properties and save the "Generic Connection String." You should now have the ODBC connection to Cassandra.
  11. Right click on the Cassandra connection you just created and select "Edit data model."

    Right click on the Cassandra connection you just created and select Edit data model.

  12. This will open up the Relational Datamodel Editor and display the schema for the database you are connected to. Select and drop the EMP schema to the data model and create a new cube called "EMPLOYEES."

    Select and drop the EMP schema to the data Model and create a new cube EMPLOYEES

  13. You can add dimensions, measures, calculations and more to the cube by dragging the columns to the correct folder and build hierarchies by dropping them on top of each other.

    One can add dimensions, measures and calculations and more

  14. Save your data model after you are done adding tables and creating hierarchies and start analyzing your data with TARGIT.

Start analyzing your data with TARGIT

Get started today

Now that you have integrated TARGIT with Cassandra, you are one step closer to achieving your business intelligence goals. Remember, these same steps also apply to any of our ever-expanding list of data sources for ODBC connectors. Pick up your 15-day free trial of our Cassandra ODBC connector and get on your way to achieving high-performance data connectivity.

15-day free trial.

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Read next JDBC Tutorial: Extracting Database Metadata via JDBC Driver
Comments
Comments are disabled in preview mode.