Anaplan Connect direct to SQL Server

In a batch file for Anaplan Connect can you specify the export location to be a table in sql database rather than just an export to ascii or excel?

Accepted answers

leo_tadjudin_1

Hi Dino,

I think currently it is still a two step process. I might be wrong but the export only has so many formats. You would need to export it as a text but then run another batch file which contain the INSERT statement to SQL database.
The best way to test it is to actually do it.

Regards,
Leo

All comments

leo_tadjudin_1

Regards,
Leo

alan

Is there any plan to have a SQL database connector in Anaplan?

It seems like much separate ETL work is needed to get data in and out of Anaplan, which can be costly. If you could query data into Anaplan and save a step, I think this would allow for faster development.

jesse_wilson

Hi @alan,

To connect to an on premise SQL database, both source and target (Anaplan and dB) would have to reside on the same network, ie. both be deployed on prem (which isn't possible with Anaplan).

Connecting from a cloud source to any on prem resource requires some sort of middleware to handle the transaction. This is true for ETL offerings as well; Informatica, Dell Boomi, Snaplogic, etc, all require a small application to be deployed in your local network in order to be able to communicate with any on prem database.

Regards,
Jesse

Quick Links

Can you help?

Unanswered questions

How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.