Importing entities from an ODBC database - Card Synchronization 3.0

Card Synchronization Plugin Guide 3.0

series
Card Synchronization 3.0
revised_modified
2018-08-29

You can import entities from an external system using a database that supports ODBC and conforms to the Card Synchronization schema. After the import, changes made in that data source can be synchronized in Security Center.

Before you begin

  • In the external database, create a user for the plugin that only has read access to the required tables.
  • If ODBC Server is not on the Security Center server, make sure you have installed and configured your ODBC driver for the specified connection string.
  • Complete the steps outlined in Preparing to import entities.

What you should know

Including pictures in the data source increases import time.

Procedure

  1. From the Config Tool home page, open the Plugins task.
  2. In the Plugins task, select the Card Synchronization plugin role from the entity browser, and click the Properties tab.
  3. In the Data sources section, click Add data source ().
  4. In the dialog box, from the Data source type list, select Database.

  5. Configure the following settings:
    Name
    Enter a name for the data source.
    SQL server type
    Select ODBC from the list.
    Connection string
    Enter the connection string.
  6. Map each Entity type to a Table name from the corresponding drop-down list.
  7. Click Validate configuration.
    If the configuration is valid, the following message is displayed: No errors found.
  8. Click OK.
  9. Click Save and close, and then Apply.

Results

When a synchronization occurs, the database data source is added to the list of data sources, and the entities are created in Security Center.