MySQL Database Support in Liquid XML

MySQL Database Support in Liquid XML

MySQL Database is supported in Liquid XML Studio 2015 (v13.0.6) through the ADO.NET driver Connector/Net. After installation, users can create a MySQL connection via the Database Connect command. The Connection Properties dialog allows entry of database details, and connected databases appear in the Database Explorer for easy access to tables and columns.


MySQL Database is now supported in Liquid XML Studio 2015 (v13.0.6).

In order to connect to MySQL, you must first download the ADO.NET driver for MySQL called Connector/Net. This can be found at the MySQL web site: http://dev.mysql.com/downloads/connector/net/


Change Data Source
Change Data Source

One you have installed Connector/Net, if you run the Database Connect command from inside Liquid XML Studio you will see the option to create a connection using the MySQL provider.





Connection Properties
Connection Properties

After selecting the My SQL Data Source option, you will be presented with the Connection Properties dialog, allowing you to enter the connection details for the MySQL Database you wish to connect to.





Database Explorer
Database Explorer

On creating the connection, when you look at the Database Explorer window inside Liquid XML Studio, you will see the MySQL database listed. You can expand this to display the tables and columns within the database.

This database connection can now be used as a Data Source within the Graphical Data Mapper.

Discover more from Liquid Technologies Blog

Subscribe now to keep reading and get access to the full archive.

Continue reading