Connections

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.

Note:  

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
  • Connection Name
  • Database Name
  • Server Name
  • User Name
  • Password (server-specific)
  • Ignore KSYNC tables within the data source
  • Use application labels as field names
  • Support Unicode
  • Specify Windows Authentication
  • Connection description
  • Adapter-specific settings
  • Prompt to reconnect when the DTS opens
  • Keep the connection open if it was used in the previous chained DTS file
  • SQL script to run before the DTS runs
  • SQL script to run after the DTS runs
Note:  
  • A DTS file that contains a converted connection cannot be opened in version 7.8.0 or earlier of Insight.
  • DTS Connection tab settings are only enabled for connections that are used in the current DTS.
  • If you move a DTS to another system, you must redefine the password for the connections on the new system. Passwords can be up to 127 characters.
  • If you close the DTS created in an earlier version of Insight without saving, the connections in that DTS are not converted.

See Also

Converting A Connection

Valid Connections

Using The Connection  Manager