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.
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.
@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 too quick, I was eyeing this q to answer and then nek minnit.