To Add Database For Export To Client

Before You Start

• Make sure your data source is configured and connected. For details see Connecting to a Data Source.

• Download the objects/tables from the connected source. For details see Downloading and Discovering Enterprise Objects.

Create a new Database Export file

1. Click on Solutions Explorer > Database Export >right-click on Database > select Add New Database.
2. Complete the settings in the new file. For a description of each of the fields, see the Database Export topic.
3. The Source Table is a drop down list of tables from a connected data source (i.e. a connection to a database).
   Note: If the Source Table drop down list is blank, make sure the data source (i.e. database) is connected, and that the objects (tables, columns) have been downloaded and discovered.
4. Click Save to save your changes.
5. Refer to Solution Explorer > Profiles and tap the Select Applications icon then scroll to the bottom of the list of the Users, Menus, and Applications pane to select the Database Exports database file.

Enhance Performance with SQL Statements

When creating your SQL Statements (like Where clauses for faster extraction of data to the app), note that the columns Field Names) listed in your SQL statement are limited to the references listed in your Database Fields - Field Names.

Checking the Index box will create an index against the database that will be provisioned on the client.

Checking the Normalize box will trim the data using the rule selected from the Data Normalization field.

Tap the Validate button to see the total rows and estimated size of data based on the results of your SQL statement.

Click the Save button to save your changes.