-
What is the easiest way to replace on a few rows in a large dataset?
I have over 200k rows in a dataset and then I find incorrect labels in about 25 records that I need to update, what is the easiest way of overwriting this information?
-
Date Format
I've got a SQL table where my dates are mm/dd/yyyy as shown in the before picture. When I create a dataset on this table domo reformats this date to yyyy-mm-dd as shown in the after picture. My first thought is why is it converting the date to a different format? But more importantly how do I change this so that the data…
-
Can't use PostgreSQL connector without SSL
I am trying to connect to my Postgres database, but it seems that SSL is required although I have configured the connector account not to use one. I have configured No Certificate for the connector, but get an error "Domo is ready, but PostgreSQL returned: The server does not support SSL." (see attached screenshots). Any…
-
Giving Dataset Access to A New Hire
How can I give a new hire access to a certain group of datasets? Example: I need to let a new hire have access to all Salesforce datasets. They should be able to edit, delete, and change all preferences for the determined datasets.
-
Magic ETL Regex
I have a column in my dataset that contains strings of text, similar to the following: Campaign 225 - Facebook - CampaignName.(ThankYou) 4-225_CampaignName Google Ad - Franchise: Service.(ThankYou) 1-G-Fran_Service Campaign 225 - Google - I: CampaignName: AdGroupName.(ThankYou) 3-G-225_PT_WFH I want to use the "Replace…
-
Table Headers as Links
Hi, I'm adding a table where each column header is a link. Such as: <a href="url/path_0">label_0</a><a href="url/path_1">label_1</a><a href="url/path_2">label_2</a>date127date_1238date_2342date_3 As above DOMO is currently rendering my column header as raw html. Any way to get this to render and work as regular link? Thanks
-
Facebook Connector - 30 days of data history limitation
I am currently using "Facebook" DOMO standard connector. However it seems that when I am pulling "Complete page insights report" (or any other reports), I can only get 30 days of data for the page I wanted. 30 days is defininitely not enought to come up with any trendline. Do you know how to configure the connector that I…
-
Renaming Datasets
I'm having trouble getting the renaming of a dataset to stick. Here is what is happening: 1. I rename a dataset in Domo (via the Data Center) 2. Open Workbench. Check job to update the datasouce. The new name is there. 3. Run workbench. As soon as the data starts to upload, the datasource reverts back to the old name. How…
-
microsoft sharepoint data connector
We are trying to setup a Microsoft Sharepoint data connector but we are getting the following error: Server was unable to process request. ---> Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Have contacted support and they are not able to assist us in setting up the data connector. Does anyone know…
-
DataSet Access
As an Admin how do I control Editor Level user access to our libary of DataSets? -Thanks
-
error connecting to ODBC
Using DOMO Workbench v 3.0 (32 bit) on Windows 10 (64 bit) Attempting to connect to a 32 bit system DSN results in an error; "Error connection to ODBC: ERROR [08001][ODBC Sybase driver][Sybase] Login failed." "Error [HY000] [DataDirect][ODBC Sybase driver][Sybase]ct_connect(); protocol specific layer: external error: The…
-
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.