If not set, tables from all databases will be returned.įor assistance in constructing the JDBC URL, use the connection string designer built into the MySQL JDBC Driver. Optionally, Database can be set to connect to a specific database. If IntegratedSecurity is set to false, then User and Password must be set to valid userĬredentials. The Server and Port properties must be set to a MySQL server. On the next page, select Generic JDBC from the DB Type menu and enter the JDBC URL. In the resulting wizard, enter a name for the connection.Add a new database connection to MySQL data: To add a new connection, expand the Metadata node, right-click the Db Connections node, and then click Create Connection. ![]() ![]() You can follow the procedure below to establish a JDBC connection to MySQL: This article uses the CData JDBC Driver for MySQL to transfer MySQL data in a job flow in Talend.Ĭonnect to MySQL in Talend as a JDBC Data Source This article shows how you can easily integrate the CData JDBC driver for MySQL into your workflow in Talend.
0 Comments
Leave a Reply. |