Apache Kylin is an open source distributed analytics engine which provides OLAP on your massive data sets in Hadoop/Spark and lets you query them less than a second. Apart from Hadoop/Spark – Kylin will also let you connect to your data in RDBMS sources like SQL Server, MySQL, Postgres etc., using JDBC drivers.
In addition to RDBMS data sources, you can connect to a variety of data sources from Apache Kylin using Progress DataDirect JDBC Connectors including SaaS sources like Salesforce, JIRA, Oracle Eloqua, Google Analytics and RDBMS sources like SQL Server, DB2, MySQL, Postgres, OpenEdge etc. In this tutorial, we will show how you can connect and sync tables from Salesforce – but you can use the same steps with any Progress DataDirect JDBC Connectors.
Feel free to try the Progress DataDirect JDBC Driver for Salesforce to bring your Salesforce data to Apache Kylin for faster querying as well as any other Progress DataDirect JDBC drivers. Let us know if you have any questions as we are happy to help.