Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Connect Knowledge Base

Definitive answers from Connect experts.

Loading MySQL Metadata to Connect

MattD
Alteryx Alumni (Retired)
Created

Connect Banner.png

Please see Maintaining Data Lineage for details and requirements before your metadata harvest. After ensuring you’ve downloaded the latest Connect Metadata loaders from the live downloads page, simply proceed with the steps below to upload MySQL Database metadata to your Alteryx Connect instance!

  1. Open Alteryx Designer and Click Help > Sample Workflows > Alteryx Connect Metadata Loaders > MySQL Loader > MySQL Loader:

1.png

  1. Open the Analytic App interface by clicking the wand icon to the right of the “Run” button:

2.png

  1. Configure the MySQL server tab and select “Next”:

3.png

  • The values entered here will match, exactly, the fields of your DSN setup for the MySQL environment

  1. Configure the Alteryx Connect tab with your admin credentials:

4.png

Note: At this stage it is recommended that you save the YXWV value file from the app interface into the MySQL loader directory (C:\ProgramData\Alteryx\AlteryxConnect\MySQL_Loader\

7.png

This .yxwv file of app configurations can be used later for scheduling the MySQL metadata loader for a regular harvest.

  1. Click “Finish” and wait for the app to load your metadata to Connect. Depending on how much metadata is being imported, the app can take some time to run:

6.png

6. Upon completion of a successful metadata harvest, the app will output “Success” and you can select “OK” to exit. To confirm the harvest, open the Connect website to validate the metadata load in Datasources > Databases:

8.png

9.png

No ratings