Other Connection Options

Most Monarch Data Prep Studio connector dialog boxes provide a text box that allows you to enter additional connector options:

 

Notes:

  • If you need multiple string connection options, separate these by a semi-colon. Use the form: Option1=[value];Option2=[value];

  • You can only enter up to a maximum of 512  characters into this text box.

 

Options and valid values for specific connectors may be found here:

Connector

Options and Values

Amazon EMR Hive

https://docs.progress.com/bundle/datadirect-apache-hive-odbc-80/page/Connection-option-descriptions.html

Amazon Redshift

https://docs.progress.com/bundle/datadirect-amazon-redshift-odbc-80/page/Connection-option-descriptions.html

Cassandra

https://docs.progress.com/bundle/datadirect-apache-cassandra-odbc-80/page/Connection-option-descriptions.html

Cloudera CDH Hive

https://docs.progress.com/bundle/datadirect-apache-hive-odbc-80/page/Connection-option-descriptions.html

Cloudera Impala

https://docs.progress.com/bundle/datadirect-connect-odbc-71/page/Connection-Option-Descriptions_11.html

DB2

https://docs.progress.com/bundle/datadirect-ibm-db2-odbc-80/page/Connection-option-descriptions.html

Google BigQuery

https://docs.progress.com/bundle/datadirect-google-bigquery-odbc-80/page/Connection-option-descriptions.html

Hadoop Hive

https://docs.progress.com/bundle/datadirect-apache-hive-odbc-80/page/Connection-option-descriptions.html

Hortonworks Hive

https://docs.progress.com/bundle/datadirect-apache-hive-odbc-80/page/Connection-option-descriptions.html

HubSpot

https://docs.progress.com/bundle/datadirect-autonomous-rest-connector-odbc-80/page/Connection-option-descriptions.html

Informix

https://docs.progress.com/bundle/datadirect-ibm-informix-odbc-80/page/Connection-option-descriptions.html

MapR Hive

https://docs.progress.com/bundle/datadirect-apache-hive-odbc-80/page/Connection-option-descriptions.html

MySQL

https://docs.devart.com/odbc/mysql/connection_options.htm

NetSuite

https://docs.devart.com/odbc/netsuite/connection_options.htm

MongoDB

https://www.mongodb.com/docs/drivers/csharp/current/fundamentals/connection/connection-options/

Oracle

https://docs.progress.com/bundle/datadirect-oracle-odbc-80/page/Connection-option-descriptions.html

PostgreSQL

https://docs.progress.com/bundle/datadirect-postgresql-odbc-80/page/Connection-option-descriptions.html

ServiceNow

https://docs.progress.com/bundle/datadirect-autonomous-rest-connector-odbc-80/page/Connection-option-descriptions.html

SharePoint

https://docs.progress.com/bundle/datadirect-microsoft-sharepoint-odbc-80/page/Connection-option-descriptions.html

Spark SQL

https://docs.progress.com/bundle/datadirect-apache-spark-sql-odbc-80/page/Connection-option-descriptions.html

SQL Azure

https://docs.progress.com/bundle/datadirect-microsoft-sql-server-odbc-80/page/Connection-option-descriptions.html

SQL Server

https://docs.progress.com/bundle/datadirect-microsoft-sql-server-odbc-80/page/Connection-option-descriptions.html

Sybase IQ

https://docs.progress.com/bundle/datadirect-sybase-iq-odbc-80/page/Connection-option-descriptions.html

Teradata

https://docs.progress.com/bundle/datadirect-connect-odbc-71/page/Connection-Option-Descriptions_5.html

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support