![]() Open the Denodo Virtual DataPort Administrator tool and navigate to the Server Explorer tab.Copy the JAR File (and license file if it exists) from the installation location (typically C:\Program Files\CData\CData JDBC Driver for MySQL\lib\) to the Denodo external library directory ( C:\Denodo\Denodo Platform\lib-external\jdbc-drivers\cdata-mysql-19).Download the CData JDBC Driver for MySQL installer, unzip the package, and run the JAR file to install the driver.To connect to live MySQL data from Denodo, you need to copy the JDBC Driver JAR file to the external library directory for Denodo and create a new JDBC Data Source from the Virtual DataPort Administrator tool. Its built-in dynamic metadata querying allows you to work with and analyze MySQL data using native data types. When you issue complex SQL queries to MySQL, the driver pushes supported SQL operations, like filters and aggregations, directly to MySQL and utilizes the embedded SQL engine to process unsupported operations client-side (often SQL functions and JOIN operations). With built-in optimized data processing, the CData JDBC Driver offers unmatched performance for interacting with live MySQL data. ![]() This article walks through creating a virtual data source for MySQL in the Denodo Virtual DataPort Administrator. When paired with the CData JDBC Driver for MySQL, Denodo users can work with live MySQL data alongside other enterprise data sources. Denodo Platform is a data virtualization product providing a single point of contact for enterprise database data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |