N/A JDE Server Connect

[dventura]

I am looking to run a SP in Orchestrator from SQL, but the SP involves multiple Databases. Is there a way to connect the whole SQL server to Orchestrator, or will the SP need to be broken up into the different databases?

 

[Kevin Long]

Hi,

You can access multiple databases on a SQL Server instance through a single connection, assuming the credentials used in the database connection have access to those additional databases. You just need to specify any database outside of your default database in your query.

Kevin

 

[Rauf]

You can use Linked Servers in SQL Server.

Linked Servers (Database Engine) - SQL Server

Linked Servers (Database Engine)

learn.microsoft.com

 

[MFreitag]

SP as in Stored Procedure?
The Stored Procedure shouldn't have a problem (with the correct permissions) to run stuff on DB1.SCHEMA.TABLE and DB2.SCHEMA.TABLE. Otherwise, as @Rauf also suggested you could use Linked Servers.