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
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
nBuilder and db2
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: nBuilder and db2
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
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
-
- Posts: 4
- Joined: Thu Sep 26, 2013 9:08 am
- Location: Italy
Re: nBuilder and db2
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
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
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: nBuilder and db2
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:
Max
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).
Max
-
- Posts: 4
- Joined: Thu Sep 26, 2013 9:08 am
- Location: Italy
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact: