Create a Data Source for an ATP Database
Use the model Yaml templates to create a data source for an Oracle Autonomous Database.
Following is an example of model Yaml template for app deployment with ATP datasource properties:
Note:
The template files are located at/u01/shared/scripts/pipeline/templates
on the administration host.
resources:
JDBCSystemResource:
hellods:
Target: '@@ENV:RESOURCE_PREFIX@@-cluster'
JdbcResource:
JDBCDataSourceParams:
JNDIName:
JDBCDriverParams:
DriverName: oracle.jdbc.OracleDriver
URL: '@@SECRET:@@ENV:DOMAIN_UID@@-datasource-secret:url@@'
PasswordEncrypted: '@@SECRET:@@ENV:DOMAIN_UID@@-datasource-secret:password@@'
Properties:
user:
Value:
javax.net.ssl.keyStore:
Value:
javax.net.ssl.keyStoreType:
Value: JKS
javax.net.ssl.keyStorePassword:
Value: '@@SECRET:@@ENV:DOMAIN_UID@@-keystore-secret:password@@'
javax.net.ssl.trustStore:
Value:
javax.net.ssl.trustStoreType:
Value: JKS
javax.net.ssl.trustStorePassword:
Value: '@@SECRET:@@ENV:DOMAIN_UID@@-keystore-secret:password@@'
oracle.net.ssl_version:
Value: '1.2'
oracle.net.ssl_server_dn_match:
Value: true
oracle.net.tns_admin:
Value:
oracle.jdbc.fanEnabled:
Value: false
JDBCConnectionPoolParams:
InitialCapacity: 1
MaxCapacity: 1
TestTableName: SQL ISVALID
TestConnectionsOnReserve: true
You must set up the database to create a schema user before you create the data source. See Prerequisites to Create a Data Source.
When you create a data source for an ATP database, you need the ATP client credentials or wallet files. So, you must run the download script before you create the data source. See Download the ATP Wallet.
To create a data source for an ATP database: