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

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
ADO - S3 incremental load vs. full replace
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…