1 / 10

Localizing Data Sources with Alchemy Catalyst: Understanding Databases

Join our workshop on localizing data sources using Alchemy Catalyst. Learn what a database is, its structure including records, fields, and tables. Discover how to connect to databases, select data for localization, and link fields using a Data Definition File (DDF). We'll cover essential steps such as establishing connections with database drivers and using SQL for data selection. This session will provide practical insights into effectively managing and localizing database content within your projects. A Q&A session will follow to address your queries.

carter
Télécharger la présentation

Localizing Data Sources with Alchemy Catalyst: Understanding Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Localizing Datasources with Alchemy Catalyst

  2. Agenda • What is a Database? • Localizing using Catalyst • Q&A • Workshops

  3. What is a Database? • A database is an information store • The record is the building block of the database • Fields • Tables • Record sets

  4. 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

  5. What is a Database? • Diagram 2 – A table representation of the same data

  6. 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

  7. 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)

  8. 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

  9. 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.

  10. Questions?

More Related