Once a connection has been added to or selected from the Connection Manager, you still need to connect in the DTS But the connection URL or type (OnPremise, Online or IFD) would be different Global connections require a separate connection and name/label for each When a DTS is opened and the connection information doesn't match any entries in the Connection Manager, Scribe will prompt you to create a new connection or select an existing connection
For example in CRM the connection name could be Adapter for Dynamics CRM. In prior versions of Scribe, it was possible for different connections to use the same name. These are two distinct and separate operations.Ĭonnections can be cascaded to other DTS’s in the same folder and in any subfolders Only DTS’s that fully match the DataProvider connection and DSRProperties entries are selected If no Global connection exist – connect as you usually would Note: The creation of a connection in the Connection Manager is not the same as connecting to a source or target in the DTS. Prior to Insight version all connection configuration information was saved in the DTS Starting with all connections are stored globally so that they can be used in multiple DTS’s Common connection information is in the ScribeInternal DB DTS specific settings remain stored in the DTS 7.9.1 Has new features to allow you to select an existing connection Prior to that you were forced to create a new connection even if you knew an existing connection would workĢ Connection Manager A new connection is required for each unique combination of Connection Settings (except password) This also includes any adapter properties that are considered part of the connection IsConnectionProperty = Yes Edit DTS – Search XML for Adapter PropertiesĬonnection information is stored in the DataProvider or DRSProperties tables in ScribeInternal Only adapter properties where IsConnectionProperty = Y are stored in DRSPropertiesĮxisting connections are now shown in the Connection Manager Select an existing connection or create a new one Naming convention has become an important consideration Presentation on theme: "Connection changes in Scribe Starting with version 7.9.0"- Presentation transcript:ġ Connection changes in Scribe Starting with version 7.9.0