Getting Started with SQL Connection

SQL Connection is an API and a set of database drivers that enable Synergy applications to use SQL-based functions to access and manipulate data from various database systems, such as Oracle and SQL Server. The SQL Connection API consists of two types of functions:

Every SQL Connection function generates a value and can be used any place a literal can be used in a Synergy program. Except where noted, SQL Connection functions work with both traditional Synergy and Synergy .NET.

For an overview of the steps you will need to follow to use SQL Connection in your Synergy program, see Writing an SQL Connection program.

Features and supported databases

Components and configurations

Installing, configuring, and initializing

Setting options and environment variables