To create an Oracle data source in Wyn Enterprise, follow these steps.
Note: The supported version is Oracle 10g and higher (the Oracle Client installation is required). For Oracle 11g or higher, the Oracle Client installation is not required.
On the Resource Portal, navigate to Create (+) > Create Data Source.
Select Oracle in the data source list on the left or in the icon view on the right.
Fill in the database configuration information for the selected data source.
USER ID=myUserId; Password=myPassword; Data Source="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= myOracleDBHost)(PORT=myOracleDBPort))(CONNECT_DATA=(SERVICE_NAME=myOracleDBServiceName)));
* Required fields
Verify the Oracle connection by clicking Test Connection. If the data source is available, and the credentials are correct, you receive a notification on successful connection.
Click Create after the connection is successful.
You can view the added data source in the Categories tab of the Resource Portal.
Note: If Wyn Enterprise is installed in a Linux system and needs to connect to the Oracle data source in the Windows system, you must first set the time zone in the Linux system to the same time zone as the Oracle data source and restart the Wyn Enterprise system.