ReadWebLogicDataSources

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

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_PARTITIONNo Partition Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x.
WebLogic ResourceGroup Name FDWLS_INP_RESOURCEGROUPNo ResourceGroup Name to retrieve the associated Data Sources. Provide input only if WebLogic Server version is 12.2x.
WebLogic ResourceGroup Template  FDWLS_INP_RESOURCEGROUP_TEMPLATENo 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