Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Uploading the Database Driver

Info
titleINFO

Set up the database driver in the 'Admin' tab.

Configuring Azure Databricks as a Connection 

...

  1. Click the "+" button and select "Connection" or right-click in the File Browser and select "Create New" → "Connection"The "New Connection" tab appears in the menu bar.
     or 
  2. Select "Databricks" from the drop-down and confirm with "Next"The type is displayed in the drop-down.
     
  3. Enter the connection string from the database driver. 
    INFO: End the connection string with ';UseNativeQuery=1'.
    INFO: Note that the pattern must contain the expression 'token' as the 'UID' parameter and the '<personal-access-token>' as the 'PWD' parameter that you created both in Azure Databricks before. 
     
  4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next"The 'Safe Save Connection' tab opens.
     
  5. If needed, enter a description and confirm with "Next"The 'Save Connection' dialog opens.
     
  6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save"The connection is saved. Configuring Azure Databricks as a JDBC connection is finished. 
     

...