Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse >

Importing Syndicated Data Into the 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. Once delivered, this syndicated data must be loaded into the Siebel ePharma 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 operational application 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 application OLTP 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 ePharma 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 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 (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 10 and Table 11.

Bookshelf Home | Contents | Index | Search | PDF