Add Connections
Add New Connection
Click Add New Connection.
Connection Name
Enter a unique connection name here.
Tip: Connection names must be unique. It cannot exist in another group.
Connector Type
Select the connector type here
The available connector types are:
- Oracle Data Provider (ODP) Connector
- Microsoft SQL Server Connector
- ODBC Connector
- OLEDB Connector
- Azure Blob Storage Connector
- Master Data Services Connector
- Kepion Planning Connector
- XMLA Connector
- SharePoint Connector
- Salesforce Connector
- Microsoft Dynamics 365 Connector
- Microsoft Dynamics CRM Connector
- Google Analytics Connector
- Google AdWordsConnector
- MailChimp Connector
- YouTube Connector
- YouTube Analytics Connector
- QuickBooks Online Connector
- JIRA Connector
- Google BigQuery Connector
- Azure Storage Connector
- MySQL Connector
- Excel Connector
- Twitter Connector
- Facebook Connector
- Active Directory Connector
Connection String
Enter the connection string for the connection here.
Connection Examples
Loome Integrate provides the ability to select a template for connection strings from the example drop down.
The available connection example options are:
- Oracle Data Provider (ODP) Connector
- Microsoft SQL Server Connector
- ODBC Connector
- OLEDB Connector
- Azure Blob Storage Connector
- Master Data Services Connector
- Kepion Planning Connector
- XMLA Connector
- SharePoint Connector
- Salesforce Connector
- Microsoft Dynamics 365 Connector
- Microsoft Dynamics CRM Connector
- Google Analytics Connector
- Google AdWordsConnector
- MailChimp Connector
- YouTube Connector
- YouTube Analytics Connector
- QuickBooks Online Connector
- JIRA Connector
- Google BigQuery Connector
- Azure Storage Connector
- MySQL Connector
- Excel Connector
- Twitter Connector
- Facebook Connector
- Active Directory Connector
Connection User
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.
Connection Password
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.
Confirm Password
Reenter the password.
Cache Table Listings
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.
Groups for this Connection
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.
Action Buttons
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.
List of connections
To make changes to a connection, click on the corresponding pencil icon.
The list of connections will display the following columns:
- Connection Type - the connection type
- Connection Name - the connection name
- Connection String - the connection string
- User - the connection user (if applicable)
- Verified - whether the connection has been verified
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.
Show Usage/ Hide Usage
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:
- Used in Task - shows the tasks where the connection is being used
- Used in Dataset - shows the datasets where the connection is being used
