The Configuration Item Integration feature enables you to import CI records from one or more Microsoft SQL Server source databases into iSupport’s CMDB 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 Query 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.
Select Create in the Options and Tools | Integrate | CMDB Integration screen to create an integration definition. Use the Basics tab to specify the connection string, SQL query, authentication information, and synchronization interval.