Import multiple databases

Import multiple databases to the inventory from a spreadsheet containing information such as database type, host name, and service name.

Before you begin

Importing databases is a quick and convenient way to populate the compliance monitoring smart assistant with databases for monitoring. Before you begin, prepare a comma-separated values (CSV) file with the database information to import. The file needs to meet the following requirements:
  • The first row defines column names.
  • Each row is complete, meaning that empty fields are accounted for with a delimiter (for example, a comma).
  • Database type is defined using any of the following case-insensitive strings:
    • Db2
    • Db2 z/OS
    • Informix
    • MongoDB
    • MS SQL Server
    • MS SQL SERVER (DataDirect)
    • MS SQL SERVER (DataDirect - Dynamic Port)
    • MySQL
    • Netezza
    • Oracle
    • Oracle (DataDirect - Service Name)
    • Oracle (DataDirect - SID)
    • PostgreSQL
    • SAP HANA
    • Sybase
    • Sybase IQ
    • Teradata
    MS SQL Server can be used for both MS SQL SERVER (DataDirect) and MS SQL SERVER (DataDirect - Dynamic Port) databases. Oracle can be used for both Oracle (DataDirect - SID) and Oracle (DataDirect - Service Name) databases.
  • All database types require values for the Host name/IP address and Port number fields. In addition, specific databases require additional fields:
    • Db2, Db2 z/OS, Netezza, and PostgreSQL require Database name.
    • Informix requires Informix server.
    • MS SQL SERVER (DataDirect - Dynamic Port) requires Instance name. Note: port number is not required for MS SQL SERVER (DataDirect - Dynamic Port).
    • Oracle (DataDirect - Service Name) and Oracle (DataDirect - SID) require Service name.
Attention: Microsoft Excel format (XLS) is not supported. When exporting CSV from Excel, verify that the CSV file is created with complete rows and is not missing delimiters for empty fields.

Procedure

  1. Click the Import from CSV button to open the Import from CSV dialog.
  2. Click the Browse button and select a CSV file to upload.
  3. Use the Field delimiter field to define the delimiter used in the CSV file.
    In most instances, the default value (a comma) is appropriate.
  4. Click the Load button to continue.
  5. Use the drop-down menus to map columns from the CSV file to specific database information.
    For example, to import host information, use the Host name/IP menu to select the column name containing the host names or IP address of your databases.
    Note: Columns containing Instance name, Server name, and Service name information are automatically assigned based on the associated database type. For example, in a CSV file containing Db2 instance names and Oracle service names in a single column, mapping that column to either Instance name or Service name fields assigns the value to the correct field for the database type.
  6. Click OK to import database information from the CSV file.
    If needed, a warning message displays any rows that are skipped due to incomplete or invalid data.

Results

Multiple databases are imported to the compliance monitoring database inventory. If you imported database credentials, the credentials are saved and datasources are created for discovering sensitive data, running vulnerability assessments, and use with other Guardium processes. Configure advanced datasource features such as connection properties using the Setup > Tools and Views > Datasource definitions tool.