PRO — $24.90/MO / 14-DAY PRO TRIAL ON SIGNUP

Print labels from SAP HANA

Connect the LabelInn Windows app to SAP HANA, write a read-only SELECT ... FETCH FIRST n ROWS ONLY query, and each row prints as one label. HANA is the one engine where you install the driver yourself: SAP does not allow the HANA Client to be redistributed. This page documents the connector from its code; no HANA server was available to test against.

Start free Download LabelInn
PRO PLAN · 14-DAY TRIAL · WINDOWS DESKTOP APP
DATABASE QUERYROWS TO LABELS
Print labels from SAP HANA — LabelInn
Native printer languagesZPL, TSPL, TPCL, ESC/Label
No driver to installUSB, network or Bluetooth
Every platformWindows, macOS, Android, web
Free to startNo credit card, 14-day Pro trial

HOW IT WORKS

Three screens from data to printed label.

No copy-paste, no hunting for templates. The same flow repeats for every record.

Database schema browser
01 / CONNECTConnect the database

Choose the engine, test the connection and browse the schema.

Running a query
02 / QUERYWrite one query

A named, parameterised query returns the rows a label needs.

Print dialog
03 / PRINTPrint straight from rows

Preview, pick the printer and print the result.

01

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.

02

Step by step

  1. Install the LabelInn Windows app and the SAP HANA Client on the machine that will run the job.
  2. Add the SAP HANA connection: host, port 30015, database and a database user that can read the tables you need.
  3. Write the SAP HANA SQL query that returns exactly the rows you want to label, one row per label.
  4. Map each result column onto a label field — text, barcode, QR or RFID — then preview a few rows.
  5. Print the result set, or save the query so the next run is one click.
Choose the database type: LabelInn app screenshot
1Choose the database typeOracle, MySQL / MariaDB, PostgreSQL, Microsoft SQL Server and SAP HANA are supported.

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 database sources need Pro at $24.90/mo. Download now → | See pricing →

03

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.

04

Technical details

ItemDetail
EngineSAP HANA
Default port30015
Query languageSAP HANA SQL
DriverThe one engine where you supply the driver: install the SAP HANA Client (SAP does not allow redistribution). Without it the bridge answers driver_not_found.
PlatformWindows desktop app only. The connector is a Windows program that runs next to the app; on macOS and Linux use Excel or CSV.
CredentialsA connection created in the desktop app keeps its password in the PC's secure storage (Windows DPAPI); host, port, database and user name are saved with the connection. A connection created from the dashboard or the API stores the password encrypted (AES-256-GCM) in your company's cloud record and the PC fetches it when it runs a query.
AccessRead-only: only SELECT and WITH statements run. The connection test reports the server version and whether the account looks read-only.
DefaultsRow limit 1000 and timeout 30 seconds per saved query (both editable, timeout up to 300).
PlanPro ($24.90/month, $249/year). Without it you can still connect, run the query and see the first 10 rows; binding an element or printing the set needs Pro. The 14-day trial from sign-up includes it.

05

Requirements for a direct database connection

  • The LabelInn Windows desktop app, on a PC that can reach the database server. The connector does not run on macOS.
  • The SAP HANA Client installed on that PC. It is the only driver LabelInn cannot ship.
  • A database user with SELECT on the tables you label and nothing else. LabelInn never needs write access for printing.
  • A Pro plan or the 14-day trial to bind and print; connecting and previewing 10 rows is open to every plan.

BEFORE YOU START

The SAP HANA Client is your part of the job

  1. Install the SAP HANA Client on the Windows PC that runs LabelInn (or place Sap.Data.Hana.Core.v2.1.dll next to the connector program).
  2. Restart the connector, which the app does when it starts. It looks for the driver by name (Sap.Data.Hana.Core.v2.1 first, then the older Sap.Data.Hana.Net.v4.5).
  3. Run the connection test. If the driver is missing every call answers driver_not_found with the message "SAP HANA driver not found. Install the SAP HANA Client on this host".
Status of this page

