1.6

For a Database File
To create a Data Mapping from a Database file using the wizard, use the following steps:
From the Welcome screen
1.
Open the PlanetPress ConnectWelcome page by clicking the icon at the top right or
select the Help menu and then Welcome.
2.
Click Create a New Configuration.
3.
From the Using a wizard pane, select Database.
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.
Page 67