Table of contents
Connecting to a MySQL Database Tutorial Video. This video will walk you through how to connect to a MySQL database as a data source.
For AutoTag and the .NET engine you need the ADO.NET connector which can be found at dev.mysql.com/downloads/connector/net/ - you want the zip file that does not have src in its name. That zip file contains a single file mysql.data.msi which you run to install the connector. Note: Windward only works with MySql 5.0 and later.
For the java engine you need the JDBC connector which can be found at dev.mysql.com/downloads/connector/j/ - either the zip or tar is fine, they both have the same thing.
-
Server: Enter the server name here. MySql cannot list servers on the subnet so you always need to type this in.
-
Database: Enter the database name here. This will auto-populate from the server once the server is set. In most cases you will need to set your username & password in order for AutoTag to auto-populate the list. You can type in the name or select from the list.
-
Display Tables: User and User Owned are the same thing for MySQL. User will pull the metadata of just the tables created for a database. System will also pull the system tables MySQL adds to the database used to administer and configure each database.
-
Read in metadata: Check this to read in additional information from the database, primarily the descriptions of tables, views, & columns and the primary key - foreign key relationships. You should always keep this checked.
-
Use Connection String: You can enter the connection string directly instead of entering the Server, Database, & Credentials. When unchecked it will dispkay the connection string AutoTag will generate from your settings.
Demo Server
You can connect to the Windward demo MySQL database as follows. It has the Sakila database.
-
Server: mysql.windward.net
-
Username: demo
-
Password: demo
Important Note on Windward Videos
Can't view the video? See Broken Images and Videos in the Windward wiki and Broken Videos: Vimeo and Firefox for help.


Comments