The v1.3.1 patch for the TIBCO Scribe Online Connector for Oracle Database added a number of new features and bug fixes (release notes), however, it also changed the underlying Oracle Database provider.

Due to the performance changes, we have chosen to lock existing TIBCO Scribe Organizations in the previous version for 90 days.  This 90-day window gives you time to test the latest patch (if you choose to) and refine your Solutions for improved performance if needed.

All Organizations will receive the latest patch on April 22nd, 2020. 

Actions you need to take

If you choose to test the latest patch, please use one of the following options:

1. Use an existing production test Organization by opening a support ticket and providing your Organization Name and Number: (https://support.tibco.com/s/). Once applied, review the test cases (below).

2. Using the TIBCO Scribe Sandbox environment, log in/create an account to test: (https://app-sandbox.scribesoft.com). Navigate to Marketplace > Oracle Database > Install to install the Connector. Review the test cases (below).

Note: When you are ready to apply the update to your production Organization, please open a ticket and request the latest patch be applied by providing your Organization Name and Number: (https://support.tibco.com/s/).

Best Practice Test Cases

We suggest these test cases for proper testing of Oracle Database connector patch:

1. Connection Properties - Recreate/Test your connection with the exact same connection properties and Agent/Agent location. Ensure the connection test is successful. 

2. Table and Field Metadata - Import existing Maps and reassign to your new Oracle Database connection. Ensure there are no validation errors in your Maps. 

3. Update or Delete Block performance - Import existing Maps that regularly use Update Blocks on executions greater than 1,000 records. Ensure performance is satisfactory, otherwise, ensure best-practices are implemented (see below). 

Performance Best-Practice Articles

• https://community.tibco.com/wiki/performance-options-connect-capability-tibco-cloud-integration 

• https://support.tibco.com/s/article/Scribe-Online-Agent-Performance