I need to Get data from Anaplan and import them into a SQL Server using Microsoft Integration Services (SSIS). Does Anaplan support it? (e.g. WebService)? If yes, who can provide me the WSDL File?
@EhsanĀ
Yes. Here's an article on how to call and REST API in SSIS. Recommend you use a CA certificate though. Usually, not a good idea to use basic authentication where your password is exposed.
How to Call REST API in SSIS - Read JSON / XML / CSV | ZappySys Blog
Anaplan has many endpoints, so it depends on how you set up your exports from Anaplan. This is usually done with a saved view and a manual export is performed to generate the export action. You can read about Anaplan's REST API's here.
https://anaplanbulkapi20.docs.apiary.io/
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it'sā¦
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
Kindly assist me to load data into the model.
