Getting Started with Oracle Data Service Integrator Administration
Before you start working with Oracle Data Service Integrator development environment, you need to deploy your dataspace project on an Oracle WebLogic domain enabled for Oracle Data Service Integrator. Using Oracle WebLogic Server 10gR3, you can create users and groups for Oracle Data Service Integrator and manage their permissions.
Most of the other administrations tasks for Oracle Data Service Integrator can be performed through the Oracle Data Service Integrator Administration Console and therefore you may not need to launch the WebLogic Server Administration Console frequently. Table 2-1 lists the tasks that you can perform using Oracle Data Service Integrator Administration Console and the ones that you need to perform using Oracle WebLogic Server Administration Console.
Table 2-1 Administration Tasks for Oracle Data Service Integrator Administration Console and Oracle WebLogic Server Administration Console
To start working with the Oracle Data Service Integrator development environment and to administer the WLS enabled for Oracle Data Service Integrator, you must first start WebLogic Server. Although you may not need to stop WebLogic Server frequently, it may be required in certain situations. This section describes how to start and stop WebLogic Server in a standalone WebLogic domain, after you have configured your Oracle WebLogic Server 10gR3.
If you are already running an instance of WebLogic Server that uses the same listener port as the one to be used by the server you are starting, you must stop the first server before starting the second server.
Starting the Server
At the command prompt, navigate to the domain directory.
The domain directory is <BEA_HOME>/user_projects/domain_name. An example could be c:\bea\user_projects\domains\mydomain.
Run the server startup script: startWebLogic.cmd (Windows) or startWebLogic.sh (UNIX).
The startup script displays a series of messages, finally displaying a message similar to the following:
<Dec 8, 2004 3:50:42 PM PDT> <Notice> <WebLogicServer> <000360> <Server started in RUNNING mode>
You can also start Oracle WebLogic Server through the Eclipse-based IDE for Oracle Data Service Integrator. To start the server:
Open the IDE and click the Servers tab.
Right-click the server that you have configured and select Start, as shown in Figure 2-1. If you want run the server in debug-mode then select Debug. This starts WebLogic Server.
Figure 2-1 Oracle Data Service Integrator IDE: Starting Oracle WebLogic Server
Stopping the Server
To stop the WebLogic Server using the eclipse-based IDE, right-click the server listed in the Servers tab, as shown in Figure 2-1 and select Stop.
Alternatively, you can stop a WebLogic Server instance that is running a dataspace project from the WebLogic Server Administration Console.
Start the Oracle WebLogic Server Administration Console.
Acquire the lock by clicking Lock & Edit.
In the left pane, click to expand Environment and select Servers.
Select the server instance you need to stop.
Click the Control tab. The Start/Stop tab is displayed, as illustrated in Figure 2-2.
Figure 2-2 Graceful Shutdown of a Server
Specify the graceful shutdown timeout limit incase you need to do a force shutdown after some time.
From Server Status table, click the Shutdown list.
Select the When work completes option.
Select Yes to confirm shutdown. This shuts down the selected server after all the pending tasks are completed.
Launching Oracle Data Service Integrator Administration Console
The Oracle Data Service Integrator Administration Console is a web-based interface that enables you to administer and manage dataspace projects, access metadata, and configure security and caching policies.
Before you launch the Oracle Data Service Integrator Administration Console, make sure that the WebLogic Server is started. For more information about starting WebLogic Server, see
Starting the Server on page 2-3. To launch Oracle Data Service Integrator Administration Console:
Open the following URL:
hostname is the machine name or IP address of the host server
port is the address of the port on which the host server is listening for requests (7001 by default)
For example, to start the Oracle Data Service Integrator Administration Console on a local instance of WebLogic Server (running on your computer), navigate to the following URL:
In case you need to launch the WebLogic Server Administration Console, click the WLS Console link on the top-right corner of Oracle Data Service Integrator Administration Console, as shown in Figure 2-3.
Figure 2-3 WLS Console Link in Oracle Data Service Integrator Administration Console
For more information about starting the Oracle WebLogic Server Administration Console, refer to Starting the Administration Console section in Introduction to Oracle WebLogic Servers.
You can use the navigation pane to view the navigation tree and all the data services, functions, and web services. The change center allows you lock and edit the configuration settings within the console and then save or discard changes depending on your requirement. Using the category-based tabs from the category list, you can view and manage the artifacts related to each tab, including the system administration tasks such as deployment of data services, importing and exporting data service JAR files, and auditing.You can also view metadata, manage caching, and configure security settings using the category-list.
Figure 2-4 displays the components of the navigation pane.
Figure 2-4 Navigation Pane
This section describes the functions of some of the components of the navigation pane in detail.
Change Center and Configuration Locking
The change center feature in Oracle Data Service Integrator Administration Console is similar to the WebLogic Server Administration Console. It enables you to acquire a global lock over the console configuration, make one or more changes to the configuration, if required, and then activate or discard the changes. The configuration settings are edited in a transactional manner, therefore, only one user can acquire the lock to the console.
To acquire the lock and then activate or discard changes:
Click Lock & Edit option from the change center. This enables you to make changes to the workspace.
Save the changes in the Workspace Content Area by clicking Save. The message “Settings updated successfully” is displayed in the workspace content area.
From the change center area, click Activate Changes or Undo All Changes, as shown in Figure 2-5, to activate or discard the changes. If you click Activate Changes, then the message “Changes activated successfully“ is displayed in the workspace content area and if you select Undo All Changes, then the “Changes discarded successfully” message is displayed.
The change center feature is available only to the domain and admin entitlements for a resource configured for security in Oracle Data Service Integrator. Other Oracle Data Service Integrator entitlements cannot use the change center. For more information about user entitlements, refer to the Administrative Access Control section in
Chapter 5, “Securing Oracle Data Service Integrator Resources.”
You do not need to acquire a lock to edit the configuration within the administration console in the following cases:
To create and delete dataspaces, you do not need to explicitly acquire a lock because the system acquires the lock by default. For more information about creating and deleting dataspaces, refer to
Chapter 3, “Deploying Dataspaces.”
Security policies, in both runtime security and administrative access control categories, do not require the change center lock. The policies are stored in a separate repository, in WLS configuration, and therefore do not take part in the Oracle Data Service Integrator configuration session. For more information, refer to
Chapter 5, “Securing Oracle Data Service Integrator Resources.”
Based on the operations performed using the change center, the change center behavior may differ. Table 2-2 lists and describes the change center behavior in different situations:
Table 2-2 Change Center Behavior
User does not have domain or admin entitlements for any of the Oracle Data Service Integrator resources such as a dataspace or data service.
User is denied access and the change center is disabled.
Lock has not been acquired by any one and can be acquired by the logged in user.
The user can acquire the lock to the change center and perform configuration changes.
Lock has been acquired by the logged in user and changes are made.
The change center provides the option to activate or discard changes. So, the Activate Changes and Undo All Changes options appear in the change center area.
Lock has been acquired by some other user but the logged in user being a domain user is allowed to forcibly acquire the lock.
The change center displays the Take Lock && Edit option if the user has domain entitlements for the dataspace.
The pending change list displays the difference between the current session values and the core values. The dataspace artifacts that are created, updated, or deleted are displayed in the pending changelist. Pending changes are shown in the tree view, as shown in Figure 2-6, whereas the configuration changes are shown in the leaf node.
Figure 2-6 Pending Changelist
Navigation Tree and Category List
There are six categories in the Oracle Data Service Integrator Administration Console. The artifacts displayed in the workspace content area for a data service, function, or web service depend on the category-based tab that you select from the category list.
The following list describes the function of each category tab:
System Administration: This is the default tab that is displayed when you log into Oracle Data Service Integrator Administration Console. It provides functionality to set the state and the target server for deployment, importing and exporting of project JAR files, checking the administrative properties, and auditing.
Physical Sources: This tab provides details about the different physical data sources that are deployed on the server. The physical data sources can include delimited files, java functions, relational databases, web services, and XML files.
Operations: This tab allows you monitor the active queries, data cache size, and active updates for a dataspace.
The workspace content area displays artifacts based on the tab selected in the category list and the node selected from the navigation tree. It consists of various options that enable you to view, search, configure, and audit Oracle Data Service Integrator resources. Figure 2-7 displays the workspace content area that is displayed when you log in to the console.
Figure 2-7 Workspace Content Area
As illustrated in this figure, the workspace content area constitutes the following:
Banner Toolbar: It shows the user name and the server that you are logged into. The links on the right, allow you to log into the WebLogic Server Administration Console, logout of Oracle Data Service Integrator Administration Console, along with help options.
Breadcrumb Trail: It displays the current category and the resource that you select from the navigation tree. You can access the category or resource using the trail links also.
Search: This field is you to search metadata. When you click Search, the system starts a search across all artifacts on the server and displays the results in a search result page. If you click Search without entering any value in the field, the Advanced Search page is displayed. For more information, refer to
“Searching Metadata” on page 7-15.
Page Title: This displays the current artifact that you access on the Oracle Data Service Integrator Administration Console.
Inline Help: This help is available on each page of the console and provides guidance about using the options on the console.
Workspace Content: This area displays information about the resource depending on the category you select from the category-list.