Accessing Adobe data from R within Alteryx | Community
Skip to main content
G
gillian_rodger
October 16, 2015
Solved

Accessing Adobe data from R within Alteryx

  • October 16, 2015
  • 2 replies
  • 1176 views

Hi there,

I have successfully managed to connect to the Adobe Analytics API and extracted some data through RStudio. I have tried to recreate this process through the Rtool in Alteryx so that this process could be automated but I haven't been able to make this work. Has anybody else attempted this? I haven't been able to find any information online so I don't even know whether this is possible.

Thanks,

Gillian smiley 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by adam_gitzes

Hey Gillian,

I haven't mixed the RSiteCatalyst package with Alteryx, but I have automated RSitecatalyst Reporting by creating a batch file that calls my RSiteCatalyst script and scheduling it to run automatically in the Windows Task Scheduler.  It was a couple of years ago, but I believe there was an issue where the RCurl package that RSiteCatalyst uses needed to be explicitly called when used in batch mode, so I'd check just changing your script to make that explicit call and see if it then works in Alteryx.

If not, you can automate your RSiteCatalyst Script produce a csv and then pick that up with Alteryx.  The second answer on this thread (http://bit.ly/1OxGOVq) shows how to run R from command line/batch.  You can then automate your batch file in Windows using these directions (http://bit.ly/1LPR5Wg).  If you have a different OS, simply google "How to schedule a batch file to run automatically in my OS".  

I hope this helps.  Thanks!

2 replies

adam_gitzes
adam_gitzesAccepted solution
October 16, 2015

Hey Gillian,

I haven't mixed the RSiteCatalyst package with Alteryx, but I have automated RSitecatalyst Reporting by creating a batch file that calls my RSiteCatalyst script and scheduling it to run automatically in the Windows Task Scheduler.  It was a couple of years ago, but I believe there was an issue where the RCurl package that RSiteCatalyst uses needed to be explicitly called when used in batch mode, so I'd check just changing your script to make that explicit call and see if it then works in Alteryx.

If not, you can automate your RSiteCatalyst Script produce a csv and then pick that up with Alteryx.  The second answer on this thread (http://bit.ly/1OxGOVq) shows how to run R from command line/batch.  You can then automate your batch file in Windows using these directions (http://bit.ly/1LPR5Wg).  If you have a different OS, simply google "How to schedule a batch file to run automatically in my OS".  

I hope this helps.  Thanks!

TanmayMathur
Adobe Employee
TanmayMathurAdobe Employee
Adobe Employee
October 16, 2015

Hi Gillian,

We tried to dig out information but unfortunately there was no source which could help in what you are trying to achieve, I would suggest trying StackOverflow in this scenario.

Thanks.

TM

Terms & ConditionsAccessibility statement

Loading footer...