Cloud connector or Workbench to get data into instance.?

Is cloud connector better approach than workbench to get data into instance or vice-versa?. It would be really help if you can elaborate or differentiate between both.
Best Answers
-
Hi @Tsharma8724
The main difference is from a security standpoint. The cloud connector will have Domo connect directly to your database and are typically easier to get up and running. With workbench Domo doesn’t have direct access to your database but rather you have a local windows machine that will connect to your databases and then that wi does machine will send the data up to Domo giving only a single point for Domo to get data. As this adds an additional layer it can add extra administrative overhead. It depends on your needs which method you’d like to use.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
@Tsharma8724, I would add that a few scenarios for using workbench could be:
- Accessing a siloed amount of data, relevant to you and your region/teams, from a platform that is managed by global headquarters.
- If your business deals with some highly sensitive data then having a local network point of ingestion is a more secure option, than a potentially more exposed route of web UI connectors, to get your data.
8
Answers
-
Hi @Tsharma8724
The main difference is from a security standpoint. The cloud connector will have Domo connect directly to your database and are typically easier to get up and running. With workbench Domo doesn’t have direct access to your database but rather you have a local windows machine that will connect to your databases and then that wi does machine will send the data up to Domo giving only a single point for Domo to get data. As this adds an additional layer it can add extra administrative overhead. It depends on your needs which method you’d like to use.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
@GrantSmith too quick, I was eyeing this q to answer and then nek minnit.
8 -
@Tsharma8724, I would add that a few scenarios for using workbench could be:
- Accessing a siloed amount of data, relevant to you and your region/teams, from a platform that is managed by global headquarters.
- If your business deals with some highly sensitive data then having a local network point of ingestion is a more secure option, than a potentially more exposed route of web UI connectors, to get your data.
8
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 208 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive