Migration Using Quick ETL Copy With the MySQL ODBC Driver

How to:

Quick ETL Copy using the MySQL ODBC driver allows for migration of individual Hyperstage MySQL tables to Hyperstage for PostgreSQL. Once you have installed and configured the ODBC Driver on your machine, you will access the Reporting Server Web Console to configure the adapter connection and run the Quick ETL Copy.

Note: You must access the Hyperstage version of the Reporting Server Web Console to complete these steps.

Top of page
x
Procedure: How to Install and Configure the MySQL ODBC Driver
  1. Go to the following webpage:

    http://dev.mysql.com/downloads/connector/odbc/5.2.html

  2. Scroll to Windows (x86, 64-bit), MSI Installer and click Download to download the installation file for the MySQL ODBC Driver. The mysql-connector-odbc-5.2.7-winx64.msi file will be downloaded.
  3. Double-click mysql-connector-odbc-5.2.7-winx64.msi to start the Driver installation.
  4. Click Run.
  5. Click Next, as shown in the following image.

    MySQL Connector/ODBC Setup Wizard

  6. Select I accept the terms in the license agreement, and click Next, as shown in the following image.

    MySQL Connector/ODBC Setup Wizard - License Agreement window

  7. Select Typical, and click Next, as shown in the following image. MySQL Connector/ODBC Setup Wizard
  8. Click Install, as shown in the following image.

    MySQL Connector/ODBC Setup Wizard

    The MySQL ODBC Driver will start installing, as shown in the following image.

    MySQL Connector/ODBC Setup Wizard
  9. Click Finish, as shown in the following image.

    MySQL Connector/ODBC Setup Wizard

  10. From Windows Control Panel/Administrative Tools, double-click Data Sources (ODBC), as shown in the following image.

    Administrative Tools

  11. Click the System DSN tab, and click Add, as shown in the following image.

    ODBC Source Administrator

  12. Select either MySQL ODBC 5.2 ANSI Driver or MySQL ODBC 5.2 Unicode Driver, and click Finish, as shown in the following image.

    Create New Data Source window

  13. Complete the fields in the MySQL Connector/ODBC Data Source Configuration dialog box, and then click Details, as shown in the following image.

    MySQL Connector/ODBC Data Source Configuration

  14. In the Cursors/Results tab, select the Don't cache results of forward-only cursors and Force use of forward-only cursors check boxes, as shown in the following image.

    MySQL Connector/ODBC Data Source Configuration

  15. Click OK.
Top of page
x
Procedure: How to Configure the Hyperstage MySQL ODBC Adapter Connection
  1. Launch the Web Console and click the Adapters tab.
  2. Expand Available. Then expand the SQL and Hyperstage folders, as shown in the following image.

  3. Right-click ODBC, and click Configure, as shown in the following image.

  4. Enter a Connection Name, the Datasource name used when configuring the MySQL ODBC driver, User, and Password, as shown in the following image.

  5. Click Configure.
  6. Click Restart Java Services.
Top of page
x
Procedure: How to Run Quick ETL Copy
  1. Ensure that the Lite mode for Quick ETL Copy is turned off.
  2. Launch the Web Console and click the Adapters tab.
  3. Right-click Adapters and then click Change Common Adapter Settings, as shown in the following image.

    Adapters shortcut menu

    The Change Settings for Common Adapter window opens.

  4. From the LITE-MODE drop-down menu, select No.
  5. From the ETL-TRG-DBMS drop-down menu, select blank space, as shown in the following image.

    Change Settings for Common Adapter pane.

  6. Click Save.
  7. Right-click the Hyperstage MySQL Master file for the data to be migrated, and then click Quick ETL Copy, as shown in the following image.

    Hyperstage MYSQL Master shortcut menu

  8. Select a Target Application for the Hyperstage PostgreSQL metadata.
  9. From the Target Adapter drop-down menu, select Hyperstage (PG).
  10. From the Load Type drop-down menu, select Extended Bulk Load Utility.

    The following image shows the Quick ETL Copy window with all of the fields completed.

  11. In order for the Partition parameters for Quick ETL Copy to appear, the KEYS attribute must be set in the Access File that pertains to the MySQL table.

    For example:

    SEGNAME=FACT_SALES,TABLENAME=wrd_fact_sales,CONNECTION=CON1,KEYS=1,$
WebFOCUS