SQLData Script Library

The SQLData Script Library provides database integration using ArchestrA scripting. The SQLData Script Library provides the following benefits:

• Your resources are managed more efficiently because the connection manager reduces the number of open connections to the database provider. This activity is known as connection pooling.

• You can process scripts asynchronously, which reduces impact on the hosting engine during the following activities:

  • Opening a connection to a data source

  • Running SQL queries

  • Running SQL transactions

    Note: It is recommended, to avoid returning excessive amount of data using script library commands, for example executing 15,000 SQL commands which each select 200 records from the Person.Contact table in the AdventureWorks sample database. This can lead to a crash of the host engine. To avoid this problem, consider using the TOP command to limit the number of records returned.