Once you have established a connection to your data source, the following dialog will appear on the screen. This is where you’ll select the data to be translated and link it to the internal source, target and id fields of your Project TTK file.

From left to right , the panels on this dialog are:

databasestructure.bmp

point.bmp

Database Structure Displays the hierarchical structure of the tables and fields in a data source. For databases this is the equivalent to the database schema. For other data sources such as Microsoft Excel Spreadsheets this would be a list of rows and columns.

sqlquery.bmp

point.bmp

SQL Query For each Result Set Name you can have an individual SQL statement. This SQL statement can be used to query your data source, selecting the data you wish to insert into your Project TTK file.

resultsetstructure.bmp

point.bmp

Result Set Structure Displays the hierarchical structure of a Result Set as defined by your SQL statement. Any field that appears in your Result Set can be inserted into your Project TTK file.

 

projectttkdatabase.bmp

point.bmp

Project TTK Displays the fields from your Result Set and how they are linked to internal data fields of a Translation Unit. A Translation Unit is made up of three elementary fields. These fields are:

  • ID Field: This is the internal ID of a translation Unit. If you have a unique ID within your data source that uniquely identifies a text string, then link it to this field. By providing unique Ids in your translation units, you will improve the accuracy of alignment, leverage and validation functions in Alchemy CATALYST.

  • Source Text Field: This is the original text of a translation unit.

  • Target Text Field: This is the target text of a translation unit. The target text is used to contained the translation of your original or source text field. If you do not link a data source element to a Target Text Field, it will be populated with the contents of your Source Text Field.

sqlpreview.bmp

point.bmp

SQL Preview Displays the results of your SQL Query in a data grid. This can be a useful reference point when determining what data to populate your Project TTK with.

point.bmp

CATALYST Preview Displays how your data will display in your Project TTK file. This is a useful reference point when developing complex SQL Queries and linking operations.

 

note.bmp

Alchemy CATALYST will warn you if your SQL statement has any syntax errors or it cannot successfully complete a query of your data source. You should contact your database administrator if these errors persist and ensure that you have access rights to your data sources.