To prepare Synergy data for ODBC access, you’ll need to create a system catalog, a connect file, and a DSN. In addition, you’ll need a Synergy repository that defines the data in the Synergy database, and you’ll need to install xfODBC.
The following is a summary of the steps you’ll follow as you use xfODBC to generate a system catalog, modify the system catalog, and then access your Synergy database. To use these steps with the sample database, see Using the Sample Database As a Tutorial.
| 1. | Install and configuring xfODBC |
Install Synergy/DE Professional Series, including the Connectivity Series component, on your system. See the installation instructions that accompanied your distribution for detailed instructions.
| 2. | Set catalog generation options |
Prepare your environment and set options for system catalog generation. See Setting catalog generation options.
| 3. | Generate a system catalog |
Generate a system catalog from your repository definitions. See Generating the system catalog.
| 4. | Set up a connect file |
Create a connect file that specifies the current location of the Synergy database. See Creating the connect file.
| 5. | Customize the system catalog |
Use DBA to open your system catalog (see Opening a system catalog in DBA), and then
- modify the users and groups you initialized earlier, and assign group access levels. See Customizing users and groups and Setting security levels.
- make any necessary changes to the system catalog tables or columns and their attributes. See Customizing tables and table elements.
If necessary, set table access levels in your conversion setup file and regenerate the system catalog, specifying the conversion setup file as input. See Generating and editing a conversion setup file and Regenerating the system catalog.
| 6. | Create a DSN |
Create an ODBC data source name (DSN) to access your data. See Setting up access with DSNs.
| 7. | Set data access options |
Set options that affect the way xfODBC accesses data. See Setting runtime data access options.
| 8. | Access your Synergy database |
Do the following:
- Open a third-party, ODBC-enabled application.
- In the third-party application, choose the DSN for the Synergy database. (The third-party application calls the ODBC Driver Manager, which in turn calls xfODBC.)
- If necessary, at the log-in window enter your username and password. You should now be able to access the Synergy database from the third-party application.
See Accessing a Synergy Database for more information.
