How to import data to mendix with Database connector (MS SQL)

0
We want to import data from a MS SQL database. A user can select between project number (Which should be imported from an external database (See picture))   After the choice has been made, other fields should also be automatically filled with the data in the same row.   I don't understand the connector at all. This is the JDBC URL:   I also placed the mysql jdbc driver (.jar) in the userlib.   When i place this jdbs url it gives a error:   JDBC url between single quotes:   Is this the correct way to to a SQL select and i have multiple errors:   Used the “Data view” tool: Setting:   Microflow: Settings Microflow: Errors:
asked
5 answers
4

you may find this useful: https://docs.mendix.com/appstore/connectors/database-connector/

answered
0

Did you place the jdbc url between single quotes?

That is the indication that it is a string.

answered
0

Hey

It’s slightly old but I watched this 4 part tutorial and have just finished creating a full app with a sql db as a backend.

https://www.youtube.com/watch?v=eJVFyDONU9Y

From a quick look you have not chose a result object, you need to create an empty object before the call so it knows the format it returns in.

Additionally it is better to use the parameterised actions so you can just specify in there. Also create constants for the url, pwd, username so you don’t have to copy paste everytime can just treat them as variables.

This is also how you import data to your mendix frontend. The tutorials solve your issue as well.

 

answered
0

You need to create an entity to capture the resultset. Something like this:

In the microflow, you create one object of the entity and pass it as the result object.

And pass it as $NewProject as the results object.

answered
0

i think i'm going in the right direction

 

Still no output… :(

answered