Altair® Monarch®

 

Other Connector 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

Active Directory

http://cdn.cdata.com/help/CDF/odbc/Connection.htm

Amazon EMR Hive

https://documentation.progress.com/output/DataDirect/odbchivehelp/index.html#page/odbchive%2Fconnection-option-descriptions.html%23

Amazon Redshift

https://documentation.progress.com/output/DataDirect/odbcredshifthelp/index.html#page/redshift%2Fconnection-option-descriptions.html%23

Box Cloud Storage

http://cdn.cdata.com/help/BBF/odbc/Connection.htm

Cassandra

http://cdn.cdata.com/help/RCF/odbc/Connection.htm

Cloudera CDH Hive

https://documentation.progress.com/output/DataDirect/odbchivehelp/index.html?#page/odbchive%2Fconnection-option-descriptions.html%23

Cloudera Impala

https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2FConnection_Option_Descriptions_9.html%23

DB2

https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2Fthe-db2-wire-protocol-driver.html%23

Google Ads

http://cdn.cdata.com/help/DZF/odbc/Connection.htm

Google BigQuery

http://cdn.cdata.com/help/DBF/odbc/Connection.htm

Google Drive

http://cdn.cdata.com/help/RGF/odbc/Connection.htm

Google Sheets

http://cdn.cdata.com/help/RLF/odbc/Connection.htm

Hadoop Hive

https://documentation.progress.com/output/DataDirect/odbchivehelp/index.html?#page/odbchive%2Fconnection-option-descriptions.html%23

Hortonworks Hive

https://documentation.progress.com/output/DataDirect/odbchivehelp/index.html?#page/odbchive%2Fconnection-option-descriptions.html%23

Hubspot

http://cdn.cdata.com/help/DHF/odbc/Connection.htm

Informix

https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2Fconnection-option-descriptions.html%23

Jira

http://cdn.cdata.com/help/BJF/odbc/Connection.htm

MapR Hive

https://documentation.progress.com/output/DataDirect/odbchivehelp/index.html?#page/odbchive%2Fconnection-option-descriptions.html%23

MySQL

http://cdn.cdata.com/help/DMF/odbc/Connection.htm

NetSuite

http://cdn.cdata.com/help/DNF/odbc/Connection.htm

OData

http://cdn.cdata.com/help/RDF/odbc/Connection.htm

Oracle

https://documentation.progress.com/output/DataDirect/odbcoraclehelp/index.html?#page/odbcoracle%2Fconnection-option-descriptions.html%23

PostgreSQL

https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2Fconnection-option-descriptions-for-postgresql-wi.html%23

SharePoint

http://cdn.cdata.com/help/RSF/odbc/Connection.htm

Spark SQL

http://cdn.cdata.com/help/ESF/odbc/Connection.htm

SQL Azure

https://documentation.progress.com/output/DataDirect/odbcsqlserverhelp/index.html#page/odbcsqlserver%2Fconnection-option-descriptions.html%23

SQL Server

https://documentation.progress.com/output/DataDirect/odbcsqlserverhelp/index.html#page/odbcsqlserver%2Fconnection-option-descriptions.html%23

SugarCRM

http://cdn.cdata.com/help/CCF/odbc/Connection.htm

Sybase IQ

https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2FConnection_Option_Descriptions_11.html%23

Teradata

https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2FConnection_Option_Descriptions_12.html%23

Zendesk

http://cdn.cdata.com/help/FZF/odbc/Connection.htm