Audience: Data Owners and Users
Content Summary: Rapid SQL is a popular SQL IDE from Embarcadero. This page outlines the process of registering the Immuta Query Engine as a
Datasourcein Rapid SQL.
Prerequisite: You must set up your Immuta SQL account before using the Immuta Query Engine with Rapid SQL. See Creating an Immuta user SQL account for details.
In the Rapid SQL menu bar, open the DATASOURCE menu and select Register Datasource.
On the Database Type page, choose PostgreSQL, and then click Next.
On the Connection Information page, enter the host and port. Enter
immutain the Database field and a name in the Datasource field. Then click Next.
Enter the username and password that you configured in your Immuta Profile SQL Credentials, and then click Next.
On the Custom Driver Properties page, click New, enter the property name and value listed for
sslmodebelow, and then click OK. Repeat this process for
After entering the Custom Driver Properties, you can click Finish to complete the
You have successfully configured your Immuta
Datasourcein Rapid SQL. You can right click on the
Datasourcename, and choose Connect to connect the Immuta
You have successfully configured Rapid SQL with a connection to your Immuta Query Engine. From here you can run queries against the tables you have access to in the Immuta Query Engine. For more information about accessing data using the Query Engine see the SQL Access Pattern.