Default connections allow SmartConnect users to define connection strings for data connections that will be used multiple times throughout SmartConnect. This allows data connections to be maintained in a single place instead of requiring connection maintenance on each map. Default connections may be used in Tasks, Data Sources, Destinations and Scripts.
The following default connections may be defined within SmartConnect.
• | GP Query Connections - used within GP query data sources, and scripting. |
• | MSSQL Connections - used within MSSQL Change data source, MSSQL Stored Procedure and Table destinations, MSSQL Command and Validation tasks, MSSQL Lookup columns and scripting. |
• | ODBC Connections - used within ODBC data sources and scripting. |
• | OLEDB Connections - used within OLEDB data sources and scripting. |