-
DataSet used in DataFlow?
I am going through and auditing a Domo instance I inherited to see what I can clean up. I can see if there are cards associated to a dataset but is there an easy way to identify if a dataset is used in a dataflow? I don't want to remove any datasets (that have 0 cards) and risk breaking something else that relies on that…
-
Data set taking hours to update
Hi there, any idea why my dataset would take 11-12 hours to update on some occasions? The thought was that it's too large but sometimes it's updated within 2 hours. Is there anything I can do to speed up the refresh time? This is an Intuit Quickbase data source.
-
MySQL connector issues
I am on a 60 day trial. I have MySQL (Aurora and straight-up MySQL) at Amazon RDS and an independent server, all of which I can access from my PC via MySQL Workbench. All of the servers are set to be publicly accessible. I can't connect to any of them with Domo's MySQL connector this afternoon. Failed to authenticate.…
-
Date column not recognized
Hi all, I have built a Google Spreadsheet, which I am pulling into Domo to feed a card. All data comes in well, but no matter what I do, Domo won't recognize the column <date> as a date column. I concatenate the filed, and I tried several versions: 2016-13-01 2016/13/01 01-13-2016 01/13/2016 Domo won't recognize it. I also…
-
Excel Dataset permissions
We have an excel dataset and we'd like to have other privileged users be able to upload new versions, however only Admins and the owner of the dataset have the access to update the data. Is there a way around this without giving users Admin rights? I've looked at PDP and it doesn't appear to be a solution for this...
-
How do I see how close we are to hitting our Maximum Data Limit (10 GB)?
I see how many rows we have in Storage, by clicking on the Data Warehouse, but I don't see how many gigabytes this equals. How do I find that out?
-
Is there a DOMO connector to on premise MS SQL or Microsoft Access?
We have an on-premise SQL DB which I want to pull from to upload to DOMO. But I don't see any data connectors for on-premise SQL. Another option is that I set up an MS Access Pass Through query to pull only the specific data I want from the SQL DB and connect that to DOMO. But I don't see any connectors for MS Access…
-
Use Personal Mac as SFTP Server for CSV-SFTP Connection
Hello, I'm using a Mac (OS X Yosemite) and am attempting to use the CSV-SFTP connector. I'm hoping to use this machine as the SFTP server. In other words, connect locally and upload CSV files that live on my personal machine. I'm running into a roadblock with the connection. I've enabled remote sharing, and have…
-
Valid datetime format entry in Domo Online Form
When using the Domo Online Form as a dataset, what is the text format used to input in a valid datetime entry in order for DOMO to recognize it properly as datetime? I've tried the following but it is only able to recognize the date but not the time: 2015-05-26 10:30:00.0+00 2015-05-26 10:30:00 2015-05-26 10:00:00AM
-
How do we stop users from accidentally sharing data sources?
I work in a healthcare company and we are hoping to bring on more clients and allow them to make their own cards in Domo. It is important they don't get access to each other's data though. I'm afraid that one day one of our clients will accidentally share a card with another client, who will then have access to the first…
-
"Proper" Online form as data input
Is there a way to use Domo in conjunction with either a built in feature or easy to set-up add-on/connector to directly add data to a DataSet using a online form. Ideally it would be set up directly on Domo like the Poll function but feed a DataSet like Domo webform. The built i Domo Webform is a bit too crude compared to…
-
How to handle a date/time stamp in a filename for Box
Hey Dojo Folks, I have a question, one of our data sources (doubleclick) only sends files to Box with a date/time stamp in the filename. With the existing Box connector is it possible to strip out the date in the file name so that I can set up a consistent dataset import for Domo? Or does anyone have another work around…
-
How do you connect to Domo's own data
I feel like I'm missing something that's right in front of my face. Domo recently published some apps around data and user metrics (great!!). But here is where I'm getting lost... Isn't the underlying data beneath these metrics based on the same domo controled database for every customer? Card views; user groups; Stale…
-
Domo Data API 405 Response
I'm attempting to import data via the API. I have successfully created a dataset through the API, however when I attempt to import data to it via /v1/datasets/ID/data I get an error: 405 Method not allowed Is there some permission my account needs to have in order to do this? I have editor permissions at the moment. Thanks.
-
why are my transactions dates coming in as shift dates?
I have a pretty simple query pulling from Oracle tables but it's transforming the dates when I run it through the workbench. In SQL Developer, it returns the Actual Completion Date as 'DD-MON-YY HH24:MI:SS': to_char(gbs.actual_cmplt_date,'DD-MON-YY HH24:MI:SS') "Actual Completion Date" I've used this same syntax to…
-
How do I link widgets in a domo app?
I created a DOMO app that has 2 widgets: 1) Drop down widget that allows the users to select vendors 2) A widget that displays the total number of tickets based on vendors In the Illustrator, I linked the drop down widet to the other widget based on vendor name. However when I published the app, changing the vendor name…
-
Quickbase
Are there any data connectors for QuickBase?
-
Dynamics GP - Data into Domo
Hi , has anybody ever been able to connect Domo to Dynamics GP data to bring GL transactions , payables , receivables ? if anyboday has done it sucessfuly , would you share how it was done ? Thanks
-
Is there a way to connect to dataflow sources from an external sql client for development?
This would be nice for testing out different ideas, before putting them into the dataflow proper.
-
Does anyone prefer Box.com vs. Dropbox for automated import of flat files from an email attachment?
I am looking to find the best solution for automating the import of flat files off attachements of specific e-mails. Are one of these solutions easier than the other? I am wondering the specifics on how it would only grab a specific, desired e-mail. These files will most likely be appended bi-weekly to a dataset in DOMO.
-
Fitbit Connector - User Activities Steps - Friend ID's
I'm trying to pull in steps for a Fitbit user and a series of the users friends. I have it setup where I can pull the steps for the user using the User Activities Steps report. When I try to enter the ID of one of the users friends however, the connector fails. I got the friend ID by going to the friends profile page and…
-
Has anyone successfully connected into JW Player
I have a customer moving from BrightCove (which we have an API for) to JW Player. Have we connected successfully into JW Player and what does that connection look like? Status of a possible JW Player API?
-
Can i convert columns to rows?
I have a data source that has data in columns based on dates or Yearmonth formats. I need to pull some of that data out and convert it to a row. For Example: Column 1 Column 2 201510 500 201511 600 201512 700 201601 300 201602 900 I need to create a table: 201510 201511 201512 201601 Row 1 500 600 700 300 Can I do this…
-
Anyone using custom dashboards in Google Analytics?
I have custom dashboards built in Google Analytics that I want to pull into DOMO, but their connector only grabs the home stuff that doesn't do anything for reporting at all. Is there a way to point the connector at custom dashboards for reporting in DOMO?
-
Anyone using the Basecamp connector?
My company uses Basecamp to discuss projects and assign tasks, and I have connected the data to Domo to help project managers visualize workflow. I am wondering if anyone else is using the Basecamp connector, and if so how? On a side note, a Basecamp 3 connector would be nice.
-
Is a workday connector in the pipeline?
Is there a workday connector in the pipeline? Should we expect to see this soon?
-
Responsys API
Hello - Does Domo have an API with Oracle's Responsys?
-
Converting String to Date in Dataflow
Hi, I have a dataflow where I combine two data sources. source1 has a date field formatted MM/DD/YYYY, and source2 has a date field formatted YYYY-MM-DD - let's call them date1 and date2. source1 also has far more records than source2, so I'm trying to perform as many calculations as possible on source2 rather than…
-
weekly sales dataflow
Can i create a dataflow that creates a column in the dataset that sums my daily level sales to weekly level sales? My input dataset has sales at the daily level, and i would like to join it to another dataset that only has sales at the weekly level, so I'd like to create a column that has the weekly level sales with the…
-
Select distinct value from table using Magic ETL
e.g. Selecting distinct date from date column using Magic ETL?