Forum Discussion
Amit_RoyME
Apr 23, 2024Copper Contributor
consume salesforce dataset through ADF
Hi everyone, I am trying to build ADF to connect to salesforce. I am able to connect to the salesforce objects but not the salesforce analytics datasets. Can you please help how can I connect to...
DattaK325
Sep 30, 2024Copper Contributor
Hey did you get any solution on this? As per my investigation we can use Rest API activity against wave query API from Salesforce Analytics. Not sure though if we can do pagination.
Amit_RoyME
Sep 30, 2024Copper Contributor
I got two options.
1. Creating Json file and share the dataset on a blob storage. Could not find any incremental load option for this
2. Running the dataset query and store the dataset in a salesforce table and expose the tables through API.