100 likes | 217 Views
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. 4. 1. 2. 5. 3. Photo. Photo.
E N D
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
4 1 2 5 3 Photo Photo Photo Photo Photo Name Name Name Name Name Start Date Start Date Start Date Start Date Start Date Department Department Department Department Department What is a Database? Fields Table Record • Diagram 1 – A graphical representation of the data
What is a Database? • 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 • Establish A connection: • Select Tools/Datasource/Define • Test Connection button • A complex connection string is created for you by Catalyst. • Select the Data using SQL • SELECT … from … • 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.