A.22.1 How to Create Data Store

Data store is metadata around the source connection details. Users can register Oracle/Hive data source connection details as data store with Compliance Studio. Data store is added to the workspace to point to a particular source connection to fetch the data.

To create a data store, follow these steps:
  1. Navigate to Workspace Summary page.
  2. Click the User Profile drop-down list and select Data Store.
  3. Click Add Data Store. The Add Data Store page is displayed.

    Figure A-11 Add Data Store with Oracle Database



  4. Enter the required details as describe in the following table.

    Table A-15 Add Data Store

    Field Description
    Data Store Name Enter the connection URL to the database for the data schema.
    Description Enter the description of database connection.
    Type From the Type drop-down list, select the JDBC
    Database Type From the Database Type drop-down list, select the Oracle.
    Wallet Alias Enter the Wallet Alias. This value should be same as configured using Oracle Wallet.
    Table Owner Enter the Oracle Database schema name.
  5. Click Create to create/add a new data store for the sandbox workspace.