Configuring Data Sources to Point to Real-Time Integration Business Insight Schema

After provisioning an Integration Analytics Cluster service type instance, you must configure the SOA/Service Bus data sources for instances you want to monitor with Oracle Real-Time Integration Business Insight.

1. Collect required information about the Oracle Real-Time Integration Business Insight schema:
   1. Open the WebLogic Server Administration Console for your Integration Analytics instance.
   2. Expand Services, and then click Data Sources.
      
      
      Description of the illustration GUID-D564AFB8-C0AE-492C-A20F-9CE9B81C9C62-default.png
      
   3. Click BamDataSource, and then click the Connection Pool tab.
   4. From Properties, copy the user prefix and paste into a text editor. The prefix should look similar to this example: SP812918608_
      
      
      Description of the illustration GUID-955C818D-1937-4366-BC77-654F7A30974C-default.png
      
   5. Copy the value of the URL field and paste into a text editor. The value should look similar to this example: jdbc:oracle:thin:@192.168.0.1:1521/PDB1.oraclecloud.example
2. To configure the SOA/Service Bus datasources:
   1. Open the WebLogic Server Administration Console for your SOA/Service Bus instance.
   2. Expand Services, and then click Data Sources.
   3. Click BamDataSource, and then click the Connection Pool tab.
   4. Click Lock & Edit to start a new edit session.
   5. From Properties, replace the user prefix with the Oracle Real-Time Integration Business Insight user prefix you copied in Step 1d.
      
      
      Description of the illustration GUID-A7701F79-8FFD-4B1C-AC23-40BE94F667FB-default.png
      
   6. Replace the contents of the URL field with the value you copied in Step 1e, and then click Save.
   7. Click Data Sources.
   8. Click BamNonJTADataSource, and then click the Connection Pool tab.
   9. From Properties, replace the user prefix with the Oracle Real-Time Integration Business Insight user prefix you copied in Step 1d.
   10. Replace the contents of the URL field with the value you copied in Step 1e, and then click Save.
   11. Click Data Sources.
   12. Click mds-bam, and then click the Connection Pool tab.
   13. From Properties, replace the user prefix with the Oracle Real-Time Integration Business Insight user prefix you copied in Step 1d.

       Note:

       The schema suffix for the mds-bam data source is _MDS, not _SOAINFRA like the other data sources mentioned in this task. Ensure you don’t change the suffix.

       
       Description of the illustration GUID-18F55BD1-368E-4EFB-87C8-6970DDED1551-default.png
   14. Replace the contents of the URL field with the value you copied in Step 1e, and then click Save.
   15. Click Activate Changes to activate the session.
3. Restart the SOA/Service Bus managed server. See Stopping, Starting, and Restarting Managed Server and Load Balancer VMs.