Survalent – Database Transcription Program – Using MySQL

Install Database Transcription Program (setuptransw.exe) provided by survalent.

Locate : C:\Program Files\Survalent\Transcription\
Rename this files:

> dbtargets_template.txt — dbtargets.txt
> host_template.ini — host.ini
> scada_template.udl — scada.udl

Configure Host.ini with this format :

[Hosts]

HostA=192.xxx.xxx.xxx > SCADA Server IP Address
HostB=
HostC=
HostD=

[User]
Username=SCADA
Password=SCADA

[DEFCOL]
TYPE=TYPE_Q
TABLES=TABLES_Q

Follow: Database Transcription User Guide.pdf For database and table configuration

Add User.DNS using ODBC {Control Panel\Administrative Tool\Data Source (ODBC)}
> At Advance MySQL Configuration Enable this Flags

Flag 1: Return matched rows, Use Compression, Treat BIGINIT as INIT, Enable Safe
Flag 2: Don’t promt when connecting, Enable dynamic cursor

Start Database Transcription Program : (scadup.exe)