Anaplan Connect direct to SQL Server

Previous Contributor

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?

Message 1 of 4
3 REPLIES 3
Highlighted
Frequent Contributor

RE: Anaplan Connect direct to SQL Server

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. :D Regards, Leo
Message 2 of 4
New Contributor

Re: RE: Anaplan Connect direct to SQL Server

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.

Message 3 of 4
Regular Contributor

Re: RE: Anaplan Connect direct to SQL Server

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



Jesse Wilson
Solution Architect - Data Integrations
Singapore
Message 4 of 4