attachments

attachments

关注
发信
关注(28)粉丝(399)

SSIS与SAP OData v4的连接

本文介绍了SSIS与SAP OData v4的连接的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

嗨专家，



我有SAP的SSIS  HANA XSA OData v4问题，我一直在苦苦挣扎。寻找您宝贵的建议。



1.使用网络浏览器或邮递员进行odata服务（v4和v2）时，我们没有任何问题。 v4的详细信息：
$


- 收集URL：https：// hxehost：51028 / catalog /



OData服务日志： 
$


5/14/19 10:43:18000 PM [RTR] OUT    192.168.56.1 - - 到hxehost：51028" GET / catalog / HTTP / 1.1" 200发送152 in 20 by 010-045569cd-c7b2-4770-8475-f518001482c1



收藏：



{

    " @ odata.context"：" $ metadata"，&
    " @ odata.metadataEtag"：" W / \" l4Y9nfxmXiS3w2Lh6W7806U2 / 5vwsw​​Kjb0opSMPEy18 = \""，

    "价值"：[

        {

            "name"："BookInfo"，"
            "url"：" BookInfo"

        }¥b $ b    ]¥b $ b}

$



- 元数据网址：https：/ / hxehost：51028 / catalog / $ metadata



OData服务日志： 



5/14 / 19 10:41:52.000 PM [RTR] OUT    192.168.56.1 - - 到hxehost：51028" GET / catalog / $ metadata HTTP / 1.1" 200发送2305 in 43 by 010-045569cd-c7b2-4770-8475-f518001482c1



元数据：



<？xml version =" 1.0" encoding =" utf-8"？>

< edmx：Edmx Version =" 4.0" xmlns：edmx =" http://docs.oasis-open.org/odata/ns/edmx">

  &NBSP; < edmx：Reference Uri =" https：//oasis-tcs.github.io/odata-vocabularyies/vocabularyies/Org.OData.Core.V1.xml">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" Core" Namespace =" Org.OData.Core.V1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：Reference Uri =" https：//oasis-tcs.github.io/odata-vocabularyies/vocabularyies/Org.OData.Measures.V1.xml">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" Measures" Namespace =" Org.OData.Measures.V1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：Reference Uri =" https：//oasis-tcs.github.io/odata-vocabularyies/vocabularyies/Org.OData.Capabilities.V1.xml">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" Capabilities" Namespace =" Org.OData.Capabilities.V1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：Reference Uri =" https：//oasis-tcs.github.io/odata-vocabularyies/vocabularyies/Org.OData.Aggregation.V1.xml">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" Aggregation" Namespace =" Org.OData.Aggregation.V1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：Reference Uri =" https://wiki.scn.sap.com/wiki/download/attachments/462030211/Analytics.xml?api = v2">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" Analytics" Namespace =" com.sap.vocabularyies.Analytics.v1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：Reference Uri =" https://wiki.scn.sap.com/wiki/download/attachments/448470974/Common.xml？api = v2">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" Common" Namespace =" com.sap.vocabularyies.Common.v1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：Reference Uri =" https://wiki.scn.sap.com/wiki/download/attachments/448470971/Communication.xml？api = v2">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" Communication" Namespace =" com.sap.vocabularyies.Communication.v1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：Reference Uri =" https://wiki.scn.sap.com/wiki/download/attachments/448470968/UI.xml?api = v2">

  &NBSP; &NBSP; &NBSP; < edmx：Include Alias =" UI" Namespace =" com.sap.vocabularyies.UI.v1" />

  &NBSP; < / edmx：参考>

  &NBSP; < edmx：DataServices>

  &NBSP; &NBSP; &NBSP; < Schema Namespace =" CatalogService" xmlns =" http://docs.oasis-open.org/odata/ns/edm">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < EntityContainer Name =" EntityContainer">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < EntitySet Name =" BookInfo" EntityType =" CatalogService.BookInfo" />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / EntityContainer>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < EntityType Name =" BookInfo">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < Key>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < PropertyRef Name =" ID" />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / Key>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < Property Name =" ID"类型=" Edm.Int32" Nullable =" false" />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < Property Name =" copiesSold" Type =" Edm.Int32" />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / EntityType>

  &NBSP; &NBSP; &NBSP; < / Schema>

  &NBSP; < / edmx：DataServices>

< / edmx：Edmx>



$


2. SSIS连接管理器（ODATA_TEST）。没有问题。我们可以成功测试它，或者在odata后端应用身份验证。以下是OData服务的日志。



5/14/19 10:49:33.000 PM [RTR] OUT    192.168.56.1 - - 到hxehost：51028" GET / catalog / HTTP / 1.1" 200发送152 in 9 010-045569cd-c7b2-4770-8475-f518001482c1





$ b 3 &NBSP;我们在SSIS OData源上有问题。



- 当选择创建的OData连接管理器时，它返回错误"无法加载连接ODATA_TEST的集合，原因：无法打开此连接"。 日志显示SSIS发送了元数据请求，odata服务返回
2305字节，状态成功200.与Postman或Web Browser中的信息相同。 



5/14/19 10：52：38.000 PM [RTR] OUT    192.168.56.1 - - 到hxehost：51028" GET / catalog / $ metadata HTTP / 1.1" 200送出2305 in 7 010-045569cd-c7b2-4770-8475-f518001482c1
$




$
- - 当选择"资源路径"时，它具有错误"检测到文档payloadkind时发生错误"。详细信息错误消息转到"Microsoft.SqlServer.ManagedDTS"。 odata日志显示它刚刚向/ catalog发送请求。



5/14/19 10:53:37,000 PM [RTR] OUT    192.168.56.1 - - 到hxehost：51028" GET / catalog / HTTP / 1.1" 200发送152 in 5由010-045569cd-c7b2-4770-8475-f518001482c1
$





