https://community.esri.com/t5/arcgis-online-questions/workflow-ideas-for-arcgis-online-to-sql-oracle-db/m-p/1344447#M55555 <P>Over the past few years we've thought about a workflow process of storing data in a database, either Oracle or SQL, and piping data from various tables into a feature layer hosted on AGOL (not running Enterprise/Portal). The workflow would also work going the other way where data entered into a SmartForm or S123 app feeds the feature layer and then those data get pulled into the Oracle/SQL tables.</P><P>One idea would be that Python with the ArcGIS API for Python be used to pull data from the FL and pipe it into a data frame where it could then be piped into one or more tables stored in Oracle/SQL. Embedded SQL queries can do this, but it can be cumbersome.</P><P>I'm wondering what others have done or if there's a better way of syncing data from AGOL to a database connection that's efficient? Any ideas, suggestions, helpful tips would be appreciated!</P> Wed, 01 Nov 2023 15:21:01 GMT KansasDASC 2023-11-01T15:21:01Z https://community.esri.com/t5/arcgis-online-questions/workflow-ideas-for-arcgis-online-to-sql-oracle-db/m-p/1344447#M55555 <P>Over the past few years we've thought about a workflow process of storing data in a database, either Oracle or SQL, and piping data from various tables into a feature layer hosted on AGOL (not running Enterprise/Portal). The workflow would also work going the other way where data entered into a SmartForm or S123 app feeds the feature layer and then those data get pulled into the Oracle/SQL tables.</P><P>One idea would be that Python with the ArcGIS API for Python be used to pull data from the FL and pipe it into a data frame where it could then be piped into one or more tables stored in Oracle/SQL. Embedded SQL queries can do this, but it can be cumbersome.</P><P>I'm wondering what others have done or if there's a better way of syncing data from AGOL to a database connection that's efficient? Any ideas, suggestions, helpful tips would be appreciated!</P> Wed, 01 Nov 2023 15:21:01 GMT https://community.esri.com/t5/arcgis-online-questions/workflow-ideas-for-arcgis-online-to-sql-oracle-db/m-p/1344447#M55555 KansasDASC 2023-11-01T15:21:01Z