Datastore Types and Their Properties

Each type of SAP Cloud Integration for data services datastore has options that you configure depending on the underlying data source to which you are connecting.


    DB2
    Create a DB2 datastore to connect to a DB2 database.
    File Format Group
    Create a File Format Group datastore to connect to a flat file.
    File Location
    A file location object defines the location and transfer protocol for remote file objects.
    Google BigQuery
    SAP Cloud Integration for data services supports using a Google BigQuery connection with an ODBC driver.
    HANA [Neo environment only]
    Create a HANA datastore to connect to a HANA database.
    Microsoft SQL Server
    Create a Microsoft SQL Server datastore to connect to a Microsoft SQL Server database.
    MySQL
    Create a MySQL datastore to connect to a MySQL database.
    OData Adapter
    An OData Adapter datastore can extract and load data using two types of authentication.
    ODBC Data Sources
    To work with ODBC data sources, drivers need to be configured on the Agent side.
    Oracle
    Create an Oracle datastore to connect to an Oracle database.
    REST Web Service
    Create a REST Web Service datastore to connect to a REST Web Service.
    SAP Business Suite Applications
    Create an SAP Business Suite Application datastore to connect to an SAP Business Suite Application.
    SAP BW Source
    Create an SAP BW Source datastore to connect to an SAP BW Source database.
    SAP BW Target
    Create an SAP BW Target datastore to connect to an SAP BW Target database.
    SAP Cloud Platform (SCP) HANA [Neo environment only]
    Create an SAP HANA application cloud datastore of application type HANA to connect to SAP Cloud Platform (SCP) HANA.
    SAP Datasphere
    You can create an SAP Datasphere datastore to connect to an SAP Datasphere service.
    SAP HANA Database
    Create an SAP HANA Database datastore to connect to an SAP HANA database.
    SAP Integrated Business Planning
    Create an SAP HANA application cloud datastore of application type Integrated Business Planning to connect to SAP Integrated Business Planning.
    SAP Integrated Business Planning via WebSocket RFC
    To connect to an SAP IBP instance via WebSocket RFC, create an SAP Cloud Integration for data services datastore with the following options/parameters.
    SAP Lumira Cloud [Neo environment only]
    Support for SAP Lumira Cloud datastores connecting to an SAP Lumira Cloud database has been deprecated.
    SOAP Web Service
    Create a SOAP Web Service datastore to connect to a SOAP-based web service.
    SuccessFactors Adapter
    A SuccessFactors Adapter datastore can extract and load data to and from SuccessFactors using two types of authentication.
    Sybase ASE
    Create a Sybase ASE datastore to connect to a Sybase ASE database.
    Sybase IQ
    Create a Sybase IQ datastore to connect to a Sybase IQ database.
    Teradata
    Create a Teradata datastore to connect to a Teradata database.

Parent topic: Datastores
Related Information