Connect barcode scanner apps to SQL Server
StepVane connects to SQL Server from the server PC. Pull data into lookup tables that every handheld carries, run your stored procedures from a workflow, and write what workers capture back to a table.
How it works
Pull data with a query
Write a SELECT query and StepVane builds the columns. The server refreshes the table on a schedule you choose, and every handheld keeps a copy, so scans are checked against your data even with no signal.
Run stored procedures
A database command step in a workflow runs your stored procedure with values from the page.
Write records to a table
Add a Send data step that adds a new row to a database table, with each column filled from a field or a fixed value.
Credentials stay on the server
The connection is registered once on the server, by name. Its password is encrypted on the server, and a handheld never receives a query or a connection string.
Copy on a schedule
Copy between systems moves rows between a database and the app's tables, at set times or when you press Run now.
Questions
- Do the handhelds connect to my database?
- No. Only the StepVane server talks to the database. The handhelds receive lookup tables from the server and send records to it.
- Which databases are supported?
- SQL Server, PostgreSQL and any database with an ODBC driver.
- Which database login should I use?
- A login with only the rights the app needs: read access for a lookup table, and insert access for a table you write to.
- Does it work without Wi-Fi?
- Yes. Work is saved on the handheld first and uploads when the server can be reached again. The worker sees how much is waiting, and lookup tables stay on the device so scans are still checked against your data.
- Do I need a cloud account?
- No. The Windows PC that runs StepVane is the server, and the handhelds sync with it over your own network. There is no StepVane cloud account to create.
Watch how it is set up
Used in
Other integrations
Start with one device today
Free for Studio, one handheld and one worker. No cloud account, no credit card.