Source SAP HANA
Airbyte’s incubating SAP HANA enterprise source connector currently offers Full Refresh and Incrementals syncs for streams. Support for Change Data Capture (CDC) is currently in-development and will be available soon.
Features
| Feature | Supported?(Yes/No) | Notes |
|---|---|---|
| Full Refresh Sync | Yes | |
| Incremental Sync - Append | Yes | |
| Changa Data Capture (CDC) | No |
Prequisities
- Dedicated read-only Airbyte user with read-only access to tables needed for replication
- SAP HANA Host Name URL
- In the SAP HANA Cloud Management Portal, this can be found under the Connections tab for you SAP HANA instance
- The Host Name is the first portion of the SQL Endpoint before the Port
- ie:01234abce-1234-56fg.us-01-hanacloud.ondemand.com:123
- The Host is also a combination of the Instance ID and Landscape
- Port Number
- Inside of the SAP HANA Cloud Management Portal, this can be found under the Connections tab for you SAP HANA instance
- The Port is listed explicitly in addition to being part of the SQL Endpoint
Setup Guide
- Enter your SAP HANA Host Name
- Enter the Port number
- Provide the login credentials for the SAP HANA account with access to the tables
- Specify the schemas for tables that you would like to replicate
- Select either Full Refresh or Incremental for your desired Sync Type
Data type mapping
SAP HANA data types are mapped to the following Airbyte data types when synchronizing data.
| SAP HANA Type | Airbyte Type | Notes |
|---|---|---|
BOOLEAN | BOOLEAN | |
DOUBLE | NUMBER | |
FLOAT | NUMBER | |
REAL | NUMBER | |
SMALLDECIMAL | NUMBER | |
DECIMAL | NUMBER | |
DEC | NUMBER | |
INTEGER | INTEGER | |
TINYINT | INTEGER | |
SMALLINT | INTEGER | |
BIGINT | INTEGER | |
CHAR | STRING | |
VARCHAR | STRING | |
ALPHANUM | STRING | |
NCHAR | STRING | |
NVARCHAR | STRING | |
SHORTTEXT | STRING | |
TIME | TIME_WITHOUT_TIMEZONE | |
DATE | DATE | |
SECONDDATE | TIMESTAMP_WITHOUT_TIMEZONE | |
TIMESTAMP | TIMESTAMP_WITHOUT_TIMEZONE | |
BINARY | BINARY | |
VARBINARY | BINARY | |
REAL_VECTOR | BINARY | |
BLOB | BINARY | |
CLOB | STRING | |
NCLOB | STRING | |
TEXT | STRING | |
BINTEXT | STRING | |
ST_POINT | BINARY | |
ST_GEOMETRY | BINARY |