db.connect(string,string,string) parametres

OL Connect Professional DataMapper
1

my main datastream is an text stream. I want to retrieve a email stored in a data based on the Customer ID field (extracted in previous step). This information is stored in a MySQL database present on the MySql Server Connect.

I can not connect to this external database from DataMapper because I do not know the syntax of the command db.connect (string, string, string). Can you give me an example of the expected syntax for connecting to local mysql database ?

I tried more syntax like: var cnxn = db.connect(“localhost/database”,“user”,“password”);
but without success

2

Michel,

Unfortunately, there is an issue with the DB object that prevents it from connecting properly to databases. We are currently attempting to identify the cause of the issue so we can fix it in the next maintenance version. In the meantime, your best option is to use the Workflow tool to pull the information from the database and add it to each record.

3

thanks for your answer.
As you have advised me, I will try to achieve this through the ‘workflow’.