Progress
DataServer
for ODBC Guide


Preparing to Use the DataServer Utilities

Subsequent sections contain tutorials that illustrate using the DataServer utilities to maintain your schema holder. Before you use these tutorials, you must perform some preparatory steps, including creating the demonstration database and schema holder and accessing the DataServer’s ODBC Utilities menu.

To prepare to use the DataServer utilities, follow these steps:

  1. Make sure that you have done the following:
    1. Installed and started your data source
    2. Installed and configured your drivers
    3. Installed and configured any client software required by your non-Progress data-source vendor
  2. Create an empty foreign data source.
  3. Start the ODBC administration tool for your data source.
  4. Select the appropriate ODBC driver.
  5. Select the target ODBC data source.
  6. Make any additional selections required by your ODBC data source.
  7. Specify mysport as data source name. The name that you use to register a data source is the name that Progress recognizes.
  8. Exit the ODBC administration tool.
  9. Make sure that the target ODBC data source has started.
  10. Start a local Progress session using the following command:
  11. NT or Windows

    install-path\dlc\bin\prowin32 
    

    Starting a local Progress session also automatically starts the local DataServer.

  12. On Windows or NT, access the Progress Data Administration tool. Create a copy of the Sports database and connect to it.
  13. Select DataServer ODBC Utilities Schema Migration Tools PROGRESS DB to ODBC to start the Progress-to-ODBC Utility.
  14. Specify Progress-to-ODBC parameter values as noted in Table 5–1.
  15. Table 5–1: Progress-to-ODBC Utility
    Interface Element
    Description
    Original Progress Database
    Accept the name of the connected source database or type the name of a database to which to connect.
    Connect parameters for PROGRESS
    If you did not specify a new value for the Name of the Original PROGRESS Database parameter, do not modify the Connect parameters for PROGRESS Database parameter.
    If you did specify a new value, type any additional connect parameters that are necessary.
    Name of Schema holder Database
    Type the name of the schema holder. The utility creates the schema holder if it does not exist.
    ODBC data source Name
    Type the data source name (This is the name you specified when registering the data source in step 7 of the above section "Preparing to Use the DataServer Utilities."). This is the name of the schema image and the name that you will use to refer to the target database in applications. The data-source name must be different from the name that you typed for the schema holder and different from the name of any other schema image existing in that schema holder.
    Foreign DBMS type
    Select the foreign data-source type to which the ODBC driver is connecting. Progress provides the following choices: SQL Server 6, Sybase, DB2/MVS, DB2/6000, DB2/NT, Informix, MS Access, and OTHER. Select OTHER if you are accessing a target data source other than the ones listed here. Note that you will get only the generic ODBC SQL-92 functionality if you access databases other than the ones listed here.
    ODBC owner’s Username
    Type the user ID.
    ODBC user’s Password
    Type the password.
    ODBC Connect parameters
    See "Connecting the DataServer," for required connection parameters. For example, -Dsrv might be required in some cases.
    Codepage for Schema Image
    Accept the default code page.
    Progress 4GL Compatible Objects
    Check this toggle box to create an ODBC data source that supports arrays, case-insensitive indexes, backward and forward scrolling, and the Progress record identifier. These objects result in the addition of columns to your foreign data-source tables.
    Uncheck this toggle box if you do not want the Extended 4GL capability.
    Load SQL
    Leave this toggle box checked.
    Move data
    Check this toggle box to dump and load data from the Progress database to the target database. Copying data from a large database can take a long time. You can uncheck this toggle box if you want to dump and load data at a more convenient time.
    This toggle box is available only if the Load SQL toggle box is checked.

    NOTE: For a complete description of these Progress-to-ODBC parameters, see Table 5–5 in the "Running the Progress-to-ODBC Utility" section.

    Running the utility creates and connects a schema holder and the ODBC data source. It operates as follows:

    1. SQL script is generated.
    2. SQL that creates the schema is sent to the foreign data manager.
    3. The schema is pulled back to the schema holder.
    4. The foreign schema holder and the Progress database are compared and all information needed by Progress is applied to the schema holder.
    5. Data is loaded.
    6. The schema holder is disconnected.
    7. A message is displayed that tells the user which startup procedure to use to connect.
  16. Choose DataServer ODBC  Utilities to see the available DataServer utilities, described in Table 5–2.
  17. Table 5–2: DataServer Utilities 
    ODBC Utility
    Description

    Create DataServer Schema...

    Creates a schema image in the schema holder for an ODBC data source.

    Update/Add Table Definitions...

    Updates the schema holder to reflect any changes that you make to data-source data definitions.

    Verify Table Definition...

    Makes sure that the data definitions in the schema holder match your data-source data definitions.

    Edit Connection Information...

    Changes connection information or the logical database name for a data source.

    Change DataServer Schema Code Page...

    Changes the code page in the schema holder associated with the ODBC data source.

    Delete DataServer Schema...

    Deletes a schema image from the schema holder.

    Schema Migration Tools

    Accesses utilities for migrating or comparing a Progress database to an ODBC data source.

  18. When you access a DataServer utility (as you will do in the tutorials that follow this section), the following dialog box might appear before the utility opens:
  19. In the User ID and Password dialog box, choose OK if you are satisfied with the user ID and password combination that you have already supplied. If you want to change them, or they were never specified, enter a user ID and password with the privileges required for creating and updating a schema holder. See the "Establishing Permissions" section in "Configuring the DataServer," for information.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095