Transcript Diagram 1

Localizing Datasources with Alchemy
Catalyst
Agenda




What is a Database?
Localizing using Catalyst
Q&A
Workshops
What is a Database?
 A database is an information
store
 The record is the building block
of the database
 Fields
 Tables
 Record sets
What is a Database?
5
Photo
4
Photo
Photo
Photo
Fields
3
Name
2
Name
Photo Name1 Start Date
Start Date
Name
Department
Start Date
Name
Department
Start Date
Department
Start Date
Department
Department
Table
Record
 Diagram 1 – A graphical representation of the data
What is a Database?
ID
Name
Start Date
Department
1
Jack Vettriano
1/1/2000
Marketing
2
James Watt
2/1/2001
Engineering
3
Iain Banks
8/12/2003
Documentation
4
Alexander Bain
05/06/2001
Engineering
5
Arthur Conan Doyle
12/08/2004
Documentation
 Diagram 2 – A table representation of the same data
Database Connections
 Making a Connection
 Database Driver
 ADO (Microsoft ActiveX Data Objects)
technology
 To see what database drivers you have
installed:
– Start Settings, Control Panel then
• In 95,98,NT -> ODBC data sources, Drivers
• In 2000->
Administrative Tools, Data Sources,
Drivers
 Client Server Environment
Localizing Database Content
 There are 3 steps:
– Connect - Establish a connection
– Select the data to be localised
– Link the field names of the database to
source target and ID fields in a project TTK
 These 3 steps are stored in a DDF file -
(Data Definition File)
Localizing Database Content
1. Establish A connection:
– Select Tools/Datasource/Define
– Test Connection button
– A complex connection string is created for
you by Catalyst.
2. Select the Data using SQL
– SELECT … from …
3. Link the data to the .ttk
– IDs
– Give your DDF a name
Connection to the database
There is no connection to the database while
translation is in progress.
Connection to the database is only required
when:
– Setting up the connection string and inserting
the DDF into the TTK
– When populating the translated text back into
the Database after translation.
Questions?