Click Add New Connection.
Enter a unique connection name here.
Tip: Connection names must be unique. It cannot exist in another group.
Select the connector type here
The available connector types are:
Enter the connection string for the connection here.
Loome Integrate provides the ability to select a template for connection strings from the example drop down.
The available connection example options are:
If a user ID and password are required to connect to the data Source (E.G. using SQL Server Standard example), enter the user ID here. The format of the user ID can be either domain\username or an email address.
If a user ID and password are required to connect to the data Source (E.G. using SQL Server Standard example), enter the password here.
Reenter the password.
Check this box to cache the table listings for large connections.
Connections with a large number of objects (tables and views) can take a long time to retrieve from the source. This delay can degrade the responsiveness of the Loome Integrate user interface. The table caching feature allows objects in a connection to be cached locally (text file) in Loome Integrate so that they don’t need to be retrieved every time a new task is setup.
Tip: Table caching is recommended only for connections with a very large number of tables or views.
A disk icon will display against the connection if it has been saved with this option checked. When a connection is deleted the cached table listing will be removed for the database table. When you edit a connection with the Cache Table Listings option, you will be presented with the following :
You can select to refresh the table list cache or remove the table cache altogether.
In this section, you can choose to add groups which this connection can be used in. By default the group where you create this connection will be selected. Add more groups for this connection by selecting the checkboxes.
Tip: At least one group must be selected.
When you have entered all the necessary connection details, click Verify Connection to validate the syntax and connectivity of the connection string.
You can choose to verify the connection at a later time by clicking Bypass Verify. Unverified connections will be highlighted in red in the connections list and a lock icon will display under the verified column.
Click Insert to save the verified/unverified connection.
Tip: Unverified connections will not be available for you to select when creating tasks.
To make changes to a connection, click on the corresponding pencil icon.
The list of connections will display the following columns:
Tip: A cross against a connection means that it is not being used and it can be deleted.
Connections that are currently being used by other processes or datasets cannot be deleted.
You will need to remove all references to the connection first before you can delete it.
Loome Integrate 5.2 gives you the ability to toggle between connection usage views.
Click Show Usage under the header to show 2 extra columns: