Which data vendors and platforms does a small pharma commercial team actually use?

A small pharma commercial stack draws from six layers: syndicated prescription data (IQVIA, ICON/Symphony), specialty pharmacy and distributor feeds, Veeva CRM, a prescriber master such as Veeva Network, a Snowflake or Databricks warehouse, and Tableau or Power BI. Which feeds you buy depends on the brand. One rare-disease biotech ran 13 source systems with no IQVIA or claims.

Key points

  • One rare-disease biotech's commercial operation ran about 20 datasets across 13 source systems, including a specialty pharmacy sending four files a day, Veeva CRM, Veeva Network, Salesforce Marketing Cloud and Health Cloud, and NetSuite.
  • That same biotech ran its in-market brand with no claims data, no IQVIA or Symphony, and no formulary feed, because with a handful of patients per prescriber, patient status mattered more than a claims universe.
  • One launch evaluated IQVIA OneKey, Reltio, and Veeva Network to manage its physician list, and Beghou, ZS, and KMK for call planning and sales force design.
  • A launch team explored claims data from Komodo Health and Fingertip, and formulary and market-access data from MMIT, alongside IQVIA and Symphony Health, and added EDI 852, 844, and 867 data.
  • DataKitchen's commercial data platform runs the warehouse, typically Snowflake or Databricks, and the data quality tests in your cloud account, and leaves your BI tool where it is.

Every vendor below appears in published DataKitchen material because a real commercial platform used it or a real launch team evaluated it. We don’t score them. We don’t have their pricing either.

The map

LayerNames that appear in real platformsSource
Syndicated prescription and prescriber dataIQVIA (Xponent), ICON/Symphony HealthLaunch case study, the data most likely to be wrong
ClaimsKomodo Health and Fingertip, explored by one launch teamLaunch case study
Formulary and market accessMMIT, explored by the same launch teamLaunch case study
Specialty pharmacy and distributionThe specialty pharmacy network; 3PL; EDI 852, 844, and 867Launch case study, data sources
Patient servicesHub, copay, and REMS program dataData sources
CRM and fieldVeeva CRM; Veeva Vault for medical communicationsRare-disease biotech story
Marketing and patient engagementSalesforce Marketing Cloud and Health Cloud at the biotech; Constant Contact, HubSpot, and Salesforce Marketing Cloud weighed for CRM by one launch teamBiotech story, launch case study
Prescriber masterVeeva Network, IQVIA OneKey, ReltioLaunch case study, platform page
Call planning and sales force designBeghou, ZS, KMK, as contendersLaunch case study
Content and eventsHybrid Health, CVENT, as contendersLaunch case study
FinanceNetSuiteBiotech story
WarehouseSnowflake, Databricks; Redshift at CelgenePlatform page, Celgene launch
BI and AI on topTableau, Power BI; Snowflake Cortex Analyst, Databricks GeniePlatform page
Testing, orchestration, monitoringDataOps TestGen, DataOps Automation, DataOps ObservabilityPlatform page

The data sources reference breaks the feed layers into 37 named feeds and 10 identifiers, with how each one arrives and how it breaks.

What a small team actually buys

The list above is a union, not a shopping list. You will not need all of it.

The rare-disease biotech in our Cadillac and Corolla story had a commercial team of about five and about 20 datasets across 13 source systems. Its specialty pharmacy sent four files a day: patient status, dispense, inventory, and demographics. It reached prescribers through HCP websites, targeted display, and third-party medical email, not a field force. And it ran with no claims, no IQVIA or Symphony, and no formulary feed, because a handful of patients per prescriber made a claims universe less useful than knowing each patient’s status.

A launch team building for a broad brand did the opposite. It started with over a decade of claims data, then tried IQVIA and Symphony Health for NRx and TRx, explored Komodo Health and Fingertip for claims and MMIT for formulary and market access, and added sales force alignment, zip-to-territory mappings, and EDI data. That is in the launch case study, along with the systems it weighed for MDM, CRM, and call planning.

So buy by question. The launch timeline lists the 24 reports a launch analytics team owns and the data each one joins.

Where the platforms sit

On DataKitchen’s commercial data platform, the warehouse, the raw landing zone, the analyst-ready stars, TestGen, and the Git repository all live in your cloud account. DataOps Automation and Observability run in DataKitchen’s cloud and drive your environment without holding your data. Your BI tool, Veeva Network, and Jira and Confluence stay where they are.

That split is the one to settle first in a security review. It is also why a later handover is a normal day rather than a migration project.

Where the vendors meet

Every layer joins on a handful of identifiers: NPI, DEA, NDC, ICD, HCPCS, and each vendor’s own provider ID. Vendor provider IDs are stable within a vendor and meaningless across vendors, so the prescriber master has to link on several keys at once. Those joins are where the expensive errors live, because a malformed identifier does not error; it fails the join and the row disappears. See finding duplicate HCP records and why generic tools miss pharma identifiers.

Frequently asked questions

Short answers to the follow-up questions people ask next.

Does a small pharma need IQVIA or Symphony data?

It depends on the brand. One rare-disease biotech ran its in-market brand with no IQVIA or Symphony, no claims, and no formulary feed, because it had a handful of patients per prescriber and knowing where each enrolled patient stood mattered more. Its second indication takes the population into the thousands, so claims and physician-reference data were scoped for it.

What does a small pharma use for prescriber master data?

Usually an MDM product plus record linking. One launch evaluated IQVIA OneKey, Reltio, and Veeva Network to manage its physician list. Whichever you pick, treat it as one input. An analytic master that links NPI, ME, DEA, and vendor provider IDs also keeps the prescribers the MDM never matched, so they do not drop out of reports.

Which cloud warehouse do commercial pharma teams run on?

Snowflake and Databricks are the usual choices on DataKitchen's commercial platform, and the warehouse sits in your own cloud account. One launch team chose Snowflake and noted that Redshift, BigQuery, or Azure Synapse work as well. Celgene's commercial analytics platform ran on Redshift feeding Tableau Online, with more than 1,000 dashboards.

Do we have to change BI tools to use DataKitchen?

No. The platform changes what feeds your dashboards, not the BI layer your users already know. Tableau, Power BI, or whichever tool your analysts use stays in place, and Snowflake Cortex Analyst or Databricks Genie can sit on top of the context layer for plain-language questions.

How many source systems does a small commercial operation integrate?

More than the team size suggests. One rare-disease biotech with a commercial team of about five people integrated about 20 datasets across 13 source systems: specialty pharmacy, Veeva CRM, Veeva Network, Veeva Vault, Salesforce Marketing Cloud and Health Cloud, a logistics provider, a marketing agency's web analytics, and NetSuite for finance.

Talk to the people who test this data every week

DataKitchen builds and runs commercial data platforms for small and midsize pharma, with the tests in place from day one.