How to Save Mobile Collected Data in Realtime to ODBC Databases (2)

tec-it.com/sto - In this video, we show how to save data recorded with the Scan-IT to Office app (barcodes, QR codes, NFC tags, photos, ...) in your stationary database. The data is transferred from the app to the database via the cloud; collected mobile information is immediately available on-premise for further processing.
For installing the app and the Smart Database Connector receiving software, please refer to video #1.
➡️ ALL ODBC-COMPATIBLE DATABASES
The "Smart Database Connector" software receives the data from the Scan-IT to Office app and saves it in any SQL database. All ODBC-capable database systems are supported. These include Microsoft Access, MySQL, Microsoft SQL Server, ORACLE, etc. Even Microsoft Excel tables or text files can be used via ODBC drivers.
➡️ SET UP 32 BIT DATA SOURCE (DSN)
To use your database with the Smart Database Connector, set it up on the Windows operating system level as a so-called ODBC system data source (DSN): invoke the ODBC Data Sources Administration tool by searching for ODBC Data Sources on Windows or by manually starting the 32-bit ODBC Data Sources Administrator using the %windir%\syswow64\odbcad32.exe command (the ODBC administration requires administrative rights).
A newly created Microsoft Access database, configured as a 32-bit DSN with Microsoft Access ODBC drivers, is used in this video for demonstration purposes.
➡️ WHY 32-BIT?
The Smart Database Connector requires a 32-bit DSN - even if you are working on a 64-bit system. We decided to do this because the support for 32-bit ODBC drivers is (still) somewhat broader on the market. We will publish a pure 64-bit version in the future if required.
➡️ SET DSN IN SMART DATABASE CONNECTOR
After configuring the DSN, add a new database endpoint in the Smart Database Connector. The Smart Database Connector runs as a system service in the background. Use a browser for management; the management URL is usually localhost:33333 (or, depending on the availability of free ports 33334, 33335, ...).
For a new database endpoint, provide the following information:
- the name of the DSN
- an SQL INSERT statement that stores the data received from the app in the database you provide.
The SQL statement must match your database and table layout. The data recorded with the app is available via so-called placeholders (in the form %NAME%) in the Smart Database Connector. Use the placeholders in the SQL statement as required.
The available placeholders depend on the operating mode of the Scan-IT to Office app:
- When using the default scanner view of the Scan-IT to Office app (with the large scan button), the scanned data is available via the %BARCODE% placeholder.
- In input forms (e.g., with several input fields), the names of the placeholders correspond to the field names in the form editor.
There are also placeholders for system data; please refer to the documentation.
➡️ OPERATION
To demonstrate the functionality, pair the app with the database by scanning the QR code displayed by the Smart Database Connector. Whenever you scan a barcode with the app, the data is transferred to the Smart Database Connector via cloud services and immediately saved in the Microsoft Access database using the configured SQL statement.
➡️ INVENTORY MANAGEMENT WITH QUANTITY CONTROL AND MORE
Scan-IT to Office offers additional enhanced features: when using a database that supports Stored Procedures (such as Microsoft SQL Server), you can define arbitrary complex database logic. Functions such as inventories, shipping/receiving, maintenance logs, attendance lists, storage location queries, or tracking/tracing tasks are solved quickly.
➡️ MORE VIDEOS
To stay tuned, subscribe to our channel. The next video in this series showcases a straightforward inventory management solution using Microsoft SQL Server.
➡️ LINKS
Smart Database Connector for Microsoft Windows: tec-it.com/sto
Scan-IT to Office app (Android): play.google.co...
Scan-IT to Office App (iOS): apps.apple.com...
COPYRIGHT ©
TEC-IT Datenverarbeitung GmbH, Austria
www.tec-it.com
Music: The Forest of Lights by Hiddeminside (www.jamendo.co...)
TRADEMARKS
All products mentioned are trademarks or registered trademarks of their respective companies.

[@jxkers87]

I'm interested in the 64 bit version hope it will be published soon in the near future

[@TECITSoftware]

Hi! Are you using Microsoft Access as database? If yes - please install the "Microsoft Access Database Engine 2010 Redistributable"
www.microsoft.com/en-us/download/confirmation.aspx?id=13255
Install the 32 bit version of the driver, it includes accdb support. After installation adjust a new ****32 bit ODBC DSN***** using this driver and configure this DSN as endpoint in the Smart Database Connector.
Yours, TEC-IT