1.4

4. Use the drop-down to select the Database type.
5.
Click Next.
From the File menu
1.
Click the File menu and select New.Click the Data mapping Data mapping Wizards
drop-down and select From databases.
2.
Click Next.
3. Use the drop-down to select the Database type.
4.
Click Next.
Now set the following properties according to the selected database:
MySQL
l
Server: Enter the server address for the MySQL database.
l
Port: Enter the port to communicate with the 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 MySQL server and specified
database. The user only requires Readaccess to the database.
l
Password: Enter the password that matches the user name above.
l
Table name: The selected database is a set of related tables composed of rows and
columns corresponding respectively to source records and fields. Select a table from
which you want to extract data.
l
Encoding: Choose the correct encoding to read the file.
l
Click Finish to close the dialog and open the actual Data Mapping configuration.
Microsoft Access
l
Click the Browse button and open the database file you want to work with.
l
Password: Enter a password if one is required.
l
Click Next.
l
Table name: The selected database is a set of related tables composed of rows and
columns corresponding respectively to source records and fields. Select a table from
which you want to extract data.
l
Encoding: Choose the correct encoding to read the file.
l
Click Finish to close the dialog and open the actual Data Mapping configuration.
SQL Server
Page 48