Translating MS Access Files
Using Alchemy CATALYST, it is now possible to translate the content of any Microsoft Access database. While the process outlined in this tutorial uses MS Access by means of an example, other databases such as Oracle, IBM DB2 and Microsoft SQL are identical.
To translate the content of a database you need to follow three simple steps:-
1. Establish a Connection : You need to establish a live connection to your database. The database can be stored locally on your hard disk or remotely on a server.
|
|
|
If the data source is remotely stored on a network drive, please check with your database administrator that you have access rights to the database server. |
2. Identify Data Content: Once you've established your connection to the data source, you use SQL statements to identify the data that needs to be extracted and translated. At this stage you'll also 'link' the fields in your data source to some of the internal Project TTK fields. These steps are recorded and stored in your Data Definition File.
3. Translate & Extract ! That's it! It really is that simple.
