Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to create a job but I don't know the good method.
- I want to get data from a database A.
- I want to verify that these data exist or not in another database B. For this I have a web service that I can call
- If the data doesn't exist, I create these data in the database B (with a webservice that I can call), if not, I get the column "adress" from the database B (with a webservice that I can call) and update the data in the database A with these column
For example :
- I get two invoices from the database A where the column "adress" is null (with a SQL request). I get two columns "name" and "firstname"
- I call a webservice who exists with these two columns (I don't know how to do to pass parameters to a web service.) The webservice replies that the first invoice doesn't exist and the second exists
- I create the first invoice in the database B by calling a webservice (who exists)
- I get the column "adress" from the database B by calling a webservice (who exists) and update this second invoice in the database A by update the column "adress"
Thanks you
Hi @shong
Thanks for your reponse.
So, the good method is :
tMySqlInput (database 1) - tMap - tSOAP (to check result) - (if result ko => tSOAP (to insert in database 2)) - (if result ok=> tSOAP (to get "adress" field) - tMySQLOutput (database 2)
How to check the result of tSOAP ? Can I map tMySQLInput with tMap ?