Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

SAP HANA Source and Microsoft Azure Synapse Analytics Target

SAP HANA Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a SAP HANA source and a Microsoft Azure Synapse Analytics target:
SAP HANA Source Data Type
Synapse Analytics Target Data Type
alphanum(
precision
), 1 <= p <= 127
char(
size
), 1 <= s <= 127
array
varbinary(max)
bigint
bigint
binary(
size
), 1 <= s <= 2000
binary(
size
), 1 <= s <= 2000
boolean
bit
char(
size
), 1 <= s <= 2000
char(
size
), 1 <= s <= 2000
date
date
decimal
varchar(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
double
float
float
float
integer
int
nchar(
size
), 1 <= s <= 2000
char(
size
), 4 <= s <= 8000
nvarchar(
size
), 1 <= s <= 5000
varchar(
size
), 4 <= s <= max
real
real
real
real
seconddate
datetime2(0)
shorttext(
precision
), 1 <= p <= 5000
varchar(
size
), 1 <= s <= 5000
smalldecimal
varchar(255)
smallint
smallint
st_geometry
varbinary(max)
st_point
varbinary(max)
time
time(0)
timestamp
datetime2(
precision
), 0 <= p <= 7
tinyint
tinyint
varbinary(
size
), 1 <= s <= 5000
varbinary(
size
), 1 <= s <= 5000
varchar(
size
), 1 <= s <= 5000
varchar(
size
), 1 <= s <= 5000

0 COMMENTS

We’d like to hear from you!