readWebLogicDataSources
- Karl Henselin
Reads Weblogic Data Sources from domain configurations and writes them into properties files. A separate properties file will be created for each Data Source.
These Properties files can be checked into source control and/or used as input to the CreateOrUpdateDataSources operation. It helps to automate the initial setup process for Data Sources by reducing the manual effort required to create the Property Files with the extracted datasource properties.
Blog Posts
Target Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle Weblogic Home (WL_HOME) |
| Yes | WebLogic Home Directory. (e.g. /u01/oracle/products/fmw/wlserver) |
Weblogic Domain Name |
| Yes | WebLogic Domain Name. |
Weblogic Admin Listen Address |
| Yes | The listener address of the WLS admin server. (e.g. localhost) |
Weblogic Admin Listen Port |
| Yes | The port of the WLS admin server. (e.g. 7001) |
Weblogic Admin SSL Connection |
| No | Indicates whether the admin server is using SSL. |
Weblogic Admin User |
| Yes | The username for the WLS admin server. |
Weblogic Admin Password |
| Yes | The password for |
Weblogic Admin Domain Directory |
| No | Weblogic Domain Directory for AdminServer. If not provided, |
Weblogic Domain Directory |
| Yes | Weblogic Domain Directory.(e.g. |
Inputs
Input Name | Input Code | Required | Description |
|---|---|---|---|
File Path to Write Properties |
| No | Directory to store the Data Source properties files. If relative paths are given, paths inside of the FD_TEMP_DIR will be assumed. If it is left empty, the files will be created in the FD_TEMP_DIR. |
WebLogic Partition Name |
| No | Â Partition Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x. |
WebLogic ResourceGroup Name |
| No | Â ResourceGroup Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x. |
WebLogic ResourceGroup Template |
| No | Â ResourceGroup Template Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x. |
Artifacts
This operation Produces properties-file artifacts.
Endpoint Selection
This operation will select all available endpoints associated to the Target which have a resource type of WLS Admin Server. Since the admin server only runs on one server, it is expected that for a given domain, there will only be one endpoint with a resource type set to WLS Admin Server
Endpoint Execution
This operation will execute on the Admin Server endpoint selected using the WLS Admin Server resource type.
Special Considerations
If File Path to Write Properties is not specified, the FD_TEMP_DIR folder will be used. If a relative path is specified, the path will be relative to the FD_TEMP_DIR directory.
Example Folder Structure
Properties File Naming
Properties files are named by the pattern <DSName>.properties, removing all spaces in the name. See Example Properties File below.
SOADataSources.properties – This is the properties file. The path to write and store the file is referenced by theFile Path to Write Propertiesinput.
Example Property File
The sample file defines simple data source with a sub-set of the available Required properties.
Backslash in Properties file
If you want \ (backslash) in any property value, use \\ or \u005c. This is Java properties file load syntax.
DSList=DS1
#DataSource Properties
#Thu Jun 13 10:00:52 CDT 2018
DS1.DataSourceType=Generic
DS1.URL=jdbc:oracle:thin:@localhost:1521:xe
DS1.ConnectionClass=oracle.jdbc.OracleDriver
DS1.DSName=DS1
DS1.User=${{FLX_DB_USER_FDADMIN}}
DS1.Targets=MS1
DS1.JNDINames=jdbc/DS1
DS1.Password=${{FLX_DB_PASSWORD_FDADMIN}}
DS1.MinCapacity=0For more details on the types of Data Sources and their list of optional/required Properties, please refer the following link createOrUpdateDataSources Operation
- style