Data Sources Page

The Data Sources page enables you to manage your data sources.

The Data Sources page allows you to create different types of data sources. Only administrator users can manage data sources. The RDF store can be linked to an Oracle AI Database or to an external RDF data provider. For Oracle data sources, there are three types of connections:

• JDBC data source defined with database parameters

• JDBC data source defined on an application server

• Oracle wallet connection defined in a zip file

These database connections must be available in order to link the RDF web application to the data source.

To create a data source, click Data Sources, then Create.

Figure: Data Sources Page

Description of the illustration data_sources_page.png

• Creating a JDBC URL Data Source

• Creating an Oracle Container Data Source

• Creating an Oracle Wallet Data Source

• Creating an Endpoint URL Data Source

Creating a JDBC URL Data Source

Oracle JDBC URL is defined using the standard database parameters with user credentials.

You can perform the following steps to create a JDBC URL data source:

1. Click JDBC URL in Figure: Data Sources Page.

   Create JDBC URL Data source dialog opens as shown:

   Figure: Creating a JDBC URL Data Source

   

   Description of the illustration jdbc_url_ds.png

2. Enter the Name of the data source.

3. Optionally, enter Description.

4. Select the JDBC Type.

5. Enter SID/Service Name as appropriate.

6. Enter the Host and Port details.

7. Enter the User and Password credentials.

8. Click OK to create the data source.

Creating an Oracle Container Data Source

As a prerequisite to create a container data source in the RDF Graph Server and Query UI application, the JDBC data source must exist in the application server. See Creating a JDBC Data Source in WebLogic Server and Creating a JDBC Data Source in Tomcat for more information.

You can then perform the following steps to create an Oracle Container data source:

1. Click Container in Figure: Data Sources Page.

   Create Container Data source dialog opens as shown:

   Figure: Create Container Data Source

   

   Description of the illustration create_data_source_container.png

2. Enter the Name of the data source.

3. Optionally, enter Description.

4. Select the JNDI Name that exists on the application server.

5. Click OK to create the data source.

• Creating a JDBC Data Source in WebLogic Server

• Creating a JDBC Data Source in Tomcat

Creating a JDBC Data Source in WebLogic Server

To create a JDBC data source in WebLogic Server:

1. Start WebLogic Remote Console and connect to your WebLogic Server instance using your administrative credentials.

2. Expand Edit Tree -> Services -> Data Sources.

3. Click New to create a JDBC data source.

   Figure: Generic Data Source

   

   Description of the illustration oracle_container_generic_data_source.png

4. Enter the JDBC data source information (name and JNDI name), server target, Oracle Database Generic Data Source type, and Oracle Thin XA Driver.

   Figure: JDBC Data Source and JNDI

   

   Description of the illustration oracle_container_jndi.png

5. Enter the database connection information: service name, host, port, and user credentials.

   Figure: Create JDBC Data Source

   

   Description of the illustration oracle_container_jdbc_data_source.png

6. Click Create to continue.

7. Click the Test Configuration button to validate the connection.

   Figure: Validate connection

   

   Description of the illustration oracle_container_test_configuration.png

8. Click the shopping cart and choose Commit Changes.

   Figure: Commit Changes

   

   Description of the illustration wls_jdbc_commit_changes.png

The JDBC data gets added to the data source table and the JNDI name is added to the combo box list in the create container dialog.

Creating a JDBC Data Source in Tomcat

There are different ways to create a JDBC data source in Tomcat. See Tomcat documentaion for more details.

The following examples denote creation of JDBC data source in Tomcat by modifying the configuration files conf/server.xml and conf/content.xml.

• Add global JNDI resources on conf/server.xml.

  <GlobalNamingResources>
      <Resource name="jdbc/RDFUSER19c" auth="Container" global="jdbc/RDFUSER19c"
                type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
                url="jdbc:oracle:thin:@host.name:db_port_number:db_sid"
                username="rdfuser" password="<password_for_rdfuser>" maxTotal="20" maxIdle="10"
                maxWaitMillis="-1"/>
   </GlobalNamingResources>

