Who this is for
Plants and warehouses running on SAP whose HANA database can be queried directly and whose labelling is currently a separate manual system.
How it works
Step by step
- Install the LabelInn Windows app and your SAP HANA client driver on the machine that will run the job.
- Add the SAP HANA connection: host, port 30015, database and a database user that can read the tables you need.
- Write the SAP HANA SQL query that returns exactly the rows you want to label, one row per label.
- Map each result column onto a label field — text, barcode, QR or RFID — then preview a few rows.
- Print the result set, or save the query so the next run is one click.
Write ordinary HANA SQL. Use FETCH FIRST n ROWS ONLY while you are testing so a preview never pulls the whole table.
Try it with your own data — signing up starts a 14-day Pro trial, no credit card. After that this feature needs Starter at $7.99/mo. Download now → | See pricing →
What you can do
- Result columns bind to any label field, so barcode and QR content comes straight out of SAP HANA.
- Re-run the saved query whenever you need the current rows — no export, no copy-paste, no stale file.
- Mix database columns with static text, counters, dates and serial numbers on one label.
- Printed rows are recorded in the print history, so a reprint or an audit can find the exact job later.
- Queries can be parameterised, so an operator supplies a work order or batch number instead of editing SQL.
Technical details
| Engine | SAP HANA |
|---|---|
| Default port | 30015 |
| Query language | SAP HANA SQL |
| Row limit syntax | … FETCH FIRST n ROWS ONLY |
| Driver | Your own ODBC/OLEDB/Oracle client driver |
| Platform | Windows desktop app |
| Credentials | Stay on your machine; the query runs from your network |
Requirements for a direct database connection
- Direct database connections need the LabelInn Windows desktop app — the connector that loads real database drivers is a Windows sidecar, so this path is not available on macOS today.
- You supply the SAP HANA client driver; LabelInn does not redistribute database drivers.
- Point the connection at a read-only database user. LabelInn reads rows to fill labels — it should never need write access.
- While you are testing, keep the query small with `… FETCH FIRST n ROWS ONLY` so a preview cannot pull an entire table.
- This is a direct HANA database connection. LabelInn does not implement SAP RFC, IDoc or BAPI integration, and does not install anything inside your SAP system.
- Your SAP administrator has to grant a database user that can run the query you need.
What happens after you download?
Frequently asked questions
Does label data leave my network when I print from SAP HANA?
The query runs from the machine you installed LabelInn on, against your own SAP HANA server. Credentials stay local. What leaves the machine is what you choose to sync — the label design and the print record.
Which SAP HANA SQL do I write?
Ordinary SAP HANA SQL. LabelInn does not rewrite your SQL; it runs the statement you saved and maps the result columns onto label fields. Use `… FETCH FIRST n ROWS ONLY` while testing.
Can I print to a Zebra or TSC printer from SAP HANA without a driver?
For models LabelInn drives natively over ZPL, TSPL or TPCL, yes — the command stream is generated and sent directly. That is independent of the database driver, which is only used to read your rows.
What we verified
The capability is implemented in the LabelInn codebase and the referenced source file names the exact format, engine, port or endpoint described on this page.
lib/models/database_connection.dart — DatabaseKind.sapHana('sap_hana', 'SAP HANA', 30015)
Print your SAP HANA data on the printer you already own
This feature runs on Starter — $7.99/mo, or $79.90/year (pay for 10 months, use 12). Signing up starts a 14-day Pro trial, so you can bind your own SAP HANA data and print a real label before you pay anything.
Start your 14-day Pro trial → Download the app