Service Types that Use the DP Server

Processing engines integrated with Oracle Life Sciences Data Hub use the DP Server.

You can control the number of service locations and services for service types that use the DP Server. Service locations correspond to physical locations, and each one can have any number of services defined. Each service can have any number of service instances defined. For more details, see Service Instances.

For each technology you plan to use, define at least one service of the following service types:

  • Oracle Export. Oracle LSH uses Oracle Export services for creating Oracle Export-type Data Marts.
  • Oracle Reports. Oracle LSH uses these services to execute Oracle Reports Programs.
  • SAS. Oracle LSH uses SAS services to execute SAS Load Sets, SAS Programs, and SAS Data Marts on a SAS server.
  • Text for SQLLoader. Oracle LSH uses Oracle SQL Loader to execute Text Load Sets.
  • Workflow. Oracle LSH uses Workflow services to execute user-defined and internal Workflows.
  • XML Publisher. Oracle LSH uses XML Publisher services to generate PDF-format Report Sets.
  • XML Reports. Oracle LSH uses these services to produce predefined reports and the coversheets for reports and report sets.
  • Zip Utility. Oracle LSH uses Zip Utility services to produce zipped Text and SAS Data Marts. You can zip the text files if you want to.
  • Unzip Utility. Oracle LSH uses Unzip Utility services to unzip uploaded zip files while creating Tables and Text Load Sets.
  • OBIEE Business Area Install Service. This service is required to support running visualizations through the OBIEE Presentation Server, and using the OBIEE Admin Tool. For more details, see Setting Up Oracle Business Intelligence Visualizations
  • OBIEE Business Area Deploy Service. This service is required to support running visualizations through the OBIEE Presentation Server. For more details, see Setting Up Oracle Business Intelligence Visualizations.

  • BI Publisher. Oracle LSH uses this service to execute BI Publisher Programs.

Note:

The following service types are inactive: Oracle Warehouse Builder and SQL*Plus. Do not define services of these types.