Do I need to hand modify the config.yml to connect to a different SQL DB?
New to Workato. A coworker set up a recipe that upserts into an on-prem SQL Server DB table. I tried to create a new SQL Server DB connector that will connect to a different DB on the same SQL Server. I'm using the existing connection profile in the new connector. It allowed me to create the connector, but I am unable to upsert into this new DB and it doesn't come up when I look at "Select Table" in the upsert action. Do I need to create a new profile? Do I need to hand manipulate the config.yml on the host that hosts the existing agent?
System Integration
Do I need to hand modify the config.yml to connect to a different SQL DB?
New to Workato. A coworker set up a recipe that upserts into an on-prem SQL Server DB table. I tried to create a new SQL Server DB connector that will connect to a different DB on the same SQL Server. I'm using the existing connection profile in the new connector. It allowed me to create the connector, but I am unable to upsert into this new DB and it doesn't come up when I look at "Select Table" in the upsert action. Do I need to create a new profile? Do I need to hand manipulate the config.yml on the host that hosts the existing agent?