SQLData object overview

The SQLData object provides an interface to a Microsoft SQL Server running on any computer on the network. You can configure the SQLData object to either connect to an existing SQL Server database table, or you can create a new SQL Server database and database table.

Use of a non-default port for connecting to SQL Server is supported. Enter the non-default port number in the Database tab when you configure the SQLData object.

The database columns configured in the SQLData object can be assigned to any attribute in the Galaxy. These are called "assigned attributes." The object can read the database values of the selected SQL Server database record and write to the assigned attributes. Conversely, the object can read the assigned attribute values and write to the database by appending a new record or modifying the currently selected record. For information on data types for columns, see SQL data types.

It is recommended that you use one SQLData object per SQL Server database table. In the case of a large table, a number of SQLData objects can be used to read and write a subset of data in the table, if required.

The SQL Server database table can have a maximum of 1024 columns or a maximum combined row size of 8060, depending on which limit is exceeded first. The SQLData object is limited by the database table limit.

A valid example would be: 5 Strings (5 x 512 = 2560), 10 Floats (10 x 4 = 40), 50 Integers (50 x 2 = 100) and 1000 Booleans (1000 x 1 = 1000), where the total row size is 3700.

The number of rows of the table is limited by the amount of storage space available on the server.

The SQLData object supports:

• AppEngine redundancy

• Redundancy provided by a RedundantDIObject object.

• Connection to the MSDE and Microsoft SQL Server database.

For general information on objects, including relationships, deployment, and alarm distribution, see the Integrated Development Environment (IDE) documentation. You can access the IDE Help from within the IDE by clicking Help Topics on the Help menu.