Connectors: Miscellaneous Notes
Connection Strings that Exceed 1020 characters
For connectors that use ODBC Drivers Monarch Data Prep Studio use a DSN-less connection.
However, the .NET ODBC Driver does not support Connection Strings longer than 1024 characters (OdbcConnection.ConnectionString Property (System.Data.Odbc) | Microsoft Learn).
For Connection Strings that exceed 1020 for the following workaround is implemented:
- A File DSN is temporarily created, but only for the following operations: Test Connection, Load Tables and Preview Data
- The following is included in the File DSN: Access Token and Refresh Token.
The rest of the connection options become part of the connection string.
If the connection string reaches 1020 characters, the following error message is dispayed: “Connection string exceeds maximum allowed length of 1024.” - The File DSN is deleted after connection.
Support for Progress Short Names/Aliases
Progress short names are supported by this release of Monarch Data Prep Studio, specifically in the Other Connection Options field.
Example
- Enter LGCF=Test in the Other Connection Options
- Select Test Connection
Result
This will set the value of “Log Config File“ to “test“, as LGCF is the short name for Log Config File.
As a reference the driver configuration file will have an Aliases entry, for instance:
"LogConfigFile":
{"StandardKey":"LogConfigFile",
"DataType":"Text",
"Aliases":"lgcf",
"DisplayName":"UiLogConfigFile|",
"AutomationID":"ServiceNow.LogConfigFile.TextBox",
"HelpText":"UiHelpLogConfigFile|"},
© 2024 Altair Engineering Inc. All Rights Reserved.