• Add the resource link to global JNDI’s on conf/context.xml:

  <Context>
      <ResourceLink name="jdbc/RDFUSER19c"
                    global="jdbc/RDFUSER19c"
                    auth="Container"
                    type="javax.sql.DataSource" />
  </Context>

Creating an Oracle Wallet Data Source

To create a wallet data source in the Query UI application, you must have a wallet zip file. It can be a simple wallet zip file created with Oracle orapki utility, or a wallet downloaded from Oracle Autonomous AI Database.

In general, wallets are obtained from the Autonomous AI Database. See Download Client Credentials (Wallets) for more information to download a wallet from Oracle Autonomous AI Database.

The following figure displays the contents of the wallet zip file:

Figure: Cloud Wallet

Description of the illustration cloud_wallet_dir.png

Note that the tnsnames.ora file in the wallet zip file contains the wallet service alias names, and TCPS information. It does not contain the user credentials for each service.

Using this wallet zip file, you can define an RDF wallet data source in the Query UI web application by directly entering the user credentials. Optionally, you can also have the user credentials stored inside the wallet for each desired service. If you choose to store the user credentials in the wallet, then see Storing User Credentials in a Wallet for more information.

The following describes the steps to create a wallet data source:

1. Click Wallet in Figure: Data Sources Page.

   Create Wallet Data source dialog opens as shown:

   Figure: Wallet Data Source from cloud zip

   

   Description of the illustration wallet_data_source_cloud.png

2. Click the upload icon and select the wallet zip file.

   The zip file gets uploaded to the server.

3. Enter the data source Name.

4. Optionally, enter the Description.

5. Select the required Wallet Service name.

6. Provide the user credentials using one of the following options as it applies to you.

   • Enable Use wallet credentials if you have stored the user credentials in the wallet.

   • Otherwise, enter directly the User and Password credentials.

7. Optionally, enter the proxy details.

• Storing User Credentials in a Wallet

Storing User Credentials in a Wallet

The following steps describe the process for adding the credentials to the wallet zip file. It is important that you store this wallet file along with the credentials in a safe location for security reasons.

1. Unzip the cloud wallet zip file in a temporary directory.

2. Use the service name alias in the tnsnames.ora to store credentials by running the following command:

   For example, if the service name alias is db202002041627_medium:

   ${ORACLE_HOME}/bin/orapki secretstore create_credential -wallet /tmp/cloudwallet
   
              -connect_string db202002041627_medium -username username -password password

3. Zip the cloud wallet files into a new zip file.

Creating an Endpoint URL Data Source

External data sources are connected to the RDF data store using the endpoint URL.

You can execute SPARQL queries and updates to the RDF data store using a base URL. In some cases, there are specific URLs based on the dataset name. For example:

DBpedia Base URL: http://dbpedia.org/sparql

The RDF web application issues SPARQL queries to RDF datasets. These datasets can be retrieved from provider if a get capabilities request is available. For DBpedia, there is a single base URL to be used, and therefore a default single dataset is handled in application.

You can perform the following steps to create an external RDF data source:

1. Click Endpoint in Figure: Data Sources Page.

   Create Endpoint URL Datasource dialog opens as shown. The following figure shows an example for creating a Dbpedia data source.

   Figure: DBpedia Data Source

   

   Description of the illustration endpoint_datasource.png

2. Enter the Name of the data source.

3. Optionally, enter Description.

4. Optionally, enter the Provider name.

5. Enter the Base URL to access the RDF service.

6. Optionally, enter the Query URL to run SPARQL queries.

   Note that if the Query URL is not defined, then the Base URL is used.

7. Optionally, enter the Update URL to run SPARQL updates.

   Note that if the Update URL is not defined, then the Base URL is used.

8. Provide the Capabilities Datasets parameter properties to retrieve the dataset information from the RDF server.

9. Enter the Get URL address that should return a JSON response with information about the dataset.

10. Enter the Datasets parameter property in JSON response that contains the dataset information.

11. Enter the Dataset name parameter property in datasets parameter that contains the dataset name.

12. Click OK to create the data source.