Connecting Source Data To Domo

 We can import data into domo using following type of connectors:

  • File: File connector use to upload file in many ways like: upload file from local, Google Drive, Drop Box, email, and can create webform.
  • Cloud: Use to connect the data from cloud like: Sales force, Google Sheet, AWS and other Cloud data set
  • Database: use to connect data from data base like: My SQL, Snow Flake, Amazon Redshift etc
  • IOT: Use to connect IOT data source
  • Upload: It is same as file connector, its use to upload different kind of file into domo like: excel, csv etc.
Connect to Cloud Data base
  • create connector account 
  • provide credential shared by application owner
  • Assign to other users

Import Data into Domo using Work Bench:

  • Install Workbench 5 in Local Machine
  • Click on Connect a new account in Domo
  • Click on + icon
  • In the domain name field give the server name like company.domo.com
  • Enter the user name and password and then click on sign in
  • Click the save icon to save your account
or

  • Go to admin Admin
  • Generate a token
  • Insert token in workbench
  • you will receive two emails one is for OTP and another is for Weblink
  • Click on the link and fill in OTP and submit
Schedule Job Using Task Schedule:

Create .bat File

"C:\Program Files\Domo\Workbench\wb.exe" run-job --server acme.domo.com --jobid 505


Using bat file using Task Scheduler

Using the Federated Data Solution

Domo's Federated Data model allows you to render cards in Domo using a direct connection to your database hosted outside of Domo's cloud. Instead of executing the visualization query against Domo, the query is executed at the target database and the results are sent to Domo to render the visualization. This model is especially relevant for users who would like to keep their data at rest within their infrastructure for security or logistical reasons.

  • Preserves existing data warehouse investment by allowing for direct connection to customer data lakes and warehouses.
  • No upload to cloud storage.
    • Avoids data duplication and costly data transfers.
    • Reduces data latency due to transfers.
  • Domo supports most commonly available databases. See the FAQ's for our current list.
  • Customer admins retain control of the data.
  • Custom database optimizations can be performed by the customer.
API: We can connect get data from various resource using API call, and we can get the domo data also using API call, WE can do transformation on data as well as stats data of domo like card statistic, dataset and dataflow statistics. Every this that we do in domo using Application can do using API.


Drawbacks

Before using Domo's Federated Data solution, be aware of the following:

  • Query performance depends on the configuration of the customer’s data warehouse, its performance profile and the query load it experiences. This is managed outside of Domo.
  • Federated DataSets do not support the following:
    • ETL, including Data Science actions (as an alternative, you can create Views with the on-premise DataSet.)
    • DataSet Alerts (Card Alerts are supported on Snowflake Federated DataSets.)
    • DataFusions
    • DataSet Views (Supported on Snowflake Federated DataSets from the same account. Cross-account Views are not currently supported.)
Other Method to import data into Domo:

Using Command Line Interface

Visit below link to get more details:

https://domo-support.domo.com/s/topic/0TO5w000000ZanzGAC/other-connection-methods?language=en_US

Data sources for cards

Because your organization may have a large variety of data sources you use to run your business, Domo is designed to help you connect to and import all of that data, providing you access to all the data you need in one place.

Workbench

An "On-premises" platform is an application or database installed on a company’s servers or a local machine. For example, this could be a SQL Server or a legacy software system.

These files can be scheduled and brought into Domo through Workbench, a program you can download that connects to Domo and can transport files from your computer to the Domo cloud.

Local files

These are files that exist on one of your company's or your personal computers. These could be Excel or CSV files or anything else saved on your machine rather than the cloud.

As you go to create a card, there is an option to pull data from your local machine. These file types don't need a connector, per se, but are also not as automated as some connection types.

Other data

As data platforms are as varied and unique as our customers, Domo has to be extra creative and flexible in some cases. For instance, for Dropbox, Box, SFTP (Secure File Transfer Protocol) and other types of specific data, you will need to have a different connection strategy. Domo's team may need to assist you to find the right option for connecting to your data and bringing it into your instance.

Cloud-Based Connectors

These are online software platforms like SalesForce, Facebook, Twitter or NetSuite that provide data you want to bring into Domo.

For hundreds of these systems, Domo has simplified and created a standardized connector interface that will ask for login credentials and access so a user can pull data without having to write code.


Subscribe to: Posts (Atom)