Skip Headers
Oracle® Life Sciences Data Hub Adapter Toolkit Guide
Release 2.4
E54091-01
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
1/14
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Intended Audience
Documentation Accessibility
Finding Information and Patches on My Oracle Support
Finding Oracle Documentation
Related Documents
Conventions
1
About Adapters
About Adapters
Adapter Components
Components and the User Interface
2
Designing an Adapter
Preparation
Requirements for Load Set, Data Mart, Program, and Business Area Adapters
Load Set Adapter Requirements
Definition
Installation
Execution
Data Mart Adapter Requirements
Definition
Installation
Execution
Program Adapter Requirements
Definition
Installation
Execution
Business Area Adapter Requirements
Definition
Installation
Launching the Visualization Tool
Planning Adapter Areas
Planning Technology Types
Planning Services
Planning PL/SQL Functions and Procedures
Object Definition Functions and Procedures
Column_Upload_Function
Auto_Add_Tab_Desc_Function
Auto_Add_Tab_Desc_LOV
Define_Time_Function
Status_Recalc_Function
Object Installation Functions
Pre_Install_Function
Install_Function
Post_Install_Function
Object Execution Functions and Procedures
Build_IDE_Cfg_Function
Build_Exe_Cfg_Function
Pre_Execution_Function
Execution_Function
Post_Execution_Function
Currency_Function
Security_Recalc_Function
Planning Parameters and Parameter Sets
General Define-Time Parameters
Table Descriptor Define-Time Parameters
Runtime Parameters
Adding Lookup Values
Planning Planned Outputs
Planning Data Structures
Planning for Object Execution
Execution Process
Execution Command
Planning Security
Planning Integrated Development Environment Adapters
IDE Launch Process from Within Oracle Life Sciences Data Hub
Synchronizing Security with Integrated Environments
Enforcing Security on Corresponding External Entities
Establishing Context
Tracking and Removing Object Access
Adding Source Code Types
Planning Navigation in the External System to Business Areas
Editing cdrconfig.xml
Creating Subdirectories on IDE Computers
3
Developing an Adapter
Adapter Development Process
Planning Programs and Packages
Using the Security API Package During Development
4
Using APIs to Create Required Metadata Objects
Retrieving IDs
Getting Your Company ID
Getting an Object's Prref_Id and Prref_Ver
Creating a Technology Type
Call the Create Technology Type API
Sample Technology Type Settings
Modifying a Technology Type
Creating an Adapter Domain
Call the Create Adapter Domain API
Save the Adapter Domain ID for Future Use
Modifying an Adapter Domain
Creating an Adapter Area
Call the Create Adapter Area API
Save the Adapter Area ID for Future Use
Sample Adapter Settings
Modifying an Adapter Area
Assigning a User Group to the Adapter Area
User Interface Method
API Method
Creating a Work Area
Call the Create Work Area API
Save the Work Area ID for Future Use
Creating a Program Definition and Instance
Query for the Tech Type ID
Call the Create Program API
Save the Program Definition and Instance IDs for Future Use
Creating a Source Code Definition and Instance
Call the Create Source Code API
Creating a Variable
Call the Create Variable API
Save the Variable ID for Future Use
Check in the Variable
Creating a Parameter
Call the Create Parameter API
Save the Parameter ID for Future Use
Check in the Parameter
Creating a Parameter Set
Call the Create Parameter Set API
Save the Parameter Set ID for Future Use
Creating a Parameter Instance in a Parameter Set
Call the Create Parameter API
Creating a Table Definition
Call the Create Table API
Call the Create Column API
Installing the Work Area
5
Using the Generic Visualization Adapter
Generic Visualization Adapter APIs
Initializing the Business Area Instance
Resetting a Generic Visualization Business Area
Getting Possible Blinding Types of a Business Area Instance
Getting Snapshot Labels Common to All Tables in a BA Instance for a Given Blinding Access Type
Generic Visualization Adapter Views
Display User's Business Area Instances
Retrieve Table Instance Details
Generic Visualization Business Area Instance Attributes
Schema Name
Default Currency
Default Blinding Access Type
Generic Visualization Adapter Security
Database and User Accounts
Object Security
Data Blinding and Currency
Auditing
Generic Visualization Adapter Definitional Components
6
Checking In Objects and Setting Their Validation Status
Running the Validation API
Explicitly Checking In an Object
7
Setting Up an Adapter
Defining a Service Location, Service, and Service Instance
Defining Remote Locations and Connections
Assigning User Groups to the Adapter Area
Installing and Starting the Distributed Processing Server
Edit cdrconfig.xml
8
Shipping an Adapter