Apache Drill is an open source SQL query engine for Big Data Exploration tool that can connect to various data sources and provide a common SQL interface to them, delivering self-service data exploration capabilities to the data stored in multiple formats. In this tutorial, we will go through on how you can connect to your data in in any Relational, NoSQL, Big Data or SaaS applications and query it using Apache Drill RDBMS Storage plugin and Progress DataDirect JDBC drivers. The tutorial will focus on SQL Server and Salesforce as an example, but you can use similar process to query any data source using Progress DataDirect JDBC drivers.
- Go to Drill Terminal and type the below command to see all the schemas available
- You should see a list of schemas as shown below.
- Now select the Schema where your tables are residing. Your tables would be residing in sforce.SFORCE schema. Choose that schema by running the below command.
- Run your queries against the tables in your Salesforce as shown below
We hope that this tutorial helped you to query your data sources using Apache Drill. We offer a broad range of enterprise JDBC drivers for Relational, Big Data, No SQL and SaaS data sources. Feel free to try any of our drivers with Apache Drill and follow the similar process as shown in this tutorial.