如何在复制活动源数据集中导入SAP HANA表架构 [英] How to import SAP HANA table schema in copy activity Soure dataset

问题描述

我将SAP HANA作为源，并尝试在源数据集的复制活动中导入表的模式，但是可以使用诸如Table(如oracle中的表)之类的任何选项来指定表名称，以便如果我进入Schema并单击在导入模式上.

如果不存在，我需要为此手动执行json.

我也可能知道类似HANA数据类型，如下所示，并试图在ADF中查找等效数据类型.我尝试过博客，但无法找到页面

<身体>

HANA中的数据类型	Azure数据类型
CLNT
CHAR	字符串
NUMC	整数/十进制
QUAN
DATS
Lang
UNIT
DEC
INT2	小整数
INT1
CURR
CUKY
TIMS
INT4	整数
劳拉
FLTP
RAW
ACCP

请对此加以说明...

预先感谢......

-Poornima M

解决方案

你好Poornima，

您看过这张桌子吗?

https://docs.microsoft.com/zh-CN/azure/data-factory/connector-sap-hana#data-type-mapping-for-sap-hana

Hi ,

I have SAP HANA as my source and trying to import schema for a table in copy activity of source dataset but there is any option like Table ( as in oracle) to specify the table name so that if I go to Schema and click on Import schema .

If this is not there i need to manually do the json for this.

Also may i know this like there were HANA data types like below and trying to find Equivalent data type in ADF .I tried from blogs but not able to find a page where it says on this.

Data type in HANA	Azure Datatype
CLNT
CHAR	string
NUMC	integer/decimal
QUAN
DATS
LANG
UNIT
DEC
INT2	small int
INT1
CURR
CUKY
TIMS
INT4	integer
LRAW
FLTP
RAW
ACCP

Please throw some light on this .....

Thanks in advance ......

--Poornima M

解决方案

Hello Poornima,

Have you seen this table:

https://docs.microsoft.com/en-us/azure/data-factory/connector-sap-hana#data-type-mapping-for-sap-hana

这篇关于如何在复制活动源数据集中导入SAP HANA表架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！