Does Anaplan platform provide capability to pull data directy from a SQL Server database?

Hi,

The company I am working for has a datawarehouse in the cloud to which the files needed in Anaplan are loaded on a daily basis. This SQL Server database lives on Amazon AWS. Is it possible to connect to this database and load directly into the Data Hub?

Is this possible through Anaplan Connect and where can I find specific information?

Accepted answers

Misbah

@LouiseBourgonjon

Yes, you should be able to do that. Download latest Anaplan Connect from Anapedia. Keep Anaplan Connect Folder on AWS. Start writing batch or shell scripts and place them in the same folder. Lastly Schedule the jobs which Microsoft Scheduler or Tivoli or any other scheduler can do.

It will pull the files that you have on AWS into Data hub.

Misbah

All comments

srikanthkamath

Hi @LouiseBourgonjon ,

Please go through below link, hope you will find the related information here.

https://help.anaplan.com/anapedia/Content/Data_Integrations/Data_Integrations_Oveview.html?

Regards,

Srikanth

Misbah

@LouiseBourgonjon

It will pull the files that you have on AWS into Data hub.

Misbah

LouiseBourgonjon

Thank you Misbah!

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…