Instead of building a BP to execute stored procedures just to insert the data, I figured I would give Linked Stored Procedures a try since all I need to do is insert the data. I have proved in our MS SQL Development environment that it is possible, so I through I could just repoint the Linked Stored Procedure
set hdbc=$$GetJConnection^%apiGTW("xxxxx")
to the test environment. But when I made the changed in VSCode and compiled the Stored Procedure disappeared from the SQL view in the Management Portal.
So can we not simply update the connection string to point to a different MS SQL Connection?
.png)

.png)
.png)
.png)
.png)
.png)
.png)

.png)
