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?

Best Answer

  • Misbah
    Answer ✓

    @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

     

Answers