Oracle® Business Activity Monitoring Architect User's Guide 10g (10.1.3.1.0) Part Number B28992-01 |
|
|
View PDF |
This chapter contain the information needed to create and manage External Data Sources.
This chapter contains the following topics:
An external data source is a connection to an external database. External data sources usually contain data that does not change very much or data that is too large to bring into the Active Data Cache.
External data source configurations can be exported and imported using ICommand, but you cannot import or edit the contents using ICommand, Enterprise Link, or Architect.Passwords are entered in clear text. You cannot use DSNs (data source names).
To view the existing external data sources:
Select External Data Sources from the Architect function list.
To define an external data source:
Select External Data Sources from the Architect function list.
Click Create.
Enter a name and a description for the external data source.
Enter Driver, for example, Microsoft ODBC for Oracle.
Enter database user credentials in the Login and Password fields.
Enter Connection string/URL.
For a complete example of defining an External Data Source against an Oracle database, see "External Data Source Example".
To edit an external data source:
Select External Data Sources from the Architect function list.
Select the external data source to edit.
The external data source properties display.
Select Edit.
Make the changes and click Save.
To delete an external data source:
Select External Data Sources from the Architect function list.
Select the external data source to delete.
The data source properties display.
Select Delete.
Click OK to confirm that you want to delete the data source.
The data source is deleted.
This example uses the sample scott/tiger user account and the EMP table in the Oracle database. You may need to unlock the scott/tiger account before proceeding with this example.
Step 1: Create an External Data Source
Select External Data Sources from the Architect function list.
Click Create.
Enter myDataSource
in the External Data Source Name field.
Enter My Example External Data Source
in the Description field.
Enter Microsoft ODBC for Oracle
in the Driver field.
Enter scott
in the Login field and tiger in the Password field.
This sample account comes with your Oracle database installation. If you do not have this sample account you can create a new account and use it for this example.
Enter server=
net_service_name
in the Connection string/URL.
This entry needs to be a Net Service Name defined in your tnsnames.ora file.
Click Save.
Click Continue.
The External Data Source information is displayed on the screen.
Step 2: Create a Data Object using the External Data Source
Select Data Objects from the Architect function list.
Click Create Data Object.
Enter Employees
in the Name for new Data Object field.
Leave the slash (/) in the Location for new Data Object field.
The data object will appear in the top level Data Objects folder.
Leave the Tip text field blank.
Enter Oracle Database Sample EMP Table
in the Description field.
Select the External Data Source checkbox.
Select myDataSource from the External Data Source list.
Enter emp
in the External Table Name field.
Add the following fields to the data object:
Field | External Field Name | Field Type |
---|---|---|
ename | ename | String |
empno | empno | Integer |
job | job | String |
mgr | mgr | Integer |
hiredate | hiredate | DateTime |
sal | sal | Decimal |
comm | comm | Decimal |
deptno | deptno | Integer |
Keep default settings for field attributes not specified in the table.
Click Create Data Object.
Click Continue.
Click Contents to view the contents of the data object
The data in the Employees data object should match the data in the Oracle database sample EMP table.