谢谢提前任何信息。



Lester



Hi Experts,

I have a SSIS to SAP  HANA XSA OData v4 issue, which i have been struggling for a while. Looking for your valuable suggest.

1. We have no issue when using web browser or postman to the odata services (both v4 and v2). Details for v4:

--Collection URL: https://hxehost:51028/catalog/

OData Service Log: 

5/14/19 10:43:18.000 PM [RTR] OUT   192.168.56.1 - - to hxehost:51028 "GET /catalog/ HTTP/1.1" 200 sent 152 in 20 by 010-045569cd-c7b2-4770-8475-f518001482c1

Collection:

{
    "@odata.context": "$metadata",
    "@odata.metadataEtag": "W/\"l4Y9nfxmXiS3w2Lh6W7806U2/5vwswKjb0opSMPEy18=\"",
    "value": [
        {
            "name": "BookInfo",
            "url": "BookInfo"
        }
    ]
}



--Metadata URL: https://hxehost:51028/catalog/$metadata

OData Service Log: 

5/14/19 10:41:52.000 PM [RTR] OUT   192.168.56.1 - - to hxehost:51028 "GET /catalog/$metadata HTTP/1.1" 200 sent 2305 in 43 by 010-045569cd-c7b2-4770-8475-f518001482c1

Metadata:

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
    <edmx:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Core.V1.xml">
        <edmx:Include Alias="Core" Namespace="Org.OData.Core.V1"/>
    </edmx:Reference>
    <edmx:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Measures.V1.xml">
        <edmx:Include Alias="Measures" Namespace="Org.OData.Measures.V1"/>
    </edmx:Reference>
    <edmx:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Capabilities.V1.xml">
        <edmx:Include Alias="Capabilities" Namespace="Org.OData.Capabilities.V1"/>
    </edmx:Reference>
    <edmx:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Aggregation.V1.xml">
        <edmx:Include Alias="Aggregation" Namespace="Org.OData.Aggregation.V1"/>
    </edmx:Reference>
    <edmx:Reference Uri="https://wiki.scn.sap.com/wiki/download/attachments/462030211/Analytics.xml?api=v2">
        <edmx:Include Alias="Analytics" Namespace="com.sap.vocabularies.Analytics.v1"/>
    </edmx:Reference>
    <edmx:Reference Uri="https://wiki.scn.sap.com/wiki/download/attachments/448470974/Common.xml?api=v2">
        <edmx:Include Alias="Common" Namespace="com.sap.vocabularies.Common.v1"/>
    </edmx:Reference>
    <edmx:Reference Uri="https://wiki.scn.sap.com/wiki/download/attachments/448470971/Communication.xml?api=v2">
        <edmx:Include Alias="Communication" Namespace="com.sap.vocabularies.Communication.v1"/>
    </edmx:Reference>
    <edmx:Reference Uri="https://wiki.scn.sap.com/wiki/download/attachments/448470968/UI.xml?api=v2">
        <edmx:Include Alias="UI" Namespace="com.sap.vocabularies.UI.v1"/>
    </edmx:Reference>
    <edmx:DataServices>
        <Schema Namespace="CatalogService" xmlns="http://docs.oasis-open.org/odata/ns/edm">
            <EntityContainer Name="EntityContainer">
                <EntitySet Name="BookInfo" EntityType="CatalogService.BookInfo"/>
            </EntityContainer>
            <EntityType Name="BookInfo">
                <Key>
                    <PropertyRef Name="ID"/>
                </Key>
                <Property Name="ID" Type="Edm.Int32" Nullable="false"/>
                <Property Name="copiesSold" Type="Edm.Int32"/>
            </EntityType>
        </Schema>
    </edmx:DataServices>
</edmx:Edmx>



2. SSIS Connection Manager (ODATA_TEST). There is no issue. We can test it successfully, either apply authentication or not at the odata backend. Here is the log from OData services.

5/14/19 10:49:33.000 PM [RTR] OUT   192.168.56.1 - - to hxehost:51028 "GET /catalog/ HTTP/1.1" 200 sent 152 in 9 by 010-045569cd-c7b2-4770-8475-f518001482c1



3.  We have issue when it comes to SSIS OData source.

--When select the created OData Connection Manager, it returns error "Unable to load collection for the connection ODATA_TEST, reason: Cannot open this connection".  The log shows that SSIS sent metadata request , and the odata services returned 2305 bytes with successful status 200. Same info as in Postman or Web Browser. 

5/14/19 10:52:38.000 PM [RTR] OUT   192.168.56.1 - - to hxehost:51028 "GET /catalog/$metadata HTTP/1.1" 200 sent 2305 in 7 by 010-045569cd-c7b2-4770-8475-f518001482c1



--When select "Resource Path", it has error "An error occured when detect the document payloadkind". Detail error message go to "Microsoft.SqlServer.ManagedDTS). The odata log shows it just sent request to /catalog.

5/14/19 10:53:37.000 PM [RTR] OUT   192.168.56.1 - - to hxehost:51028 "GET /catalog/ HTTP/1.1" 200 sent 152 in 5 by 010-045569cd-c7b2-4770-8475-f518001482c1



Thanks in advance any information.

Lester


推荐答案

来自  Odata来源：支持的协议和数据格式：

似乎Odata Source不支持XML元数据。这会是原因吗？

It seems that Odata Source doesn't support the XML metadata. Will this be the cause?

您可以尝试第三方组件或
其他方式。 

You can try the third party components or other ways. 

相关主题：

SSIS - SAP Business ByDesign Odata Source


这篇关于SSIS与SAP OData v4的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

09-01 23:56
Powered by LMLPHP ©2024 attachments 0.039583