Transition from a regular PostgreSQL connector to PostgreSQL SSH connector

We want to start using the "PostgreSQL SSH" connector in place of the regular one. We already have a number of datasets created, so I'm wondering if there's an easy way to have a dataset use the new SSH connector. I really want to avoid recreating all of the datasets.
The post below makes it sound like this isn't possible in an easy way, but it's a few years old. My hope is that there's a better answer to this issue.
Thanks in advance!
Comments
-
I think you're out of luck still on this one. Switching connector types requires a different type of credential / integration account and changing that in a dataset isn't really an accessible method. You could see if Support has any backend tricks to help accommodate...if you find out please let us know.
In the meantime if you go for a manual migration, just come up with a plan after doing an impact review using stats/governance datasets to get a checklist down. If any of those datasets to migrate have cards pointing directly at them or beast modes on them, it would be a good time to put in a prep layer transform and clean up any beasts too.
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive