Open topic with navigation
Insight Connections are the data objects that allow you to create an Insight integration. A connection is defined by a connection type, such as Dynamics CRM, NAV, or Scribe Sample Database, and information required to access a data source, such as the user name and password.
A connection can be used as a source, a target, both a source and target, an entry in a Rejected Row table, or a value in a formula or link. From the Connection Manager, you can create and manage your connections, and select connections to use as a source or targets.
Insight creates a global pool of connections that makes connection configuration information available to all DTS files on your Insight system. If a connection is modified to update the user name configured for a data source, all DTS files using that connection use the new user name when they access that data source. For example, if you configure a global Dynamics CRM connection and three DTS files need access to a Dynamics CRM system, all three DTS files can use that one connection. If the user password to Dynamics CRM is updated through one of those DTS files, all three DTS files use that updated password to connect.
When you open and save an existing DTS file created in Insight 7.8.0 or earlier, each connection used in the current DTS is converted either by creating a connection based on the properties of the original connection, or by using an existing connection with matching properties.
To convert connections in other DTS files created in earlier Insight versions, you must permit Insight to search for and convert matching connections in those other DTS files. For more information, see Converting A Connection.
Information about the connection, such as the user name used to connect, is available for all DTS files on your system, while information about how the DTS uses the connection, such as a script that runs before the DTS runs, is saved in the DTS:
|Global Connection Settings||DTS Connection Settings|
Converting A Connection
Using The Connection Manager