Adding Database Data

You can add database data to your projects.

To add database data to your projects:

1. From the Home page, in the Create section, click VA Project.
2. In the Add Data Source dialog, select an existing database data source, or click Create a New Source.
3. Select the connection that you want to use.
4. Select the database and table you want to use or enter a logical SQL statement. For more information, see Composing Data Sources from Databases.
5. Preview the data, and make column exclusions as needed.
6. Optionally, change the Query Mode for a database table. The default is Live because database tables are typically large and shouldn’t be copied to cache. If your table is small, then choose Auto and the data is copied into the cache if possible. If you select Auto, you will have to refresh the data when it is stale.
7. Click Add to Project to accept the data associations. See Blending Data that You Added for details on manually editing data associations.

Note:

The database connection must be created before you add that data to projects. For more information, see Creating Database Connections.