SAP Commissions – ⚙️Smart Data Integration[SDI] – Part 6

[yogananda]

Dear All,

This article is intended for database admins, consultants, customers & partners to know the basics & understanding of available Standard Adapters and Custom Adapter details for your SDI Project Implementation.

Configure your own Data Provisioning Adapters

Data provisioning adapters can connect to a variety of sources to move data into SAP HANA, and well as other use cases.

---

Also keep watching What's new where regular new updates keeps rolling in ...

What's New in SAP HANA Smart Data Integration and SAP HANA Smart Data Quality

---

See the Product Availability Matrix for information about supported versions.

The adapters in the following table are delivered with the Data Provisioning Agent.

Adapter Name Description

ABAPAdapter	Retrieves data from virtual tables through RFC for ABAP tables and ODP extractors. It also provides change data capture for ODP extractors.
AgentMgmtAdapter	Allows SAP HANA to access and execute Data Provisioning Agent functions.
ASELTLAdapter	Retrieves data from SAP ASE. It can also receive changes that occur to tables in real time. You can also write back to a virtual table. The ASELTLAdapter uses LTL technology exclusively.
ASELTLECCAdapter	Retrieves data from an SAP ERP system running on SAP ASE. The ASELTLECCAdapter uses LTL technology exclusively. The only difference between this adapter and the ASELTLAdapter is that this adapter uses the data dictionary in the SAP ERP system when browsing metadata.
BWAdapter	This adapter is available for use only with SAP Agile Data Preparation. Note This adapter is deprecated and will be removed in a future release.
CamelAccessAdapter	Retrieves data from a Microsoft Access source. The Camel Access adapter is a predelivered component that is based on the Apache Camel adapter.
CamelFacebookAdapter	The Camel Facebook adapter is a predelivered component that is based on the Apache Camel adapter. Use the Camel Facebook component to connect to and retrieve data from Facebook.
CamelInformixAdapter	Retrieves data from an Informix source. It can also write back to an Informix virtual table. The Camel Informix adapter is a predelivered component that is based on the Camel adapter.
CamelJdbcAdapter	The Camel JDBC adapter is a predelivered component that is based on the Apache Camel adapter. Use the Camel JDBC adapter to connect to most databases for which SAP HANA smart data integration doesn’t already provide a predelivered adapter. In general, the Camel JDBC adapter supports any database that has SQL-based data types and functions, and a JDBC driver.
CassandraAdapter	Retrieves data from an Apache Cassandra remote source. You can also write to an Apache Cassandra target.
CloudDataIntegrationAdapter	Use the Cloud Data Integration adapter to retrieve data from a Cloud Data Integration (CDI) service endpoint.
DataAssuranceAdapter	Use the Data Assurance adapter to connect to an SAP HANA remote source to use the Data Assurance option to monitor the quality of data replication.
DB2ECCAdapter	Retrieves data from an SAP ERP system running on IBM DB2. It can also receive changes that occur to tables in real time. The only difference between this adapter and the DB2LogReaderAdapter is that this adapter uses the data dictionary in the SAP ERP system when browsing metadata.
DB2LogReaderAdapter	Retrieves data from IBM DB2. It can also receive changes that occur to tables in real time. You can also write back to a virtual table.
DB2LTLMainframeAdapter	Similar to the SDIDB2MainframeLogreaderAdapter, this adapter provides real-time replication functionality for DB2 for z/OS sources. This adapter uses LTL technology exclusively.
DB2MainframeLogreaderAdapter	Retrieves data from IBM DB2 for z/OS. IBM DB2 iSeries, formerly known as AS/400, is also supported. Note The DB2MainframeLogreaderAdapter is deprecated and will be removed in a future release. To connect to ASE remote sources, see the DB2LTLMainframeAdapter, which uses Logging Transferring Language (LTL) exclusively.
ExcelAdapter	Retrieves data from Microsoft Excel. You can also access SharePoint source data.
FileAdapter	Retrieves data from formatted text files. You can also write back to a virtual table. You can also access SharePoint source data, as well as write to an HDFS target file.
FileAdapterDatastore SFTPAdapterDatastore	File datastore adapters use the SAP Data Services engine as the underlying technology to read from a wide variety of sources.
HanaAdapter	This adapter provides real-time changed-data capture capability in order to replicate data from a remote SAP HANA database to a target SAP HANA database. You can also write back to a virtual table. Use this adapter to extract data from an ECC on an SAP HANA source.
HiveAdapter	Retrieves data from HADOOP.
ImpalaAdapter	Retrieves data from an Apache Impala source. The Apache Impala adapter is a predelivered component that is based on the Apache Camel adapter.
MssqlECCAdapter	Retrieves data from an SAP ERP system running on Microsoft SQL Server. It can also receive changes that occur to tables in real time. The only difference between this adapter and the MssqlLogReaderAdapter is that this adapter uses the data dictionary in the SAP ERP system when browsing metadata.
MssqlLogReaderAdapter	Retrieves data from Microsoft SQL Server. It can also receive changes that occur to tables in real time, be it through log reading or triggers. You can also write back to a virtual table.
ODataAdapter	Retrieves data from an OData service. You can also write to an OData target.
OracleECCAdapter	Retrieves data from an SAP ERP system running on Oracle. It can also receive changes that occur to tables in real time. The only difference between this adapter and the OracleLogReaderAdapter is that this adapter uses the data dictionary in the SAP ERP system when browsing metadata.
OracleLogReaderAdapter	Retrieves data from Oracle. It can also receive changes that occur to tables in real time, be it through log reading or triggers. You can also write back to a virtual table.
OutlookAdapter	Retrieves data from Microsoft Outlook.
PostgreSQLLogReaderAdapter	Use this adapter to batch-load or replicate change data in real time from a PostgreSQL database to SAP HANA.
SDIDB2MainframeLogReaderAdapter	This adapter provides real-time replication functionality for DB2 for z/OS sources. Note This adapter is referred to in the documentation as “SDI DB2 Mainframe” adapter. Also, this adapter is similar to the “DB2 Mainframe” adapter, in name and functionality. The main difference between this adapter and the “DB2 Mainframe” adapter is that the “SDI DB2 Mainframe” adapter supports real-time replication.
SoapAdapter	This adapter is a SOAP web services client that can talk to a web service using the HTTP protocol to download the data. The SOAP adapter uses virtual functions instead of virtual tables to expose server-side operations as it closely relates to how the operation is invoked.
TeradataAdapter	Retrieves data from Teradata. It can also receive changes that occur to tables in real time. You can also write back to a virtual table.
TwitterAdapter	Retrieves data from Twitter. It can also receive new data from Twitter in real time.

Custom Adapters from Partner Developed

Visit : https://www.advantco.com/sap-hana-sdi-integration-adapters

Develop your own Custom Adapters

Use the Adapter SDK to create your own custom adapters.

The adapters described in the help document that come installed with the Data Provisioning Agent were created using the Adapter SDK.

You can use the Adapter SDK to create your own custom adapters to connect to virtually any source. An administrator then registers the custom adapter on the appropriate agent.

---

Data Provisioning Adapter SDK Guide

Visit the Link

References

---

Part 1 – SAP Commissions – Smart Data Integration[SDI] – Part 1

Part 2 – SAP Commissions – Smart Data Integration[SDI] – Part 2

Part 3 – SAP Commissions – Smart Data Integration[SDI] – Part 3

Part 4 – SAP Commissions – Smart Data Integration[SDI] – Part 4

Part 5 – SAP Commissions – Smart Data Integration[SDI] – Part 5