topic Re: Can the tables for the new Workflow Manager Server (not classic) be stored in Oracle or SQL Server outside of the Datastore? in ArcGIS Workflow Manager Questions

Can the tables for the new Workflow Manager Server (not classic) be stored in Oracle or SQL Server outside of the Datastore?

PeterStevlingson — Tue, 29 Mar 2022 23:51:51 GMT

Can the tables for the new Workflow Manager Server (not classic) be stored in Oracle or SQL Server outside of the Datastore?

Workflow Manager Server running in ArcGIS Enterprise 10.9.1 .

If yes is there documentation on how to do this? I found the "classic" documentation on how to install to Oracle not in the newest version.

Re: Can the tables for the new Workflow Manager Server (not classic) be stored in Oracle or SQL Server outside of the Datastore?

DEWright_CA — Wed, 30 Mar 2022 00:00:51 GMT

No, they rely on ArcGIS Portals Hosted Server; so they rely on Datastore.

Re: Can the tables for the new Workflow Manager Server (not classic) be stored in Oracle or SQL Server outside of the Datastore?

JFarmer — Wed, 30 Mar 2022 12:37:59 GMT

Hi @PeterStevlingson

@DEWright_CA is correct, there is no way to store the system tables of Workflow Manager Server outside of ArcGIS Data Store.

I did want to mention though that all of the data that you would use within a job can be stored in an enterprise geodatabase. So if you have workflows that involve data editing or analysis of some kind, that data doesn't need to reside in Data Store.

Thanks!

Jonathan