Data Transformation || R Connectivity || Automation
We have a business scenario wherein we need to do data transformations for a data with source from cloud. We need the data to be exported to R or similar tool and import back to DOMO after transformations. We need to automate this process.
Please provide us the steps/process to do this.
Thanks in advance...!!!
Best Answer
-
@Wilko There are a couple package dependencies that cause this issue. You need to make sure that you have httr version 1.0.0 or lower and readr 0.2.0 or lower installed in your instance of R.
I am no longer with Domo. Please @mention @Millhouse for connector specific questions.2
Answers
-
Hi @Neeraj,
You could certainly use Domo’s connectors to download data from various 3rd party cloud sources. Within Domo, you could complete any pertinent transforms on the data and output it to a dataset. You can then export that data out of Domo using Domo’s API, which will provide a CSV dump of the dataset. Details on integrating with Domo’s API can be found in the Domo Developer Portal:
https://developer.domo.com/docs/domo-apis/data
** I work for Domo0 -
@Neeraj We also have a plugin for R that simplifies the moving of data between Domo and R. After installing the plugin in R, you can create a new Domo DataSet directly from R or you can retrieve an existing DataSet from Domo, run your tranformations in R and then push the changes back into Domo. It is currently available as a beta release. Feel free to message me directly if you'd like access to it.
Thanks,
Sam
I am no longer with Domo. Please @mention @Millhouse for connector specific questions.1 -
Hi @kamuela,
I've been given the DomoR plugin, and am currently exploring it.
One problem I have encountered is the fetch command (DomoR::fetch). When I run it I get the following error:
Error in readr::read_csv(x, locale = readr::locale(encoding = encoding), :
unused arguments (check.names = FALSE, na.strings = "\\N", colClasses = c(NA, NA, NA, NA))
The dataset I'm calling exists and has data in it.
I thought initially I had to explicitly name the columns ie c() but that made no difference.
Is this something to do with library versions in devtools package? Have you guys come across this problem before?
regards
Dave
0 -
@Wilko There are a couple package dependencies that cause this issue. You need to make sure that you have httr version 1.0.0 or lower and readr 0.2.0 or lower installed in your instance of R.
I am no longer with Domo. Please @mention @Millhouse for connector specific questions.2 -
Hi,
How do we get a hold of the R package?
Vince
0 -
Hey @vblain if you want to send me a direct message with your Domo login URL and an email address, so I can see which customer account you are part of, I can send you the details.
Thanks,
Sam
I am no longer with Domo. Please @mention @Millhouse for connector specific questions.0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive