Siebel Data Warehouse Installation and Administration Guide > Siebel Data Warehouse for Life Sciences Data Considerations >

Importing Syndicated Data into Siebel Data Warehouse

This section covers how to import syndicated data into the Siebel Life Sciences database.

Pharmaceutical companies purchase weekly and monthly sales and prescription data, known as syndicated data, from third-party vendors such IMS, NDC, and Cegedim. Syndicated data is read-only data about certain measures that is used for sales force analysis reporting and customer targeting. After it is delivered, this syndicated data must be loaded into the Siebel Pharma Analytics database in a timely fashion and made available to users in order for them to make use of sales force analysis reporting.

The options for loading syndicated data into the Siebel Data Warehouse include the following:

• Loading from the Siebel transactional database (OLTP) S_SYND_DATA table.

  Syndicated data can be loaded from the S_SYND_DATA table into the Siebel Data Warehouse. Existing syndicated data from the Siebel transactional database, stored in the S_SYND_DATA table, is extracted, transformed, and loaded by prebuilt routines and populated into the W_SYND_DATA_F and W_SYND_MKT_F fact tables in the Siebel Data Warehouse. These tables provide information to the Rx Sales subject areas and prebuilt Rx Sales dashboards. (For more information, see the section on Importing, Extracting, and Routing Syndicated Data in Siebel Life Sciences Guide.)

  Siebel Pharma Analytics supports multiple data types and period types. Therefore, in order to correctly use the ETL process, S_SYND_DATA must be loaded in a special way to make sure support for all data types and correct population of the Siebel Data Warehouse (see Siebel Analytics Data Loading Matrix for Syndicated Data).

• Loading from a flat file source using syndicated data staging tables.

  Syndicated data source files can be loaded directly into Siebel Data Warehouse staging tables. In the staging tables, Siebel foreign keys are matched with external sources keys for joining the external source keys with Siebel Analytics keys.

  The Data Loading Matrix (Siebel Analytics Data Loading Matrix for Syndicated Data) illustrates the correct loading of S_SYND_DATA data into the Siebel Data Warehouse. The following data types are supported:

  Monthly Rx data by Contact

  Monthly indirect sales data by Brick

  Monthly indirect sales by Account

  Monthly indirect sales by ZIP Code

  Monthly direct sales by Account

  Monthly direct sales by Brick

  Monthly direct sales by ZIP Code

  Weekly Rx data by Contact

  Monthly plan level Rx Data

  Monthly sales market—incentives by ZIP Code

  Monthly sales market—modified by ZIP Code

  Monthly plan level physician Rx Data

  Monthly Rx data by ZIP Code

  Monthly Rx data by Brick

To make sure the data is correctly loaded in the Siebel Data Warehouse, the Siebel source table, S_SYND_DATA needs to be populated correctly, based on Table 62 and Table 63.