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

https://flexagon.com/2018/06/read-all-your-weblogic-data-sources-in-a-click/

Environment/Instance Properties

Property Name	Property Code	Required	Description
Oracle Weblogic Home (WL_HOME)	`FDWLS_WEBLOGIC_HOME`	Yes	WebLogic Home Directory. (e.g. /u01/oracle/products/fmw/wlserver)
Weblogic Domain Name	`FDWLS_DOMAIN_NAME`	Yes	WebLogic Domain Name.
Weblogic Admin Listen Address	`FDWLS_ADMIN_LISTEN_ADDRESS`	Yes	The listener address of the WLS admin server. (e.g. localhost)
Weblogic Admin Listen Port	`FDWLS_ADMIN_LISTEN_PORT`	Yes	The port of the WLS admin server. (e.g. 7001)
Weblogic Admin SSL Connection	`FDWLS_ADMIN_USE_SSL`	No	Indicates whether the admin server is using SSL.
Weblogic Admin User	`FDWLS_ADMIN_USER`	Yes	The user name for the WLS admin server.
Weblogic Admin Password	`FDWLS_ADMIN_PASSWORD`	Yes	The password for `Weblogic Admin User`.
Weblogic Admin Domain Directory	`FDWLS_ADMIN_DOMAIN_DIRECTORY`	No	Weblogic Domain Directory for AdminServer. If not provided, `Weblogic Domain Directory` will be used.
Weblogic Domain Directory	`FDWLS_DOMAIN_DIRECTORY`	Yes	Weblogic Domain Directory.(e.g. `/u01/oracle/config/domains/soa_domain`)

Project Properties

Property Name	Property Code	Required	Description

Inputs

Property Name	Property Code	Required	Description
File Path to Write Properties	`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	FDWLS_INP_PARTITION	No	Partition Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x.
WebLogic ResourceGroup Name	FDWLS_INP_RESOURCEGROUP	No	ResourceGroup Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x.
WebLogic ResourceGroup Template	FDWLS_INP_RESOURCEGROUP_TEMPLATE	No	ResourceGroup Template Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x.

Outputs

Output Name	Required	Description

Artifacts

This operation Produces properties-file artifacts.

Endpoint Selection

This operation will select all available endpoints associated to the Environment/Instance 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 file 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 the File Path to Write Properties input.

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=0

For more details on the types of Data Sources and their list of optional/required Properties, please refer the following link createOrUpdateDataSources Operation

ReadWebLogicDataSources