Installation Guide for the ODBC Plugin
Overview
This document is a quick start guide for user to know how to install ODBC Plugin.
In this document, you may follow the steps to install and configure the plugin.
Required Package
1.RMM Agent:
RMM 3.3 Agent Plus Setup_3.3.18.exe
2.ODBC Plugin:
ODBCPlugin_standard_v1.0.xxxx.zip
How to install ODBC Plugin
1.Install WISE-PaaS Agent 3.3.
2.Stop the services SAWatchdog and AgentService_32 from Task Manager.
3.UnZIP the ODBC plugin package and install below files manually:
3.1.Copy the files ODBC_Handler.ini to the folder where the WISE-PaaS Agent installed. ( by default, the path is C:\Program Files (x86)\Advantech\RMM 3.3 Agent )
3.2.Copy the file ODBC_Handler.dll to sub-folder \module where the WISE-PaaS Agent installed. ( by default, this path is C:\Program Files (x86)\Advantech\RMM 3.3 Agent\module )
4.Open the file ODBC_Handler.ini and set the [Text] session
4.1FilePath: Set path of the CSV file locate, for example C:\Test
4.2FieldName & FieldDataType: Set data type of the each field name include CSV file.
Support data type: timestamp, double, string, float, boolean.
For example: 1. TIME = timestamp 2. No#1EC = double 3. No#1ph = float ……
[Setting]
#ODBCDriver=Microsoft Access Driver (*.mdb)
#ODBCDriver=MySQL ODBC 5.3 Unicode Driver
#ODBCDriver=PostgreSQL ANSI
#ODBCDriver=Microsoft Excel Driver
ODBCDriver=Microsoft Text Driver (*.txt; *.csv)
ReadOnly=0
…
[Text]
FilePath=C:\Test
FieldName=TIME,No#1EC,No#1ph,No#2EC,No#1es,No#1e,No#1HumidityRatio,No#2ph
FieldDataType=timestamp,double,float,string,float,double,double,float
5.Open the file \module\module_config.xml and add the new session <ModuleNameXX>, <ModulePathXX> and <ModuleEnableXX> for keep ODBC_Handler configurations, also remember to update total module number for the session <ModuleNum>, for example:
<?xml version="1.0"?>
<XMLConfigSettings><BaseSettings>
<ModuleNum>1'8'</ModuleNum>
…
<ModuleName1'8'>'ODBC_'Handler</ModuleName1'8'><ModulePath1'8'>\module\'ODBC_'Handler.dll</ModulePath1'8'><ModuleEnable1'8'>TRUE</ModuleEnable1'8'>
</BaseSettings></XMLConfigSettings>
6.Make sure the settings in the agent_config.xml are correct, include <ServerIP>, <DeviceName>, <DevID> and <WorkDir> of your machine, for example:
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<XMLConfigSettings>
<BaseSettings>
<RunMode>RemoteConnect</RunMode>
<AutoStart>True</AutoStart>
<ServerIP>'127.0.0.1'</ServerIP>
<ServerPort>1883</ServerPort>
<ConnAuth>fENl4B7tnuwpIbs61I5xJQ==</ConnAuth>
<TLSType>0</TLSType>
<CAFile/>
<CAPath/>
<CertFile/>
<KeyFile/>
<CertPW/>
<PSK>05155853</PSK>
<PSKIdentify/>
<PSKCiphers/>
</BaseSettings>
<Profiles>
<DeviceName>'ODBCTEST'</DeviceName>
<DevID>0000D850E6C4CED3</DevID>
<SN>60A44CE9EA69</SN>
<DevType>IPC</DevType>
<WorkDir>C:\Program Files (x86)\Advantech\RMM 3.'3'Agent\</WorkDir>
<SWVersion>3.'3'.1'5'.0</SWVersion>
…
- Prepare your data file (.csv) and copy the file into the folder you assigned in the ODBCHandler.ini.
- Re-start SAWatchdog and AgentService_32 and open the RMM 3.3 web page, for example http://127.0.0.1:8080 if you install RMM 3.3 Server and Agent in same host. then input user id & password to login.
Add your device and check if ODBC_Handler tab is created in the hardware information screen.