An IT/IS stakeholder raised to me their concern that Domo, like many BI vendors, was a one-way street: a tool where you can easily push data in and not get data out. The underlying narrative: both business and IT stakeholders see vendor-lock as a risk to minimize. I assured the gentleman, in addition to extensive dashboard creation and distribution capabilities, Domo positions itself as a data distribution hub by providing several data extraction methods suited for a broad mix of users with different usage requirements.
TLDR for Data Governance teams: My most successful enterprise clients position Domo at the end of a data lake or data warehouse pipeline then use built-in tools to secure, monitor and distribute data to different stakeholders. Domo's distribution methods get data into the hands of data quality and governance teams, data scientists, and business analysts in the platforms of their preference, which of course ranges from Tableau and Qlik to Jupyter notebooks, Office 365 products, or any other SQL or data storage platform. IT/IS accomplish this without increasing administrative overhead by applying security measures in Domo which trickles through all the data distribution options outlined below.
The most commonly used tool for configuring and scheduling the transfer of on-premise data into Domo cloud is Workbench. It is particularly popular with IT and SQL developers because it leverages standard ODBC and JDBC drivers in a familiar interface and supports transferring CSV and Excel files if access to source systems is prohibited.
Domo's library of over 1000+ SAAS and PAAS connectors minimizes friction when starting new data projects and facilitates the automated ingestion of data from an ever-expanding range of source systems. If your platform isn't available as a pre-built connector, Domo has low-code and no-code tools to facilitate the creation of custom connectors (which a security team will review to ensure safe-handling of data as it moves through the Web!)
As mentioned in the TLDR section, Domo distributes SDKs and CLIs backed by an open API framework to support systems integration projects, data distribution in custom apps, and new data ingestion models.
For clients leveraging Azure, GCP, AWS or Snowflake cloud storage, Domo supports federated query.
For data architects and pipeline engineers: the number one reason to consider Domo as the centrepiece for data distribution is Domo does not charge for compute or data transfer--thus eliminating unexpected end-of-month utilization fees.
For infosec and data governance teams: Domo's security framework (PDP) applies to all data distribution models for authenticated users.
For PowerBI, Qlick, Excel, and Tableau analyst teams, Domo provides secured and governed data access via ODBC driver.
To facilitate systems integration, data backup, and business process automation, Domo features writeback connectors as a core part of Domo's Integration Cloud offering. These connectors can be configured to update SQL tables, perform targeted updates to calendars and websites, initiate ad-spend, or update SalesForce records as part of an automated workflow originating in a Domo ETL.
It's time to start thinking bigger than Dashboards
Yes, Domo makes it all too easy to create and distribute dashboards and cards for your core business stakeholders. But it's time to think bigger.
By connecting to source systems, you can generate cards that incite action.
My name is Jae Wilson. I partner with clients to use data and technology to solve business problems and design digital products and services.