Cloud connector or Workbench to get data into instance.?

Tsharma8724

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.

GrantSmith

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.

amehdad

@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.

GrantSmith

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.

amehdad

@GrantSmith too quick, I was eyeing this q to answer and then nek minnit.

amehdad

@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.