Connecting to Cloudera Impala
You can connect your Cloudera Impala account to the Celonis Platform using a JDBC connector, available from Cloudera directly. This connector is then used with the Celonis JDBC extractor, available from the download portal.
To connect to your Cloudera Impala account, follow these steps:
Step 1: Download and install the Cloudera Impala connector
The first step is to download and install the latest JDBC connector for Cloudera Impala:
Download the relevant driver from the Cloudera website: Cloudera.com - Impala JDBC Connector
Extract the zipped file and follow the installation guidance provided in the 'docs' folder.
For example:
Step 2: Download and extract the Celonis JDBC extractor
You can now download the latest Celonis JDBC extractor from the Celonis Download Portal (which requires admin access to your Celonis Platform team).
Click Admin & Settings.
Click Download Portal.
Download the latest JDBC (database) Extractor.
Extract the zipped file locally.
The next step is to adapt the application-local.yml file to include your Cloudera account and your Celonis Platform team details:
From the Celonis JDBC extractor extracted above, open the application-local.yml file.
Edit the client ID, client secret, and URL fields:
Client ID: This is from your Cloudera account.
Client secret: This is from your Cloudera account.
URL: Replace the [team] and [eu-1] with your Celonis team ID and your realm. This information can be obtained from your Celonis Platform URL once logged in.
You now need to create the .jar directory for the Cloudera .jar file:
Create a directory named 'jar' and move the .jar file from the extracted Cloudera connector file into this folder.
From this directory, run the following command (referencing the correct file name of the .jar file):
java -Dloader.path=jar -Dspring.config.location=application-local.yml -jar connector-jdbc.jar
You can now create the connection between Cloudera Impala and the Celonis Platform from your data pool diagram:
Click Data Connections.
Click Add Data Connection and select Connect to Data Source.
Select Cloud - Database.
Configure the following connection details:
Name: An internal reference for this data connection.
Database type: Select Cloudera Impala.
Configuration type: Select Custom JDBC String.
JDBC connection string: This depends on your connection configuration:
When using SSL:
jdbc:impala://yourImpalaHostname:yourImpalaPort;AuthMech=3;
When using SSL and a certificate file: Add the certificate to the JDK keystore and then add the following string:
jdbc:impala://yourImpalaHostname:yourImpalaPort;AuthMech=3;SSL=1;
When using SSL and a .jks file: Change the SSLTrustStore parameter to the directory of the .jks file containing the SSL key and set the SSLTrustStorePwd to the correct password. Then add the following string:
jdbc:impala://yourImpalaHostname:yourImpalaPort;AuthMech=4;SSLTrustStore=<path>/<to>/<file>/cacerts.jks; SSLTrustStorePwd=changeit;tsasltransportbufsize=1000;usenativequery=0;useonlysspi=1;usesqlunicodetypes=0;
Schema name: The schema you want to use.
Additional properties: Not needed.
Username and password: Enter the details from your Cloudera Impala account.
Click Test Connection and correct any highlighted issues.
Click Save.
The connection between your Cloudera Impala account and the Celonis Platform is establised. You can manage this connection at any time by clicking Options:
