FAQ

March 31, 2023
12:00 PM (UTC)
10 Minutes Read

What databases does Pharmquer support?

Pharmquer supports Postgresql (recommended), SQL Server, Oracle, and MySQL (deprecated), and is cloud-ready for Snowflake and GCP. It will soon support SpackSQL, Hive, Impala, Greenplum, and cloud-ready for AWS and Azure. We recommend that you contact us for evaluation by a specialist.

How long does it usually take to implement Pharmquer?

The implementation, verification, personnel training, and technology transfer of the Pharmquer tool takes about 2 months. If you have any needs for back-end OLAP report system development or integration, please contact us, and a specialist will assist you in evaluation.

Can Pharmquer be integrated with existing reporting systems?

Yes, Pharmquer is designed for this purpose and is particularly suitable for integration with your existing data warehouse.

Is Pharmquer secure?

Pharmquer is established in your enterprise’s private cloud and does not have any problems with external network connection theft. In addition, Pharmquer has complete user permission design, complies with FDA CFR 21 Part 11, fully retains all data access records, and prohibits data deletion and modification.

What is included in the training and technical support?

• User training:

  • Using Pharmquer for data management workflow

  • Data operation: using Pharmquer for report merging, aggregation, and pivot analysis

  • Visual data: how to choose charts reasonably and complete report and dashboard production, publication, and management

  • Data analysis methods and statistical training

  • (Optional) Factory data management methods

  • (Optional) Monitoring base station life cycle in reverse through data analysis

  • (Optional) Deeply mining data value through Pharmquer to improve yield and reduce manufacturing costs.

• IT training & support:

  • How to build Pharmquer front-end and back-end

  • Complete configuration technology transfer

  • How to update, how to manage versions

  • Troubleshooting and backend log problem queries

  • Issue reporting and tracking process details

  • Participate in the open source community (what are the benefits to you? Complete production and process details)

  • (Optional) How to integrate with existing data warehouses?

  • (Optional) How to conduct secondary development?

  • (Optional) Python/Go/Vue training

  • (Optional) Configure HA high availability

  • (Optional) Configure load balancer

  • (Optional) Airflow data flow automation management platform training

My company only has MIS personnel, is it suitable to introduce Pharmquer?

We provide outsourcing and hosting services, please contact us.