The driver lookup, the connection string and the error text are read from SapHanaProvider.cs. The SQL on this page was written from the SAP HANA SQL reference and has not been executed. If you run it and it differs, tell us.

CONNECTING

HANA specifics: port, tenant, schema, TLS

LabelInn connection wizard, step 2: connection name, host, port, database and TLS selector for SAP HANA
The Connection details step. Host, Port and Database are the three values everyone needs; the TLS selector is explained below.
LabelInn saved-query editor with the SQL box, detected parameters, row limit 1000, timeout 30 seconds and a result table
Saved query editor: "SELECT/WITH only. Use :name syntax for parameters", row limit and timeout, and Run sample. On SAP HANA the query uses FETCH FIRST.
SettingWhat to enter
Host and portThe HANA host and the SQL port (30015 is the default in the form; a tenant database of a multi-tenant system usually has its own port).
DatabaseThe tenant database name, if you connect to one (sent as DatabaseName).
SchemaOptional. Sent as CurrentSchema, so tables resolve without a prefix, which matters on SAP Business One where tables live in a company schema.
TLSEncryption (ENCRYPT=TRUE) is on unless you choose "Disable".
Placeholders:name is native on HANA, the same as Oracle.

THE QUERY

A label query in SAP HANA SQL

EXAMPLESQL
SELECT sku, product,
       CAST(price AS NVARCHAR(12)) AS price,
       barcode, batch,
       TO_VARCHAR(expiry, 'DD.MM.YYYY') AS expiry
FROM labelinn_demo_products
WHERE batch = :batch
ORDER BY sku
FETCH FIRST 50 ROWS ONLY

Convert numbers and dates to text in the query for the same reason as on the other engines: the result is delivered as typed values, and a DECIMAL 4.90 would reach the label as 4.9. The read-only guard applies as everywhere: one SELECT or WITH, no CALL, no EXEC.

labelinn-sample-products-saphana.sqlCreates and fills labelinn_demo_products (8 rows) / not executed: no HANA instance available

ANY PRINTER

Design it, bind your data, print on the printer you already own.

Zebra, TSC, Toshiba, Epson and more — over USB, network or Bluetooth, with no driver to install.

LabelInn on a laptop with a thermal printer and the printed label

PRICING

Start free. Pay when it earns its keep.

Compare every plan →

Free$0

Unlimited printing and templates, cloud sync, 30-day print history.

 Starter$7.99/mo

Excel and CSV binding, full print history, 2 users and 2 devices.

 Pro$24.90/mo

Marketplace and shipping, API and webhooks, 3 users and 3 devices.

QUESTIONS / FAQ

Frequently asked questions

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.

Does label data leave my network when I print from SAP HANA?

The query runs on the PC where LabelInn is installed, against your own SAP HANA server, and the rows fill the label there. What is stored in the cloud is the label design and the print record, plus the connection's host, port, database and user name. The password depends on how the connection was made: A connection created in the desktop app keeps its password in the PC's secure storage (Windows DPAPI); host, port, database and user name are saved with the connection. A connection created from the dashboard or the API stores the password encrypted (AES-256-GCM) in your company's cloud record and the PC fetches it when it runs a query.

Why does LabelInn not include the SAP HANA driver?

The SAP HANA Client is licensed by SAP and may not be redistributed in another product. Install it from SAP on the PC that runs LabelInn; the connector loads it by name when it starts.

Can I print labels from SAP Business One on HANA?

The connector reads any table or view the HANA user can select, so Business One tables can feed labels. Set the company schema in the connection so the table names resolve. This has not been tested here against a Business One system.

What does driver_not_found mean?

The SAP HANA Client was not found on the PC. Install it, restart LabelInn (which restarts the connector) and run the connection test again.

KEEP GOING

Related pages

NEXT STEP / LABELINN

Print your SAP HANA data on the printer you already own

Database sources run on Pro — $24.90/mo, or $249/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. · 14-day Pro trial on signup · No credit card required · Database connections run on the Windows desktop app

Start free →