Migrating a legacy database to a cloud-based solution for Bayer Pharmaceuticals

Client

Bayer Pharmaceuticals—a German multinational pharmaceutical and biotechnology company

ikony-life-science-icon_case study

Industry

Life science

Business goal

Improving and standardizing the sales reporting process across the organization by migrating a legacy database to a cloud-based solution

What our client says

Working with Fabrity has been a positive experience. Fabrity’s team has shown clear commitment to our project, with a consistently responsive approach to any requests or issues we encountered. Their willingness to share knowledge has greatly supported our internal understanding, and their proactive approach—often anticipating needs and offering thoughtful solutions—has been highly valuable.

We can recommend Fabrity as a trusted partner for building complexes data engineering solutions for enterprise clients.

Rafał Leszczyński

Customer Excellence & Analytics Manager

How we helped

  • Analyzed an existing MS SQL system to understand its architecture, data, and related business requirements.
  • Designed the database structure in Snowflake considering the architecture differences between MS SQL and Snowflake.
  • Created the database schema in Snowflake and defined the structure of tables, views, stored procedures, etc.
  • Identified and migrated SQL queries and stored procedures to the new Snowflake environment.
  • Established the migration process in consultation with the client’s global team to ensure all data was correctly imported into the new SnowFlake and Tableau PREP environment.
  • Verified and cleaned the data prior to migration to ensure its consistency and integrity.
  • Imported data into Snowflake and performed its validation to ensure all data had been migrated correctly.
  • Adapted the visualization solution (Tableau) to the new data source (Snowflake).
  • Ran functional tests and optimized the performance of the new Snowflake database.

Business outcome

  • Streamlined sales reporting across the organization.
  • Ensured access to the global data warehouse for all branches of the organization.
  • Achieved reliability and availability by migrating the entire infrastructure to the cloud and simplifying a complex import mechanism.
  • Simplified the configuration of the new database, allowing for quick importing of data from new sources.
  • Enabled flexibility with a new database structure that is straightforward and secure enough for further expansion.

Technology stack

Interested to see how a similar project might look in your company?

Contact us to see how we can help.

Book a free 15-minute discovery call

Looking for support with your IT project?
Let’s talk to see how we can help.

The controller of the personal data is FABRITY sp. z o. o. with its registered office in Warsaw; the data is processed for the purpose of marketing Fabrity’s products or services; the legal basis for processing is the controller's legitimate interest. Individuals whose data is processed have the following rights: access to data, rectification, erasure or restriction, right to object and the right to lodge a complaint with PUODO. Personal data in this form will be processed according to our privacy policy.

You can also send us an email.

In this case the controller of the personal data will be FABRITY sp. z o. o. and the data will be processed for the purpose of marketing Fabrity’s products or services; the legal basis for processing is the controller’s legitimate interest. Personal data will be processed according to our privacy policy.

Interested to see how a similar project might look in your company?
Contact us at sales@fabrity.pl to see how we can help.

Book a free 15-minute discovery call

Looking for support with your IT project?

Let’s talk to see how we can help.

The controller of the personal data is FABRITY sp. z o. o. with its registered office in Warsaw; the data is processed for the purpose of responding to a submitted inquiry; the legal basis for processing is the controller's legitimate interest in responding to a submitted inquiry and not leaving messages unanswered. Individuals whose data is processed have the following rights: access to data, rectification, erasure or restriction, right to object and the right to lodge a complaint with PUODO. Personal data in this form will be processed according to our privacy policy.

You can also send us an email.

In this case the controller of the personal data will be FABRITY sp. z o. o. and the data will be processed for the purpose of responding to a submitted inquiry; the legal basis for processing is the controller’s legitimate interest in responding to a submitted inquiry and not leaving messages unanswered. Personal data will be processed according to our privacy policy.

dormakaba 400
frontex 400
pepsico 400
bayer-logo-2
kisspng-carrefour-online-marketing-business-hypermarket-carrefour-5b3302807dc0f9.6236099615300696325151
ABB_logo