Adding a SQL Database Mount

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

From the Management > Asset Interface System > AIS Mounts page, click Add.
WorldServer displays the Mount: New page.
In the Generic Configuration area:
1. Supply a descriptive name.
2. From the Type list, select SQL Connector.
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.

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.

Property	Type	Description
Database Server	Text field	The name of the machine on which the database is installed.
Database Name	Text field	The name of the database to connect to.
Instance Name	Text field	If your database has named instances, provide the specific instance that you want to connect to. Otherwise, leave the default value, Default.
Port	Text field	The 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.

Property	Type	Description
TNS Name	Text field	ID 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.

Property	Type	Description
JDBC Driver Class	Text field	The Java class that implements the JDBC driver for your database.
Driver URL	Text field	A URL pointing to the database instance

Continue by entering values for the properties described in the following table:

Property	Type	Description
Hide NULL values for translatable columns	Check box	If 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 Username	Text field	The username for WorldServer to use when connecting to the database.
Database Password	Text field	The password for WorldServer to use when connecting to the database.

Configure SQL tables, SQL columns, and the SQL Identifier Hierarchy.
Click Save.

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