Bookshelf Home | Contents | Index | PDF |
Siebel Data Warehouse Installation and Administration Guide > Siebel Data Warehouse for Life Sciences Data Considerations > Importing Syndicated Data into Siebel Data WarehouseThis 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:
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. |
Siebel Data Warehouse Installation and Administration Guide |