How does the getResource API behave when it is called for the SAP data source?
book
Article ID: KB0071787
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
8.3.0.010, 8.4.0.004, 8.5.0.002, 8.6 and lower
Description
1. Browse to /services/webservices/system/admin/resource/operations/getResource 2. Execute the API by modifying the parameters as below with a Non-SAP data source. (ds_inventory is used for reference) ------------------------------------------------------- <resource:getResource xmlns:resource="http://www.compositesw.com/services/system/admin/resource" xmlns:common="http://www.compositesw.com/services/system/util/common"> <resource:path>/shared/examples/ds_inventory</resource:path> <resource:type>DATA_SOURCE</resource:type> <resource:detail>SIMPLE</resource:detail> </resource:getResource> -------------------------------------------------------
Below is the response. The subtype can be seen marked as 'RELATIONAL_DATA_SOURCE' ------------------------------------------------------- <resource:getResourceResponse xmlns:resource="http://www.compositesw.com/services/system/admin/resource" xmlns:common="http://www.compositesw.com/services/system/util/common" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <resource:resources> <resource:resource xsi:type="resource:dataSourceResource"> <resource:name>ds_inventory</resource:name> <resource:path>/shared/examples/ds_inventory</resource:path> <resource:type>DATA_SOURCE</resource:type> <resource:subtype>RELATIONAL_DATA_SOURCE</resource:subtype> <resource:id>18192</resource:id> <resource:changeId>11012</resource:changeId> <resource:ownerDomain>composite</resource:ownerDomain> <resource:ownerName>admin</resource:ownerName> <resource:impactLevel>NONE</resource:impactLevel> <resource:enabled>true</resource:enabled> <resource:childCount>1</resource:childCount> <resource:dataSourceType>PostgreSQL 9.1</resource:dataSourceType> </resource:resource> </resource:resources> </resource:getResourceResponse> -------------------------------------------------------
3. Executed the same API for SAP data source: ------------------------------------------------------- <resource:getResource xmlns:resource="http://www.compositesw.com/services/system/admin/resource" xmlns:common="http://www.compositesw.com/services/system/util/common"> <resource:path>/shared/Cases/SAP BW/ds_sapBEx</resource:path> <resource:type>DATA_SOURCE</resource:type> <resource:detail>SIMPLE</resource:detail> </resource:getResource> -------------------------------------------------------
4. In the response you can see that the subtype is marked as 'NONE' ------------------------------------------------------- <resource:getResourceResponse xmlns:resource="http://www.compositesw.com/services/system/admin/resource" xmlns:common="http://www.compositesw.com/services/system/util/common" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <resource:resources> <resource:resource xsi:type="resource:dataSourceResource"> <resource:name>ds_sapBEx</resource:name> <resource:path>/shared/Cases/SAP BW/ds_sapBEx</resource:path> <resource:type>DATA_SOURCE</resource:type> <resource:subtype>NONE</resource:subtype> <resource:id>70413</resource:id> <resource:changeId>1227</resource:changeId> <resource:ownerDomain>composite</resource:ownerDomain> <resource:ownerName>admin</resource:ownerName> <resource:impactLevel>NONE</resource:impactLevel> <resource:enabled>true</resource:enabled> <resource:childCount>4</resource:childCount> <resource:dataSourceType>SAP BW BEx</resource:dataSourceType> </resource:resource> </resource:resources> </resource:getResourceResponse> -------------------------------------------------------
This may have an impact if you're using the subtype for other consecutive APIs to perform the data sources update. Now if the subtype is not received then all those consecutive operations might fail.
Issue/Introduction
This article explains the behavior of the getResource API when it is called with the SAP data source and other data sources as well.
Environment
All supported environments
Resolution
This behavior of getResource API with the SAP data source is by design. SAP BW/BEX does not fit into the other data source subtypes that are currently defined. Assignments of subtypes are subjective and not meant to be definitive.
NOTE: The issue has been fixed in TIBCO Data Virtualization 8.3.0.010, 8.4.0.004, 8.5.0.002, 8.6