Source Driver Installation Example

Installing the MySQL JDBC Driver

 

Due to licensing issues, JDBC drivers are not included with the Teiid Designer installation. However, valid drivers are required to import from JDBC data sources or to create source connections for data preview and VDB execution. This document provides instructions on how to install a sample JDBC driver to get you started.

 

Download MySQL drivers

  1. Visit the MySQL (www.mysql.com) Web site
  2. Go to their Downloads page
  3. Select, and go to, the Connectors page
  4. Go to the Connector/J page
  5. Select the download you want (.tar.gz or .zip)
  6. Follow the instructions to download the connector software.

 

Once downloaded, extract the actual .jar file (for example, mysql-connector-java-5.1.7-bin.jar) from the downloaded archive. Place it in a location you can access from Teiid Designer.

 

Install MySQL drivers into Designer

  1. Start Teiid Designer
  2. Choose an open project, or create a new one (this will not change the project)
  3. Select File > Import... action
  4. Choose to import Metadata from JDBC Database option
  5. Click Next>
  6. Click the Sources... button
  7. On the Update JDBC source configurations page, click Add to create new Source Configuration
  8. Click the Drivers... button to launch the JDBC Driver Configurations wizard
  9. Select the MySQL Driver Configuration
  10. In the Libraries section, click Add External... button
  11. Navigate to and select driver jar file you extracted earlier from your .tar.gz or .zip file and click OK
  12. Click Update button to load the available driver class names from the jar
  13. Use the combo box to select, “com.mysql.jdbc.Driver”
  14. Click OK

 

At this point you have added the new driver.

 

You may continue to import a database's metadata, or go to another activity. However, by completing the import, Designer will also create the connector binding required to perform queries via the preview data feature or through VDB execution, .

 

If you choose to not complete the import and wish to perform queries on your data, you'll need to create a connector using the steps below then bind your model to your new connector.

 

  1. Select the MySql JDBC Connector in the Connectors view
  2. Right-click select the New or choose the Create new connector action in the view's toolbar to open the New Connector dialog
  3. Specify unique Name
  4. Supply missing <host> and <databaseName> in JDBC URL template.
  5. Set User Name and Password
  6. Select Class Path property and open the Connector Classpath Editor
  7. Navigate to and select driver jar file you extracted earlier from your .tar.gz or .zip file and click OK
  8. Click OK to save the new connector.
  9. If all supplied information is valid the connector is ready for use

 

In addition to MySQL, there are several other JDBC driver templates available in Teiid Designer. The following is a full lis:

 

    • Apache Derby Embedded
    • Apache Derby Network
    • DB2
    • Microsoft Access
    • Microsoft Excel
    • MySQL
    • ODBC via DSN
    • Oracle
    • PostgresSQL
    • SQL Server

 

Links

 

Related Documents