Forum Discussion

Amit_RoyME's avatar
Amit_RoyME
Copper Contributor
Apr 23, 2024

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 the salesforce dataset (not object) from ADF. added screenshot of a dataset from salesforce

 

 

2 Replies

  • DattaK325's avatar
    DattaK325
    Copper Contributor
    Sep 30, 2024

    Amit_RoyME 

    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's avatar
      Amit_RoyME
      Copper Contributor
      Sep 30, 2024

      DattaK325 

       

      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.