When you add an SQL Connector mount, you also need to configure the SQL tables that users can access through WorldServer.
Procedure
- While adding an SQL Connector mount, on the Mount: New page, under SQL Table Configuration, select Add.
- In the new window, in the Show Tables From list, select the appropriate types of tables or views.
- Under Select Table, in the Table list, select the table you want to configure, and then select Next.
- On the Column Configuration for Table "<name>" page, specify the following information:
- Under Treatment, choose how you want WorldServer to use each column 1:
- ignore – If you select this option, WorldServer ignores the content in the column.
- edit/translate – If you select this option, users can translate or modify the content in the column.
- identifier – If you select this option, the column, in conjunction with other identifier columns, is used to uniquely identify (or as a primary key for) the content in the table. All identifiers combined must uniquely identify a row in the table. Otherwise, the system cannot create the AIS mount. You must choose at least one column as an identifier.
- copy – If you select this option, the column from the source language is copied in the target locale when the target is created or when a project is created. Use this option for columns that do not need translation, but should be copied identically to the target – for example, a company logo or graphic. Columns that are marked as copy must include the
NOT NULL constraint. Otherwise, WorldServer will leave the target column empty.
- timestamp – This option is available only for date/time columns. If you select this option, the column is used as a timestamp for the content in the row. You can designate only one column as the timestamp column. Although WorldServer can detect changes in rows even without a timestamp column, using one improves performance.
Note: Make sure you create a trigger in your database that updates the timestamp in a row when its content changes. Note that the Microsoft SQL Server timestamp data type is not a valid date/time format. Use the date/time data type instead.
- Under MIME Type, select the MIME type for each available column, which determines how WorldServer treats translatable content.
Note: You do not need to change the MIME type and encoding for columns set to ignore, because WorldServer does not deal with this content. These values do not affect the MIME type and encoding of the actual content in the table. Instead, they inform WorldServer of the existing settings in the table.
- Under Encoding, select the data encoding for each available column.
The default selection should usually be correct, but certain types of data may require a different setting.
- Under Title, select a column to be the title column.
After you save the mount, WorldServer Explorer displays the contents of the title cell to help users find information more quickly.
- Under Order, use the arrows to rearrange the order in which the columns are displayed.
The order of the columns determines the sequence in which translators see the content of the fields.
- Select Next.
- On the Identifier Hierarchy for Table "<name>" page, configure the hierarchy of the identifiers and select an asset-level identifier.
- Select Finish.