-
Has anyone gotten replacement variables to work with the ODBC connector on a consistent basis
I am trying to utilize replacement variables on ODBC connector queries to move towards incremental APPEND queries instead of REPLACE queries. However, it is taking multiple attempts to get the workbench to save the replacement variable. Without saving it, I keep getting "Replacement parameter does not exist for column XXX"…
-
Tool to convert MySQL data flows to Magic ETL
In order to take full use of the power Magic ETL v2, it would be great if a tool could be developed to take a MySQL data flow and convert it to Magic ETL
-
Where are the Magic ETL Formula Editor / Add Formula functions documented?
I'm looking for actual documentation of the DATE_FORMAT, DATE_TRUNC, and TIMESTAMP_TRUNC functions.
-
DataSet View -- Add to DomoStats
I would like a DomoStat report that included information on ownership and use of DataSet views. We have something like this for Datasets, Dataflows, Cards, Pages, …
-
Use Case for Recursive CTE -- Or is there an alternative?
I am pulling DomoStats data sets for: DataFlow Input DataSets DataFlow Output DataSets First Step - Combining input_output defined as: Select dfin."Dataflow ID" as dfid , dfin."Datasource Input ID" as dsin , dfout."Datasource Output ID" as dsout from "dataflow_input_datasets" as dfin join "dataflow_output_datasets" as…
-
Can Domo query Salesforce archived activities (task and event records)?
Salesforce groups tasks and events into 4 groups: Archived but not deleted Archived and deleted Not Archived or deleted Not Archived but deleted Through the rest API, the only way to get to everything is by using .queryAll() instead of .query() … Can ANYONE with direct Domo product knowledge confirm is used for queries
-
DataFlow Notes - Output Datasets
I would like the DataFlow Notes on Output Datasets to be available in the DataFlow's /datasets view (possibly using the same yellow note embellishment icon as used within the DataFlow.)
-
DomoStat Cards with Annotations
We have just started to use card annotations, and we would like to keep our annotations consistent. The best way that I can think of to do this, is to provide a DomoStats data set of Cards with Annotations. I would like: — Card Id — Annotation Date/Time — Annotation Text
-
Sortable Link
We know how to add a link field to a table, using: Here is a way to get it to be sortable… Insert a throw-away attribute to the left of the link. instead of CONCAT('<a href="', `Card Link`, '" target="_blank">',`Title`,'</a>') UseCONCAT('<a title="', `Title`,'" href="', `Card Link`, '" target="_blank">',`Title`,'</a>')…
-
Is anyone else having difficulty connecting to Twitter?
Twitrter must have changed something about their authentication. I can authenticate just fine on the web site, but my data set shows "Domo is ready, but Twitter returned Could not authenticate you." I tried to reauthenticate the access account and just got a blank screen. I also tried to add a new account and got the Domo…
-
Is there documentation of the java CLI command export-data?
Is there documentation of the java CLI command export-data any place except inside the .jar file? I read thru https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool#2.3.8. and it seems to describe everything except the export-data command. It just has the comment "For full exports, use…
