Importing CIs from SQL databases


If an external database is enabled for your environment, you can import configuration items (CIs) and CI relationships from it into FootPrints where your users can access them and link to them.

For more information about importing CI relationships, see Importing-CI-relationships-from-SQL-databases.

To import CIs

  1. Click the Administration tab.
  2. In the System Management section, click Import.
     The Task Scheduler page appears, showing a list of scheduled tasks and their status. Tasks with a Status of “Completed” were performed successfully; tasks with a Status of “Completed with Errors” failed.
  3. Click New Task and select Import Task > Configuration Items.
     The Import CI page appears, showing the Source Type pane.
  4. In the Source Type field, select the type of database that contains the CI data.
  5. In the left pane, click Source Configuration.
    The Source Configuration pane appears.
  6. Complete the fields:
    1. In the Server Address field, enter the IP address or the name of the SQL server for this import task.
    2. In the Server Port field, enter the port number for the server.
    3. In the Database Type field, select the type of database.
       Options are Postgres, Sql Server, and MS SQL.
    4. In the Database field, enter the name of the source database.
    5. In the Server User ID and Server Password, enter the credentials for logging into this server.
    6. Click Test Connection.
       The system attempts to connect to the SQL server. If not successful, an error message appears.
  7. In the left pane, click Data Destination.
     The Data Destination pane appears.
  8. Complete the fields:
    1. In the Import into CMDB field, select the CMDB where you want to import the CIs.
    2. (Optional) To search existing contacts for matches and link the imported CIs to them:
      1. Select Link imported CIs to matching entries in address book.
      2. In the Address Book field, select from the address books associated with the selected CMDB.
      3. In the Contact Type field, select the appropriate contact type.
  9. In the left pane, click Map Fields.
     The Map Fields pane appears.
  10. Complete the fields:
    1. In the Table or view field, select the location of the CI data that you are importing.
    2. If you selected to link the imported CIs to an address book, the Link to Address Book section appears. Complete the fields:
      1. In Map data source field, select the source field that you want to map.
      2. In To this Address Book field, select the target field in the Address Book.
    3. In the Map CI Type Rules section:
      1. In the Default CI Type field, select from the CI types defined for the selected CMDB and click Add.
      2. If you want to customize the import process, perform steps iii through vi. If you want to use the default import process, continue with step 10d.
         With the default process, all CIs are assigned the default type.
      3. In the If Column field, select a condition.
      4. In the Contains Text field, type the text to match.
      5. In the Set CI Type as field, select a CI Type.
      6. Click Update.
      7. Repeat steps i through vi to add as many rules as you need.
    4. In the Map Attributes section:
      1. Click Add.
        Select values for Attribute and Source Field. You must map at least one attribute.
         The available values are based on selections already made on this pane.
    5. In the Status for all CIs field, select the initial status for the uploaded CIs.
    6. (Optional) To update existing CIs, select Update the Status for existing CIs.
    7. In the Unique Key field, select the fields in the Source Columns list that are used as unique keys and move them to the Unique Key list.
  11. In the left pane, click Schedule Task.
     The Schedule Task pane appears.
  12. Complete the fields:
    1. In the Task Name field, enter a specific name for this task.
    2. (Optional) In the Notes field, enter any useful information about this task.
    3. (Optional) In the Notify by Email field, enter the email addresses of anyone who should be notified when this task runs.

      You can also enter an agent's user name to send notification to the agent's primary email address. Separate multiple user names and email addresses with semicolons. Notification is sent about import outcome and includes results, task name, date, and so on, including the number of records that were rejected, created, updated, and unchanged.

    4. (Optional) Select whether to run this task immediately or at a specific time, and whether and when to run it again.

      If you do not select any settings, the task will only run manually. For more information, see Scheduling-tasks.

  13. Click Schedule Task.
     Your selections are validated by the system. If no errors are found, the Task Schedule page appears. Local files that won't change between scheduling and running are validated immediately. Web and network server files are validated at run-time. Next Run Time is the next or first time a task will be run.

Next step

To import the relationships for these CIs, follow the instructions provided in Importing-CI-relationships-from-SQL-databases.

Related topics

Viewing-task-logs

Importing CIs from CSV files

Importing-CIs-from-BMC-Client-Management

Importing-CI-relationships-from-CSV-files

Importing-CI-relationships-from-BMC-Client-Management

Working-with-mappings

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*