ReadWebLogicDataSources

@Since 4.6.0.2

Read the WebLogic Data Sources from the domain configurations and write them into properties files. For each Data Source, there will be a separate Property file to store their properties.

These Properties files can be used as an input to execute the CreateOrUpdateDataSources operation as part of initial setup process. It helps to automate the initial setup process for Data Sources by reducing the current manual efforts in creating the Property Files with the extracted DS properties.

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 a directory is given, it will be searched.

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 ,whereas removing all spaces in the DS name if found. 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