How to integrate SQL server data in mendix

1
Hello, My question is I have complete creating my app through mendix but, the problem is am not able to connect mendix to sql server. I have tried sql server configuration in mendix to connect to sql server but it is not showing me the data.   I want sql server data to be displayed in mendix if I run the mendix app. Also, i have tried database connector but unable to do it. Please suggest if you have any idea regarding this.   Thankyou!!!!
asked
2 answers
1

Hi Niharika,

 

you need this module: https://marketplace.mendix.com/link/component/2888

and follow this documentation: https://docs.mendix.com/appstore/connectors/database-connector/

 

especially the Prerequisites:

The JDBC driver libraries (.jar extension) for the databases you want to connect to must be placed inside the userlib directory of your Mendix application

  • For example, if you want to connect to Amazon RDS PostgreSQL database (jdbc:postgresql://xyz-rds-instance.ccnapcvoeosh.eu-west-1.rds.amazonaws.com:5432/postgres), you need to place the PostgreSQL JDBC driver .jar inside the userlib folder

 

 

If the JDBC driver you are looking for is not listed here : https://docs.mendix.com/appstore/connectors/database-connector/#links

 

If you intend to connect to SQL Server using integrated security, please be aware that the JDBC driver in the userlib folder needs to match the version supplied with the Mendix Platform (via the runtime/bundles/ folder inside the Mendix installation directory).

 

answered
0

Hello Niharika,

 

https://medium.com/mendix/my-journey-with-db-connector-in-mendix-postgresql-8d76dd2e2a05 

This may help you.

answered