Importing entities from an SQL Server 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 Microsoft SQL Server database that 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 Microsoft SQL Server is not on the Security Center server, make sure that the SQL Server instance is reachable using the connection type (TCP, OLE DB, and so on) specified in the 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 Microsoft SQL Server from the list.
    Use integrated security
    This option is selected by default. Leave this check box selected so you can connect to the database server without having to expose your password.

    Clear this check box to connect to the database server using a connection string.

    Server
    Select the SQL server from the list.
    Database
    Select the database from the list.
    Connection string
    Enter the connection string. This option is only available when the Use integrated security check box is cleared.
  6. Map each table name to an entity type by selecting the 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.