Does Domo connect to 3rd party systems?
Domo can connect to any 3rd party data sources that have an API, either through prebuilt cloud connectors, on-premises connectors, file upload connectors, federated connectors, or custom connectors.
Prebuilt cloud connectors manage and maintain API calls from Domo to many common data systems. These are preexisting connectors that bring in data from most large social media platforms, CRM systems, data warehouses, HR systems, and more. These user-friendly options require little to no coding experience and allow Domo users to schedule data pulls from the source into Domo.
On-premises data can be easily and automatically uploaded to Domo through Domo Workbench, which securely connects to on-prem data sources like ODBC, JIRA, XML, CSV and more. File upload connectors enable you to pull flat files, Excel sheets, email files, and more into Domo without manual processes. Federated connectors enable users to query data directly from the host platform, such as Data Warehouses and Data Lakes.
Users can also build custom connectors to integrate almost any data source with Domo, using Domo’s secure SDKs, Webhooks, or the Connector Dev Studio.
Do I need to hire a consultant to use Domo apps or connectors?
Many Domo data connectors can benefit from an experienced consultant. Consultants ensure connections are optimized and secure and provide an understanding of the resulting datasets, so you can get the most from your data.
While many prebuilt connectors, Workbench, and file upload connectors are relatively easy to initially set up, understanding the resulting datasets will go a long way when it comes to manipulating the data to gain important insights. There is a lot that you can do with your data in Domo, and since each business is unique, engaging a consultant is a great way to ensure your data is clean and actionable.
Building your own connector requires API knowledge to set up and automate, and if there is not someone on your team with this experience, we highly recommend engaging a consultant to help.
How long does it take to set up a Domo connector?
The time required to set up a cloud connector is different for each connector, use case, and experience level. It can take anywhere from a few minutes to a week to set up the initial connection, with additional time to explore the reporting options and build actionable datasets.
Most connectors require an authentication token from Domo and a login to the desired platform. From there, users will need to select the specific dataset and granularity they are looking for, update method, and update schedule. Some connectors require more in-depth configurations as well – it really depends on the connector and use case. This is where help from a consultant can really come in handy.
Time investment varies even more greatly to create your own connector, depending on the complexity of the API and coding experience of the team.
How to set up the Domo Google Analytics Connector?
The Google Analytics Advanced Connector (formerly Google Analytics Connector) is the baseline Google Analytics connector to Domo. You will need to input credentials to a Google account linked to analytics, which then allows you to choose a report, date range, segments, and more.
Once the requirements are filled out and each relevant dataset is brought in, users may need to set up ETLs or MySQL dataflows to connect the relevant datasets, depending on the use case. You can find a list of all of the available views, reports, date and segment configurations, filters, and advanced settings here.
How to set up the Domo Google Ad Manager Connector?
To set up the Google Ad Manager Connector, users must input credentials to an associated Google account, and then choose from a list of reports. Various other menus and configurations are also needed depending on the report chosen.
Once the requirements are filled out and each relevant dataset is brought in, users may need to set up ETLs or MySQL dataflows to connect the relevant datasets, depending on the use case. You can find a list of all of the available views, reports, date and segment configurations, filters, and advanced settings here.
How to set up the Domo Facebook Connector?
Once you have opened the Domo Facebook Connector, select ‘Connect’. Then log into your Facebook account in the pop-up screen, select the relevant pages, accounts, and settings, and click done. Now you may choose a report and settings that fit your use case.
Once the requirements are filled out and each relevant dataset is brought in, users may need to set up ETLs or MySQL dataflows to connect the relevant datasets, depending on the use case. You can find a list of all of the available menus, reports, accounts and period configurations here.
How to set up the Domo Facebook Ads Connector?
To power up the Domo Facebook Ads Connector, you will need a Facebook login with access to your company’s Facebook Ads account. Input this information through the Connector interface, and then choose the relevant settings, datasets, and configurations according to the prompts.
Once the requirements are filled out and each relevant dataset is brought in, users may need to set up ETLs or MySQL dataflows to connect the relevant datasets, depending on the use case. You can find a list of all of the available reports, Ad configurations, and date and time configurations here.
How to set up the Domo Adobe Analytics Connector?
First, choose which Adobe Analytics connector to use, based on the login method (OAuth vs JWT) and the API type (v1.4 or v2). Each configuration has a separate connector.
OAuth connectors require the user to create a new OAuth project in the Adobe Analytics Console.
For OAuth connections, first open the appropriate connector in Domo and input the client ID and client secret for your Adobe Analytics account into the Credentials pane. Next, follow the steps as prompted by the Details pane within the connector page. There are details about the various reports here.
JWT connectors require the user to create a new JWT project in the Adobe Developer Console. Then open the connector in Domo and input the following information into the credentials pane: client ID, client secret, technical account ID, organization ID, and private key. Next, follow the steps as prompted by the Details pane within the connector page. There are details about the various reports here.
How to set up the NetSuite Domo connector?
You will need to configure NetSuite according to the instructions on this page. Next, open the NetSuite Connector and select the appropriate environment, either Production or Sandbox. Then input your Username, Password, Role ID, Account ID, Script Bundle ID, and Deploy Bundle ID.
This connector is a bit more involved in the initial setup than others and may require support or consulting help. Once the initial connection is set, you will be able to create Datasets easily from your saved searched tab.
How to set up the Zendesk Domo connector?
Open the Zendesk Connector in your Domo instance. Within the Credentials pane, enter your Username and Zendesk URL, choose if you would like to sign in with your password or API token and enter accordingly. Select Connect, pulling up the Details pane, and choose a specific report and menu configurations depending on the report selected.
Once the requirements are filled out and each relevant dataset is brought in, users may need to set up ETLs or MySQL dataflows to connect the relevant datasets, depending on the use case. You can find a list of all of the available reports, date configurations, and query configurations here.
How to set up the Workbench Domo connector?
At the time of writing, Workbench 5.1 is the newest version of Workbench, which is used to connect Domo to on-premises data. First, download workbench from the Tool Downloads in the Admin Center of your instance. Then set up a job by selecting the ‘+’ icon in the Jobs pane.
Configure the basic settings for the job from the initial menu. Choose a dataset job name, data transport method, data reader type, dataset name in Domo, and descriptions here. Then click Create.
The next step is where you will configure and schedule your job. Once you select the Configure tab, use the Source window to select the source and file path for your job. The Processing window allows you to set any specific SQL required for this job. Then select either Append or Replace as your Update Method, depending on the use case.
The Schedule tab allows you to run the job on any type of basic or advanced schedule. The Schema tab is used to protect datasets from schema changes or specific columns from data type changes. Use the Notifications tab to set alerts based on successful or unsuccessful runs. Finally, the History tab allows you to view the history and logs for that job.
Domo has a complete writeup on Workbench 5.1 here.
How to set up the Salesforce Domo connector?
To begin, install the Domo Connector Package from the Salesforce AppExchange, choosing the ‘Install for All Users’ tile in the last step. Then validate the installation by opening the ‘Salesforce Managed Package’ connector from the Domo Appstore, clicking ‘Get the Data’, and filling out credentials.
If everything has been set up correctly, this dataset will run successfully. Then open the Salesforce Connector, choose the appropriate environment, and enter your username and password.
The next pane allows you to select the data you would like to bring into the environment, by selecting the type of data, data fields, query options, and query reset settings. There is information for the settings here.
How can RXA help connect to my 3rd party data sources?
RXA is a proud Domo consulting partner. We help set up, maintain, and optimize your Domo instance, including your Domo apps and connectors. We have set up prebuilt Domo connectors in hundreds of instances and helped our clients build impactful insights from these datasets. Our team also builds custom connectors for many of our clients, optimizes Workbench usage, and more. If you have a connector-related problem, we will find (or build) a solution!
For more information about our Domo consulting capabilities, visit our website at https://rxa.io/domo or contact our team at learn@rxa.io.
Common Domo Connectors
Twitter Connector
Twitter Advanced Connector
Twitter Ads Connector
Twitter Engagement Connector
Facebook Connector
Facebook Advanced Connector
Facebook Ads Connector
Facebook Ads Advanced Connector
Facebook Ad Library Connector
Instagram Connector
Instagram Business Connector
Snowflake Connector
Snowflake Writeback Connector
Snowflake Unload Connector
Snowflake Partition Connector
LinkedIn V2 Connector
LinkedIn Ads Connector
Google Analytics Advanced Connector
Google Analytics Realtime Connector
Google Analytics Enterprise Connector
Google Analytics Mgmt Service Account Connector
Google Analytics Management Connector
Google Analytics Unsampled Connector
Google Analytics MCF Connector
Google Ad Manager Connector
Google Ads BigQuery Service Connector
Google Ads BigQuery Connector
Google AdSense Connector
Google Admin SDK Reports Connector OAuth
Google Admin SDK Reports Connector
Salesforce Connector
Salesforce Advanced Connector
Salesforce ExactTarget (Marketing Cloud) Connector
Salesforce Pardot Connector
Salesforce Managed Package Validator Connector
Salesforce with Upsert Connector
Salesforce Chatter Connector
Salesforce Radian6 Advanced Connector
Salesforce Radian6 Connector
Salesforce Pardot Connector With Single Sign-On Support
Salesforce Writeback Connector
Database.Com Connector
Remedyforce Connector
Marketo Connector
Marketo Bulk API Connector
Netsuite Connector
Netsuite App TBA Connector
Netsuite SuiteAnalytics Connect Connector
Netsuite Writeback Connector
Zendesk Connector
Zendesk Talk Connector
Zendesk Chat Connector
Zendesk Sell Connector
Zendesk Sunshine Connector
Zendesk Sell Firehouse Connector
QuickBooks Connector
QuickBooks Online Reports Connector
QuickBooks Via Workbench Connector
File Upload
File Upload Connector
Excel SFTP Connector
Excel SFTP Push Connector
DataSet via Email Connector
CSV Advanced Connector
CSV Connector
CSV SFTP Pull Connector
Dataset Copy Connector
XML Connector
XML Advanced Connector
CSV SFTP Push Connector
XML via Workbench Connector
Microsoft Excel via Workbench Connector
Microsoft Access SFTP Connector
SFTP Writeback Tile
XTM International Connector
Google Sheets Connector
Google Sheets Writeback Tile
Google Sheets Writeback
Github Connector
Github Enterprise Connector
Shopify Connector
Square Connector
MailChimp Connector
Amazon S3 Connector
Amazon S3 Advanced Connector
Amazon Redshift Connector
Amazon Redshift Advanced Connector
Amazon Redshift Via ODBC Connector
Amazon Redshift Upsert Connector
Redshift Writeback Tile
Amazon Athena Connector
Amazon Athena JDBC 2.0 Connector
Amazon Marketplace Wed Service Connector
Amazon Web Services Billing Connector
Amazon CloudWatch Connector
AWS IoT Device Defender Connector
AWS IoT Core Connector
AWS IoT Device Management Connector
AWS Data Exchange Connector
Amazon Web Services IoT Analytics Connector
Amazon S3 User Specific Permissions Connector
Amazon S3 AssumeRole Connector
S3 Writeback Tile
Amazon Advertising Connector
Amazon Aurora Writeback Tile
Amazon Athena Upload Connector
Amazon Redshift SSH Connector
Streaming Data via AWS Kinesis Connector
Box Connector
Box Advanced Connector
Box Analytics Connector
Box Analytics Advanced Connector
Box Writeback
Box Governance Connector
Box Writeback Tile
Dropbox File Connector
Dropbox File Advanced Connector
Dropbox For Business Advanced Connector
Dropbox Writeback Tile
Dropbox Writeback Connector
Adobe Analytics 1.4 JWT Connector
Adobe Analytics 1.4 OAuth Connector
Adobe Analytics V2 OAuth Partition Connector
Adobe Sign Connector
Adobe Analytics Real Time API Connector
Adobe Target Connector
Adobe Advertising Cloud Connector
JSON Connector
JSON Advanced Connector
JSON No Code Connector
JSON Webhook Connector
JSON Easy Connector
JSON No Code OAuth Connector
Domo to JSON Post Writeback Tile
Domo to JSON Post Writeback Connector
Email Connector
Dataset Via Email Connector
MySQL Via Workbench Connector
ODBC Via Workbench Connector
XML Via Workbench Connector
OLAP Via Workbench Connector
JIRA Via Workbench Connector
CSV Via Workbench Connector
QuickBooks Via Workbench Connector
Microsoft Dynamics NAV Via Workbench
Microsoft Dynamics GP Via Workbench Connector
Oracle Database Via Workbench Connector
SAP Via Workbench Connector
Teradata Via Workbench Connector
Microsoft SQL Server Via Workbench Connector
PostgreSQL Via Workbench Connector
Domo Workbench Connector
OPC Via Workbench Connector