https://community.esri.com/t5/arcgis-enterprise-ideas/official-support-and-certification-for-timescaledb/idi-p/1085178 <P>Hi,</P><P>&nbsp;</P><P>Currently Esri officially only supports/certifies PostgreSQL + PostGIS as an enterprise geodatabase. Would it be possible to also do this for PostgreSQL + PostGIS + TimescaleDB?</P><P>In theory this combination should work already with ArcGIS Enterprise because TimescaleDB hypertables look and act like any other table in PostgreSQL. But the company I work for will not allow me to do this without some form of official support from Esri.</P><P>Being able to use the TimescaleDB extension for PostgreSQL with ArcGIS Enterprise will bring the following benefits:</P><P>- Write time series data straight to PostgreSQL from external systems. In our case we would like to do this with Spark from our Hadoop cluster and bypass GeoEvent Server.</P><P>- More control over your data than the&nbsp;spatiotemporal big data store gives you. Things like schema changes, bulk updating, etc are a pain when using the big data store.</P><P>- All data together in 1 database means you can combine batch and streaming data with joins and/or views.</P><P>- In theory&nbsp;spatiotemporal big data store is no longer needed so less components for Ops to worry about.</P><P>&nbsp;</P><P>Regards,</P><P>Bert</P> Tue, 03 Aug 2021 07:08:29 GMT Bert 2021-08-03T07:08:29Z https://community.esri.com/t5/arcgis-enterprise-ideas/official-support-and-certification-for-timescaledb/idi-p/1085178 <P>Hi,</P><P>&nbsp;</P><P>Currently Esri officially only supports/certifies PostgreSQL + PostGIS as an enterprise geodatabase. Would it be possible to also do this for PostgreSQL + PostGIS + TimescaleDB?</P><P>In theory this combination should work already with ArcGIS Enterprise because TimescaleDB hypertables look and act like any other table in PostgreSQL. But the company I work for will not allow me to do this without some form of official support from Esri.</P><P>Being able to use the TimescaleDB extension for PostgreSQL with ArcGIS Enterprise will bring the following benefits:</P><P>- Write time series data straight to PostgreSQL from external systems. In our case we would like to do this with Spark from our Hadoop cluster and bypass GeoEvent Server.</P><P>- More control over your data than the&nbsp;spatiotemporal big data store gives you. Things like schema changes, bulk updating, etc are a pain when using the big data store.</P><P>- All data together in 1 database means you can combine batch and streaming data with joins and/or views.</P><P>- In theory&nbsp;spatiotemporal big data store is no longer needed so less components for Ops to worry about.</P><P>&nbsp;</P><P>Regards,</P><P>Bert</P> Tue, 03 Aug 2021 07:08:29 GMT https://community.esri.com/t5/arcgis-enterprise-ideas/official-support-and-certification-for-timescaledb/idi-p/1085178 Bert 2021-08-03T07:08:29Z