Using SQL Direct - Setting Up

To use SQL Direct 12.0 you must have AVEVA 12.0 or later installed, as well as have some project data.

If you want to use the intended functionality based on SQL Server, you will also need to have this product installed.

Then, you need to:

1. configure SQL Direct with the necessary paths and environment variables to match the particular project database or databases you wish to access.

2. design a set of tables that defines the structure of the data to be passed to the data consumer. SQL Direct comes with some preconfigured tables, although you may also design your own.

3. If you want to use SQL Server, you also need to:

4. configure SQL Server with the necessary data views to match the tables you have defined.

See SQL Direct Components, Using SQL Direct Components and Using SQL Direct - Some Examples for more details of these operations.