Difference between revisions of "ODBC Service"
| Line 39: | Line 39: | ||
<span style="font-size:medium;">2.Click "Next" to continue the setup wizard.</span> | <span style="font-size:medium;">2.Click "Next" to continue the setup wizard.</span> | ||
| − | <span style="font-size:medium;">[[File:ODBC install 1.PNG | + | <span style="font-size:medium;">[[File:ODBC install 1.PNG|500x400px|ODBC install 1.PNG]]</span> |
| + | |||
| + | |||
| Line 51: | Line 53: | ||
<span style="font-size:medium;">3.Select installation folder then click "Next"</span> | <span style="font-size:medium;">3.Select installation folder then click "Next"</span> | ||
| − | <span style="font-size:medium;">[[File:ODBC install 2.PNG | + | <span style="font-size:medium;">[[File:ODBC install 2.PNG|500x400px|ODBC install 2.PNG]]</span> |
| + | |||
| + | |||
| Line 61: | Line 65: | ||
<span style="font-size:medium;">4.Click "Next" to begin the installation</span> | <span style="font-size:medium;">4.Click "Next" to begin the installation</span> | ||
| − | [[File:ODBC install 3.PNG | + | [[File:ODBC install 3.PNG|500x400px|ODBC install 3.PNG]] |
| + | |||
| + | |||
| Line 69: | Line 75: | ||
<span style="font-size:medium;">5. complete the installation, click "Finish" to exit the setup wizard</span> | <span style="font-size:medium;">5. complete the installation, click "Finish" to exit the setup wizard</span> | ||
| − | <span style="font-size:medium;">[[File:ODBC install 4.PNG| | + | <span style="font-size:medium;">[[File:ODBC install 4.PNG|500x400px|ODBC install 4.PNG]]</span> |
Revision as of 09:04, 21 May 2018
Introduction
Open Database Connectivity (ODBC) is a standard API for access database. It design independent of database systems and operating systems.
ODBC service can become multi-module interface. User just store data in csv file and ODBC handler can upload data to Cloud.
ODBC Service
ODBC service can easily upload data to the cloud. It will be load the config file and the last data of system record when the service does initialization. The last recorded data Compare with data of database (CSV file) to decide whether to retain index value or not. Every time new data is detected from database, the service will upload new data to cloud and record the last data that is prevent repeat to upload when the service is restarted.
User need observe the following points:
- Append data to database: User write data to database (CSV file) please add data after the last index.
- Add database (CSV file) is invalid at runtime service.
- Recycle: If user wants to clear data in database please start from the first index.
- Have need of timestamp item and put in the fisrt column about data of database.
- Don't prohibit reading permission when user write data to database.
How to
Installation
1.Double click Agent_ODBC_Handler_X.X.X.exe to install.
2.Click "Next" to continue the setup wizard.
3.Select installation folder then click "Next"
4.Click "Next" to begin the installation
5. complete the installation, click "Finish" to exit the setup wizard
