Creating an Asset RDB Integration Definition Creating an Asset RDB Integration Definition
Select Asset RDB from the Data Source Integration Create menu to import asset data from one or more Microsoft SQL Server source databases into iSupport’s Asset database, and synchronize with those source databases on an interval basis. You’ll enter a connection string and SQL query, and then click the Test button to display columns in the source database on the Field Mappings tab for specific field mapping options. You can schedule synchronization to occur on an interval basis. If a matching field exists in the source database, the record will be updated in iSupport’s Asset database.
Use the Basics tab to specify the connection string, SQL query, authentication information, and synchronization interval. Fields are described below; use the following links for information on the rest of the tabs.
Completing the Field Mappings Tab
Completing the Synchronization Tab
Microsoft SQL Server Source Name |
Enter a name for the SQL Server source definition. This name will appear in the list of integration definitions and in the Source field in the associated Asset record. |
Connection String |
Enter the connection string for accessing the source database. |
SQL Query |
Enter the SQL query string for accessing the asset-specific SQL columns in the source database. Click the Test Query button to populate the SQL Columns field on the Field Mappings tab. |
Authentication Username Password |
Select the type of authentication to be used to access the source SQL Server database: Windows Authentication or SQL Server Authentication. If using Windows Authentication, the database must have both of the iSupport user IDs listed, with the db_owner and public roles. If using SQL Server authentication, enter the user name and password for accessing the server. |
Active |
Select Yes to enable the Asset Synchronization agent that updates the records in the iSupport Asset database with the information in the SQL source database. |
Asset Synchronization Interval |
Select the number of minutes in the interval for the synchronization to be performed. |
