Database Integration

0
I am working on a dashboard where data exists in the database but is not showing in Mendix.Exploring Database Connector and Database Replication — is Replication real-time?Will Database Connector work better for real-time graphs?
asked
1 answers
3

Hi Panraj, Good question! Here's a clear and concise explanation to help you decide between Database Connector and Database Replication for your dashboard with real-time data needs

 

Database Replication Module

  • Not real-time, it's designed for batch data import (manual or scheduled).

  • Useful for syncing external databases with Mendix (e.g., initial loads or periodic syncs).

  • Data is copied into Mendix DB, not queried live.

  • Not suitable for real-time dashboards.

 

Database Connector Module

  • Executes live SQL queries on an external database (read/write).

  • Can fetch up-to-date data at runtime (e.g., for real-time graphs).

  • Data is not stored in Mendix unless you explicitly import it.

Best choice for real-time dashboards, if you need to show live data from an external source.

 

Recommendation

  • Your data is already in the Mendix database but not showing, check access rules, data associations, or security settings first.

  • You need live external data → Use Database Connector.

  • You only need to sync data occasionally → Use Database Replication.

I hope this one helps you! :)

 

 

 

answered