Migration Using Quick ETL Copy With the MySQL JDBC Driver

How to:

Quick ETL Copy using the MySQL JDBC driver allows for migration of individual Hyperstage MySQL tables to Hyperstage for PostgreSQL. Once you have installed and configured the JDBC 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 JDBC Driver

To install the MySQL JDBC driver:

  1. Download the installation file for the MySQL JDVX driver from the following location: http://dev.mysql.com/downloads/connector/j/.
  2. From the Select Platform drop-down menu, select Platform Independent, as shown in the following image.

  3. In the Platform Independent (Architecture Independent), ZIP Archive row. click Download.

    The mysql-connector-java-5.1.35.zip file is downloaded.

  4. Unzip mysql-connector-java-5.1.35-bin.jar to the desired location, for example, C:\ibi\SQLJDBC, as shown in the following image.

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

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

    The Add Hyperstage JDBC to Configuration window opens.

  4. Complete the following fields:
    • In the Connection Name box, type a name for the connection.
    • In the URL box, type the JDBC URL in the following format: jdbc:mysql://host:port/webfocus?useCursorFetch=true&/defaultFetchSize=50000
    • In the Driver Name box, type com.mysql.jdbc.Driver.
    • In the IBI_CLASSPATH box, add the fully qualified path of the JDBC Jar file, for example, C:\ibi\SQLJDBC\mysql-connector-java-5.1.35-bin.jar.
    • In the Home Directory box, enter the location of the home directory for Hyperstage MySQL, for example, C:\HyperstageMySQL.
    • In the Tools Directory box, type the location of the tools directory for Hyperstage MySQL.
    • Type the User and Password for the MySQL database.

    The following image shows the window with all fields completed.

  5. Click Configure.
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