: Set up AssetCentre for Integration
Focus
Focus

Set up AssetCentre for Integration

Table of Contents

Set up AssetCentre for Integration

Set up AssetCentre for integration with
IoT Security
through
Cortex XSOAR
.
There are multiple components within the Rockwell AssetCentre architecture. When setting up AssetCentre for integration with
IoT Security
, Microsoft SQL servers, which are responsible for storing and managing the underlying data that AssetCentre uses, are particularly important.
The only setup required for AssetCentre to support integration with
IoT Security
is the creation of a user account for
Cortex XSOAR
to authenticate itself to one or more of the Microsoft SQL servers when connecting. You can configure the user account in Microsoft SQL Server Management Studio. While logged in, also note the hostname or IP address and the name of the SQL servers and the port number on which they listen for connection requests.
  1. Configure a user account for
    Cortex XSOAR
    .
    1. Log in to the Microsoft SQL Server Management Studio with an account that has permissions to create user accounts.
    2. Click
      Security
      in the navigation panel, right-click
      Logins
      , and then click
      New Login
      .
      The Login - New dialog box appears.
    3. In the General panel, configure a user account with either Windows authentication or SQL Server authentication and specify a default SQL database to which the account has access.
      Windows authentication
      : Select this option to authenticate the user through Active Directory.
      Login name
      : Enter the Windows DOMAINNAME\USERNAME for a user that was previously configured in Active Directory and has read-only access to the SQL server. For example:
      ACMECORP\XSOAR
      or
      SQL Server authentication
      : Select this option to authenticate the user from accounts stored locally on the SQL server.
      Login name
      : Enter a name for the user account. For example:
      XSOAR
      Password
      and
      Confirm Password
      : Enter a password for the user account.
      User must change password at next login
      : (clear)
      Default database
      : Choose the AssetCentre database from which you want
      Cortex XSOAR
      to retrieve device information.
    4. In the User Mapping panel, give the account read-only access to the default database as well as any additional databases from which you want to import device data from AssetCentre.
      Users mapped to this login
      : Select the check box for the AssetCentre databases that you want to allow the account to access.
      Database role membership for
      <database-name>: For each database, select
      db_dataexecute
      ,
      db_datareader
      , and
      public
      .
  2. Save the new user account.
    Click
    OK
    to save the new login configuration.

Recommended For You