2022.1

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 server and specified database. The
user only requires Read access to the database.
l Password: Enter the password that matches the user name above.
l Advanced mode: Check to enable the Connection String field to manually enter the
database connection string.
l Connection string: Type or copy in your connection string.
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.
Using the wizard for JSON files
The DataMapper wizard for JSON files helps you create a data mapping configuration for a
simple JSON file. The wizard provides limited options for specifying source records and
boundaries, and adds one extraction step.
The wizard cannot create detail tables. If the file contains transactional data, the data mapping
configuration is best created without a wizard (see "Creating a new data mapping
configuration" on page223).
There are two ways to open a JSON file with a wizard: from the Welcome screen or from the
File menu.
l From the Welcome screen
1. Open the PlanetPress Connect Welcome page by clicking the icon at the top right
or select the Help menu and then Welcome.
2. Click New DataMapper Configuration.
3. From the Using a wizard pane, select JSON.
4. Click the Browse button and select the file you want to work with. Click Next.
l From the File menu
1. In the menu, click File > New.
2. Click the Data mapping Wizards drop-down and select From JSON File.
3. Click Next.
4. Click the Browse button and select the file you want to work with. Click Next.
Page 234