Open topic with navigation
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
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:
See Accessing a Synergy Database for more information.