The Database connector can be used to seamlessly connect to external databases without limiting you in your choice of database or SQL dialect, enabling you to incorporate your external data directly in your Mendix application.
Connectors5 stars, based on 16 votes
5/5starsVery nice app.It is too good.
5/5starsI am using DatabaseConnector to retrieve data and stored data from mysql table.It is very useful app
5/5starsHi, I have downloaded and added the module, but I cant see the database connector in the toolbox. There is only the module. I'm using Modeler 7.5. I have followed the documentation for installation, but nothing appears in the toolbox. Thanks
Wouter van Dee
5/5starsHandy module to extract data from remote databases.
5/5starsA great way to connect to databases.
5/5starsSat with a Business User(with functional structure knowledge of the DB) along with a SQL Colleague who can describe the query while I use this module to trigger it in the matter of minutes.
5/5starsI am unable to connect to database.Anyone can help
Arthur van der Molen
3/5starsI installed the module and after some trial and error I have it working on localhost. I want to use it in the staging/[production environment so that will next step...
With a query I get the data returned in an object list which must exactly match the database. I would prefer only a list of Strings with comma-separated values or (better) an JSON object. I will mark this on github too.
But sofar experiences are ok.
5/5starsVery useful for data migration.
5/5starsGreat tool which extends communication channels from Mendix apps.
5/5starsUsed it to connect to APS database, worked great
5/5starsGreat way to enhance the integration capabilities of Mendix
quang nhat tran
5/5starscan not miss in data project
Wouter van Maasakker - RWS
5/5starsThanks for this module, I like it a lot. Although there is only one change I would recommend.
In ResultSetIterator.java on line 49 you will get the name from getColumnName. This works perfectly if your domainmodel exactly meets the database model. But in many cases the name of the attributes are different or the case is not equal. This results in a horrifying Null pointer exception.
In your queries you want to use the AS statement eq. SELECT name AS FirstName FROM employees.
If you want to change this you have to alter the ResultSetIterator on row 49 from:
columnName = resultSet.getMetaData().getColumnName(index);
columnName = resultSet.getMetaData().getColumnLabel(index);