Home » Categories » Solutions by Business Process » SQL

SQL Out

Datafile Software

SQL Out

The SQL Configuration has two schedules – one for SQL updates TO the Datafile system, and one for SQL Updates FROM the Datafile System. (SQL Updates to the Datafile system are outside the purview of this manual.)

To start select ‘Load Config File’ and select the SQLMGR.INI from the ‘DatafileSQL’ folder.

The SQL Out configuration asks:

Optimise REC # - when running a global refresh / flush of a Datafile database to an SQL table this is the number of records the SQL Manager will process in one go, before continuing with the next X records.

Drop Limit – set the number of times the Datafile SQL Driver will attempt to update a mirror entry before abandoning and moving on to the next entry.

Job Limit – Set the maximum number of Datafile databases that are to be mirrored to an SQL table.

SQLDET path – the SQLDET.DFD is the interface database that contains the list of Datafile databases and the record numbers that have been amended you set the path to this file here (the installation procedure updated this file into the required Datafile DFCOMP location – where the DIAMOND.D02 is held – and updated the correct path here).

IP Address – enter the IP address for the SQL Server

Database – enter the SQL Database filename

Username – enter username that allows access to the SQL Database

Password – enter password for access to the SQL Database

Once parameters are set select the TESTING option – this checks that the driver can access the SQLDET.DFD and can connect to the SQL server, access the SQL Database, create a SQL table, add, update and delete records within the table, and delete the table. If these tests succeed a green block will appear next to the option, any red blocks denote an error in either the details entered or the SQL Server / Database configuration.

To complete configuration select the SAVE CONFIG button and then use the X-close icon to close the configuration screen.

The SQL Configuration utility maintains a SQLMGR.INI – this file can also be edited using Notepad or WordPad and a link has been added to the Datafile SQL Driver folder off the Start Menu to edit this file with Notepad.

The INI contains some additional parameters that may need to be amended under rare circumstances. In the [MAIN] section is an option for

Debug – this provides extra information to an error log in case of a problem

In addition by default the installation assumes you are linking to an MSSQL Server, if linking to a MySQL Server then you need to update the ‘mssql’ entries for Database, User Id, Password and IP address to read ‘mysql’ accordingly.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Suspend SQL Mirroring During Night / Weekends
Viewed 1922 times since Fri, Oct 26, 2012
Datafile SQL Configuration
Viewed 1875 times since Thu, Jul 5, 2012
Configuring the Datafile System
Viewed 2066 times since Thu, Jul 5, 2012
Additional SQLDET.DFD Maintenance Options
Viewed 8936 times since Mon, Jun 11, 2012
Database Refresh - Empty Table and Re-Import Data
Viewed 2285 times since Mon, Jun 11, 2012
SQL In
Viewed 1967 times since Thu, Jul 5, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4209 times since Fri, Jul 21, 2017
Installing the Datafile SQL Driver
Viewed 2601 times since Thu, Jul 5, 2012
SQLDET Database Structure
Viewed 4310 times since Mon, Jun 11, 2012
Running the SQL Manager
Viewed 2226 times since Thu, Jul 5, 2012