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

Sep 18, 2020

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

Webinar recording: Speed-up patient recruitment by the means of automated site payments

On the first day of June we’ve hosted a joint webinar with our client, Confidence Pharmaceutical Research.

Learn more
Streamline learning management of any scale with Flex Databases LMS

Streamlining the learning management process of thousands sounds like a nightmare but worry not – we’ve got you covered.

Learn more
5 examples of data sets that are shared between Flex Databases CTMS & eTMF

Flex Databases CTMS & eTMF are interconnected to deliver you the highest possible level of data completion and avoid missing documents issues.

Learn more
Move from a legacy system to Flex Databases in 6 simple steps

Here at Flex Databases we offer you a simple six-step approach to move all data from your legacy system to Flex, and we need your involvement only for three of those six.

Learn more

Have we picked your interest?

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.