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.
See the Product Availability Matrix for information about supported versions.
| 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. |
| 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. |
| 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. |
| 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
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
