DriveWorks Pro 22

Native SQL Server

What's New Native SQL

A new feature for DriveWorks 8 is the support for direct SQL Server connections for the QueryData function and the Data Export document.

ODBC data connections are still fully supported.

Using the native SQL Server connection strings does away with the need to set up system DSN's to each database the implementation relies on. Each machine that the DriveWorks implementation can be specified from requires access to the SQL Server that hosts the database used.

QueryData

To use native SQL server connection when using the QueryData function in the rules builder:

1. Select SQL to connect directly to the SQL Server hosting the database to retrieve the data from.
2. Click the browse button at the end of the SQL String field to launch the wizard for creating the SQL String.
3. Select the SQL Server that hosts the database from the Find Server dialog
4. Click Next
5. Select the database to connect to.
6. Click Finish
7. The connection string to the SQL Server and database will be applied in the SQL String field. Complete the remainder of the QueryData wizard to retrieve the required data.

DataExport

To use native SQL Server connection when using the Data Export document:

1. Select SQL Server Data Export from the new document wizard
2. Enter a name for the document.
3. Click Next
4. Select the SQL Server that hosts the database from the Find Server dialog
5. Click Next
6. Select the database to connect to.
7. Click Next
8. Select the table in the database to export the data into
9. Click Next
10. Select any fields that are to be the control fields for the export
11. Click Next
12. Select any fields that will have common rules applied for multiple row insertion.
13. Click Finish to return to the document editor
14. Build the rules for the data export in the document editor window.