Connecting to Database
Hello All,
Good day to you. I am new in DOMO and trying to learn it. As of now, as per my understanding, if I want to bring any On-premise data in DOMO, I need to use Workbench.
Now for example, I wanvt to connect one SQL Server Database from my computer. To connect that I can use Workbench and also I am seeing there in an option to connect "DATABASE" if I go to Data Center (which is in turns allowing me to connect the database through Connectors).
Can you please let me know in this scenario, which approach I need to follow? Workbench or through Connector and what is the advantages and disadvantages between these two approaches?
Also please let me know if my understanding is wrong.
Thanks in advance.
Comments
-
Hi!
You can connect your on-premise data with the SQL Server Connector.
'Use this connector when you need direct access to raw data. Otherwise, given that IT must open up access to the SQL server from outside the corporate intranet in order to use this connector, Workbench is generally the preferred option for connecting to SQL Server. For more information, see Connecting to Data Using Workbench.'
Roberto
0 -
Hi Roberto,
Thank you for your inputs. I just wanted to understand, if we have connectors available for everything, then why we should use Workbench? Is there any drawbacks for using connectors instead of Workbench?
For my scenario only, SQL server is installed in my computer. So I can consider it as on premise data. So if I connect it through Connectors then will there be any problems like performance issue or anything like that?
Regards,
Sourav
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive