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.
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.
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.
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.
Configuring DataDirect ODBC Driver with TARGIT and Building the Data Model
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 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.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.