nBuilder and db2

[ephDev]

Hi all,
I've started to work with nuBuilder

Before I go further, I have question:
It's possible to make a query on db2 database and make an UPDATE on nuBuilder database (mySQL). ?

Thx

[massiws]

ephDev,
is this a regular task or a once off?
You can build a custom procedure to make your queries on DB2 and MySQL and call this procedure from nuBuilder with runIt() function.

Hope this helps,
Max

[ephDev]

Hi,

Now, When I add a new record, I have to manually insert a record from our ERP (DB2).

I want to automatically query the specific field and add to MySQL db, every time I add a new record.

I'm following the samplefinance example, there is something like this for example?


Thx

[massiws]

ephDev,
nuBuilder version 2 work only with MySQL database, so if you want to manage DB2 records you must create a copy, or replication, in MySQL.
This could be done:

• creating a custom PHP procedure to copy every x time changed records from DB2 to MySQL (as I described in my previous post);
• using IBM Datapropagator to replicate DB2 to MySQL (have a look at this thread).

NuBuilder version 3 will allow to connect with DBs other than MySQL, using PDO.

Max

[ephDev]

Ok, thanks for clarification. GRAZIE

[massiws]

.