Skip to main content
SAP SQL Anywhere is a relational database management system from SAP, designed for embedded and remote-office deployments. It supports standard SQL and provides a lightweight, self-managing database engine commonly used in distributed enterprise applications.

​
Configuring SAP SQL Anywhere as a Source

In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the SAP SQL Anywhere option from the list of connectors. Click Next and you’ll be prompted to add your access.

​
1. Add account access

You’ll need the connection credentials for your SAP SQL Anywhere database instance.
The database user must have read access to the schemas and tables you want to extract. We recommend creating a dedicated read-only user for Nekt.

​
2. Configuration Options

  • Host: The hostname or IP address of your SAP SQL Anywhere database server.
  • Port: The port number for your database connection. The default port for SAP SQL Anywhere is 2638.
  • Database: The name of the database you want to connect to.
  • User: The username for authenticating with the database.
  • Password: The password for the database user.

​
Advanced Settings

  • Server Name (optional): The server/engine name (eng parameter). Only needed if your SAP SQL Anywhere instance requires it.
  • Filter Schemas (optional): An array of schema names to include. If left blank, all available schemas will be discovered.
  • Chunk Size: The number of rows to fetch at a time. Default is 20000. Set to 0 to fetch all rows at once (not recommended for large tables).

​
3. SSH Tunnel (optional)

If your SAP SQL Anywhere database is behind a firewall, you can connect through an SSH tunnel (bastion host).
1

Enable SSH Tunnel

Toggle the SSH Tunnel option to enabled.
2

Enter SSH Server Details

  • SSH Host: The hostname of your bastion/jump server.
  • SSH Port: The SSH port (default: 22).
  • SSH Username: Your SSH username.
3

Provide Authentication

Use either a password or a private key:
  • SSH Password: Password for the SSH server, OR
  • SSH Private Key: PEM-formatted private key for key-based authentication.

​
4. Select streams

After configuring your connection, Nekt will discover all available tables and views from your SAP SQL Anywhere database. Select the tables you want to sync.

​
5. Configure data streams

For each selected table, you can configure:
  • Replication method: Choose between Full Table (complete sync each run) or Incremental (only new/updated rows based on a replication key column).
  • Replication key: For incremental sync, select the column that tracks changes (typically a timestamp or auto-incrementing ID column).

​
6. Verify and save

Review your configuration and click Save. Nekt will begin syncing data from your SAP SQL Anywhere database on the configured schedule.

​
Supported Data Types

SAP SQL Anywhere data types are automatically mapped to the appropriate types in Nekt’s Catalog:
SAP SQL Anywhere TypeNekt Type
INTEGER, BIGINT, SMALLINT, TINYINTInteger
FLOAT, DOUBLE, REAL, NUMERIC, DECIMALNumber
MONEY, SMALLMONEYNumber
CHAR, VARCHAR, NCHAR, NVARCHAR, TEXTString
DATEDate
DATETIME, TIMESTAMPDateTime
TIMEString
BITBoolean
UNIQUEIDENTIFIERString
BINARY, VARBINARY, LONG BINARY, IMAGEString (hex-encoded)