Submitting via SQL

An alternative to sharing data through using export files is to use an SQL service. This service can then be used for other purposes, e.g., to front a National Directory pull connector.

In order for the data held within the internal database to be published to SQL, another utility is required to do the publishing.

BDS Solutions have produced SQLconnect to perform this task. This automatically connects to the internal database and publishes this to a specified SQL service, either MS SQL Server or MySQL.

See Publishing to National Directory for more details.