2022.1

l MariaDB
l MySQL
l Microsoft Access Database (.mdb, .accddb)
l SQL Server
l ODBC DataSource
l JDBC
l Oracle.
2. Review the options presented. The options available depend on the type of database
data source; see below.
MariaDB \ MySQL
1. Enter the appropriate information to connect to the database:
l Server: Enter the server address for the MariaDB or MySQL database.
l Port: Enter the port to communicate with the MariaDB or MySQL server. The default
port is 3306.
l Database name: Enter the exact name of the database from where the data should
be extracted.
l User name: Enter a user name that has access to the MariaDB or MySQL server
and specified database. The user only requires Read access to the database.
l Password: Enter the password that matches the username above.
2. Click Next and enter the information for the source table.
l Connection string: Displays the full path to the database.
l Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
l Sort on: Select a field on which to sort the data, in ascending (A-Z) or
descending (Z-A) order. Note that sorting is always textual. Even if the
selected column has numbers, it will be sorted as a text.
3. Click Finish to open the database.
Page 341