Datastores

Datastores are the objects that connect SAP Cloud Integration for data services to your cloud and on-premise applications and databases. Through these connections, SAP Cloud Integration for data services can access metadata from and read and write data to your applications and databases.

Within the Datastores tab, you can create and manage datastores, which connect SAP Cloud Integration for data services to your applications and databases.

From this tab, you can:

  • Create and delete datastores

  • Test the connection to a datastore

  • View and edit a datastore's configuration options (Configuration)

  • Browse a datastore's metadata objects (File Formats or Tables)

  • Import and manage file format or table metadata objects for a datastore

  • View data loaded to a table in a target datastore to ensure it is correct


    What are Datastores?
    Datastores are the objects that connect SAP Cloud Integration for data services to your cloud and on-premise applications and databases. Through these connections, SAP Cloud Integration for data services can access metadata from and read and write data to your applications and databases.
    Create Datastores
    Create a datastore for each application or database you want to connect to SAP Cloud Integration for data services.
    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.
    Import Metadata Objects
    Importing metadata objects adds the table and file names from your source and target databases and applications to your datastores.
    View Data in a Datastore
    After a task or process finishes running, you can view the data in its target datastore to ensure that the results are as you expected.
    Create or Copy Datastore Configurations
    A datastore configuration represents a set of configurable options (including connection name, user name and password) and their values.
    Create System Configurations
    A system configuration is a set of datastore configurations that are used by a task or process during execution to connect to source and target datastores.
    Find Where an Object is Used
    A datastore cannot be deleted if its associated contents are in use. Find where an object is used by viewing its dependencies.
    Enable Secure Network Communications (SNC) in BW
    Enable SNC to provide a secure connection between SAP BW and the remote function call (RFC) server for jobs that you launch from SAP BW.
Related Information