Adding a SQL Database Mount

About this task

You must save any configuration steps or changes on the main AIS Mounts page before your changes take affect.

Procedure

  1. From the Management > Asset Interface System > AIS Mounts page, click Add.
    WorldServer displays the Mount: New page.
  2. In the Generic Configuration area:
    1. Supply a descriptive name.
    2. From the Type list, select SQL Connector.
  3. From the Database Type list, select the type of database to connect to, either Microsoft SQL Server, Oracle, or Other.
    WorldServer has extensively tested the connections for Microsoft SQL Server, MySQL, and Oracle. For information about connecting to other databases, contact Customer Support.
  4. Apply properties specific to the database type.

    To continue configuring a connection to a Microsoft SQL Server database, enter properties as described in the following table.

    PropertyTypeDescription
    Database ServerText fieldThe name of the machine on which the database is installed.
    Database NameText fieldThe name of the database to connect to.
    Instance NameText fieldIf your database has named instances, provide the specific instance that you want to connect to. Otherwise, leave the default value, Default.
    PortText fieldThe number of the port that the database instance is listening to.
    To continue configuring a connection to an Oracle database, enter properties as described in the following table.
    PropertyTypeDescription
    TNS NameText fieldID that points to the Oracle configuration file that you can edit from the Oracle client
    To continue configuring a connection to an Other database, enter properties as described in the following table.
    PropertyTypeDescription
    JDBC Driver ClassText fieldThe Java class that implements the JDBC driver for your database.
    Driver URLText fieldA URL pointing to the database instance
  5. Continue by entering values for the properties described in the following table:
    PropertyTypeDescription
    Hide NULL values for translatable columnsCheck boxIf checked, hides fields containing null values from the view. This is useful when the database is sparsely populated, that is, there are many fields wtih null values. If you clear the check box, all fields are shown.
    Database UsernameText fieldThe username for WorldServer to use when connecting to the database.
    Database PasswordText fieldThe password for WorldServer to use when connecting to the database.
  6. Configure SQL tables, SQL columns, and the SQL Identifier Hierarchy.
  7. Click Save.

Results

WorldServer returns to the refreshed Management > Asset Interface System > AIS Mounts page. You can now view your mount and content from the Explorer.