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

Highlighted
Contributor

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?

3 REPLIES 3
Highlighted
Occasional Contributor

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

Hi @l.bourgonjon ,

 

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

Highlighted
Master Anaplanner/Community Boss

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

@l.bourgonjon 

 

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

 

Highlighted
Contributor

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

Thank you Misbah!