API or not-API: integration capabilities of Flex Databases system

Sep 18, 2020
API or not-API: integration capabilities of Flex Databases system -2

Even though Flex Databases system allows our clients to cover all software needs within one platform, there are cases when the company needs to integrate existing providers with the new ones. We understand the need entirely, and that is why we offer several ways to integrate with basically any system or solution that supports integration.

Tech basics

  • The system is developed based on C# and Net Framework, Dexpress, DevExtreme. It consists of several applications on platform ASP.NET WebForms. Database is Firebird SQL
  • Given that the system is developed and supported by Flex Databases, there are no limitations in terms of integrations, and we fully manage the process


Starting the 2020 system baseline version, we have our API for integration.

  • Subject Tracking & Invoicing module data import

User story example:  As a customer X, I want to automate payments to sites based on information from EDC. I need to Flex Databases to integrate with my EDC provider to upload patient visits data to CTMS so that we can avoid double data entry.

Here is what it might look like:

  • Data export from any part of the system you need

User story example: As a customer X with BI service in use, I want to export monitoring visits data from CTMS to my external solution so that I can process this data and represent the analytics

Here’s an example of data export to Power BI tool made through Flex Databases API:

EDC integration 

Depending on the EDC systems used by Client, we provide integration options using all listed services – REST, WCF/ (EDC provider’s API), Message Queues, FTP/File Extracts. Our experience is based on integration with the following EDC systems: OpenClinica, DATATRAK, MedNet EDC, Medidata RAVE, InForm, IBM eClinical OS.

From a technical point of view, we have two options to integrate EDC and Subject tracking and invoicing:

1) Automated way using the SFTP shared location

The basic flow is the following:

  • EDC provider places the subjects and visits listings automatically to SFTP share (a schedule may vary as needed)
  • FDB ST&I will pick up those listings and import to the database automatically
  • the subjects and visits will appear in the ST&I

Preconditions for the EDC vendor: to set up the automated data extracting to the SFTP share in the preliminarily agreed format
Preconditions for the FDB: to set up all necessary settings for recognizing the incoming files at the backend side

2) Automated way using the API, described above

Other systems integrations

We have experience of integration with non-clinical systems as well, including financial systems and BI systems, such as Salesforce, MS Dynamics, Navision, QuickBooks, Fairsail, Power BI. Before selecting the type of integration, we perform a detailed analysis of the Clients’ requirements and third-party system capabilities. Further on, we choose the type of integration together with our Client.

Live integration

There are 2 live integration options available:

  • We pull information from another system every minute – every minute data update in Flex Databases System (or 5 minutes or any other time period as per client’s need)
  • Events driven integration (e.g., adding new record), a new event in another system triggers our system to pull data – instant data update in Flex Databases System

What is the integration process?

  • Understanding another system’s capabilities, e.g., do they have API, any documentation, if not, what type of connector would they prefer.
  • Analyzing the data received during the previous step, decide on the method, connector
  • Dialog with another system provider on connector and authorization of access
  • Preparing Specifications
  • Developing integration on a test environment with appropriate documentation
  • Validation and production approval, UAT on client’s side
  • Go live

Want to become one of our clients? Send us an e-mail to bd@flexdatabases.com or request a demo through the form on top of the page

More about our product

AI validation for life sciences – a unique challenge of dynamic nature

What aspects need validation to ensure confidence in AI-driven processes, and is it possible to achieve 100% certainty?

Learn more
how we implenented eTMF
How we implemented eTMF & developed SOPs in 3 weeks for iRenix

And here’s the twist – while iRenix was laser-focused on their operations and study start-up processes, we rolled up our sleeves to deliver a full-on, turn-key eTMF setup from scratch.

Learn more
TMF Quality Review 2.0
TMF Quality Review 2.0 

Periodic TMF reviews automatically documented. Quality and completeness under control!

Learn more
Archiving eTMF for 25 years
Archiving eTMF for 25 years? Secure, accessible, and compliant with Flex Databases 

Flex Databases offers a solution for all your archiving needs.

Learn more

Get in touch to discuss compliance, implementation, demos, pricing

We are here for all of your questions! Tell us more about yourself and we will organize a tailored live demo to show how you can power up your clinical trials processes with Flex Databases.