How to set up integration from MS SQL Server table to Anaplan model via Talend
Hi,
We are trying to load contents from a table in MS SQL Server table to Anaplan model (processes, actions, etc.) using Talend.
So far we are able to make connection to Anaplan model and do the authentication successfully. We are able to view all import ids of the model / process ids / action id.
I am following this user manual to do this integration, however, unable to do the successful connection.
Best Answer
-
Hi @jgangapurkar (and anyone else having similar issue it in the future),
Remember that not all calls are GET - some are PUT or POST or DELETE or even other. It basically depends on what you want to do:
- If you want to "read" (or get, hence the name) some data, you use GET. That's what happened in the original question, so Anaplan returned the list of tasks.
- If you want to "write" (so modify the data/trigger an action/put something on the server), you should use PUT or POST (depending on the endpoint and what you want to do, POST is more "add", and PUT is more "replace"). Then you are telling Anaplan to actually do something with the data that you send, transform it, load it or start some action. That's what needs to be done to start the import in question.
- If you want to remove something, then in some use cases you can use DELETE request - which removes a specified resource from the server (like a file you previously PUT there).
As it's general web concept, it's worth reading more about it if you are interested, like here:
0
Answers
-
Hi,
This article is good one on how to setup connection with Talend. Have you checked this one already? If you are using Basic authentication instead of CA Certs you can change value for Authorisation to be "Basic <Base 64 encrypted username:password>". You can also leave request body empty. Other than that same Talend flow should work.0
