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 |
|
|
Amazon Redshift |
|
|
Cassandra |
|
|
Cloudera CDH Hive |
|
|
Cloudera Impala |
|
|
DB2 |
https://docs.progress.com/bundle/datadirect-ibm-db2-odbc-80/page/Connection-option-descriptions.html |
|
Google BigQuery |
|
|
Hadoop Hive |
|
|
Hortonworks Hive |
|
|
HubSpot |
|
|
Informix |
|
|
MapR Hive |
|
|
MySQL |
|
|
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 |
|
|
ServiceNow |
|
|
SharePoint |
|
|
Spark SQL |
|
|
SQL Azure |
|
|
SQL Server |
|
|
Sybase IQ |
|
|
Teradata |
© 2024 Altair Engineering Inc. All Rights Reserved.