Databricks Delta Connector

Back Next

Configure Secure Agent properties

When you configure mappings, the SQL warehouse processes the mapping by default.

To process the mappings on Databricks cluster, enable the Secure Agent properties.

To connect to analytics cluster and job cluster, enable the Secure Agent properties for design time and runtime respectively.

Before you can import metadata and design mappings or mappings in advanced mode, perform the following steps:

In Administrator
, select the Secure Agent listed on the Runtime Environments
tab.

Click Edit
.

In the System Configuration Details
section, select Data Integration Server as the Service
and Tomcat JRE as the Type
.

Edit the JRE_OPTS
field and set the value to

-DUseDatabricksSql=false

In Administrator
, select the Secure Agent listed on the Runtime Environments
tab.

Click Edit
.

In the System Configuration Details
section, select Data Integration Server as the Service
and DTM as the Type
.

Edit the JVMOption
field.

To run mappings, set the value to

-DUseDatabricksSql=false

To run mappings enabled with pushdown optimization, set the value to

-DUseDatabricksSqlForPdo=false