MySQL

To create a new MySQL data source:

1. Work with your database administrator to:

   • decide whether you want to create a new database user for Exonar

   • request the connection parameters that will allow you to get data from the database; you’ll use these in step 6

   Exonar uses the JDBC API to communicate with target databases

2. From the main menu select Data Sources

3. Click New ⇾ New Data Source

4. Select a data set or add a new data set and click Next

5. Choose MySQL

6. Enter the connection parameters:

   Field	Description
   Host	The IP address or the fully qualified domain name of the target server.
   Database/Schema	The name of the database you want to crawl. You can only target one database at a time.
   Port	The port that MySQL is using. For example: 3306.
   Username	A user who has read access to the data you want to crawl.
   Password	The password for the user.

   Exonar tries to connect to the database host

   If it fails, it prompts you to correct the parameters

7. Select the table or view you want to crawl

   You can choose just one table or view

   If you need to crawl another, you’ll need to create another data source

8. Sample Size is optional; it allows you to sample the data rather than crawling every row

9. Choose a primary identifier

   When you’ve selected the target table or view, choose the column to use as the primary identifier for a row (typically the primary key)

   You can select columns from the target table or view that should not be stored by Exonar

10. Identify versioning columns

    Exonar can look at one or more columns to check whether any row has changed since we last crawled it

    For example, the database might have a customer_record_last_updated column

11. Select the columns you want Exonar to look at

12. Map columns to Exonar fields

    The last step in configuring the database connection is to choose how individual columns should be mapped to the existing Exonar metadata fields

    You can create compound mappings and new custom fields

13. Select the country for this data source and click Next

    The country is used in geographical visualisations

14. Set the Crawl priority

15. Specify whether you want to crawl once or continuously

16. Click Start Crawl Immediately if you want to crawl the data right now

    Or you can start a crawl manually anytime you want

17. Click Create Data Source

SSL connections

By default, the MySQL data source is configured to work without SSL. If you need to use SSL, please contact the Exonar Support team.