topic Re: My SQL data management sytem in Data Management Questions https://community.esri.com/t5/data-management-questions/my-sql-data-management-sytem/m-p/657366#M37239 <HTML><HEAD></HEAD><BODY><P>Thanks Adrian, your information will help answer my questions. Thanks for taking the time to post <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P><P>Jane</P></BODY></HTML> Tue, 26 Jul 2016 19:16:26 GMT janehansen 2016-07-26T19:16:26Z My SQL data management sytem https://community.esri.com/t5/data-management-questions/my-sql-data-management-sytem/m-p/657364#M37237 <HTML><HEAD></HEAD><BODY><P>I am working with a computer tech who would like to implement a MySQL data management system for a non-profit org. This system would store spatial and non-spatial information.&nbsp; </P><P>1. I am wondering if arc gis can import spatial information from an MySQL data management system</P><P>2 Is this an ok way to store spatial and non-spatial data for use in arc gis...or what would a better design be?</P><P></P><P>Thank you,</P><P>Jane</P></BODY></HTML> Tue, 26 Jul 2016 17:57:15 GMT https://community.esri.com/t5/data-management-questions/my-sql-data-management-sytem/m-p/657364#M37237 janehansen 2016-07-26T17:57:15Z Re: My SQL data management sytem https://community.esri.com/t5/data-management-questions/my-sql-data-management-sytem/m-p/657365#M37238 <HTML><HEAD></HEAD><BODY><P>Jane,</P><P></P><P>There is an ok discussion on this here:</P><P><A href="http://gis.stackexchange.com/questions/142323/what-are-the-limitations-of-using-mysql-with-arcgis" title="http://gis.stackexchange.com/questions/142323/what-are-the-limitations-of-using-mysql-with-arcgis">What are the limitations of using MySQL with ArcGIS? - Geographic Information Systems Stack Exchange</A></P><P></P><P>There is a short discussion of errors connecting to MySQL here: (which links to another thread)</P><P><A href="https://community.esri.com/thread/104279">Error connecting ArcMap and Mysql</A> </P><P></P><P>In general, if you are working on an enterprise geodatabase, MySQL is likely not the route you want to go.</P><P>Here is the list of supported database management systems:</P><P><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm">Supported database management systems—Help | ArcGIS for Desktop</A> </P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><UL><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-8C049D11-B5B2-4930-8235-35FDFF5EDF68" style="color: #007ac2;">ALTIBASE</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-5BD18ECA-0FFD-421C-B458-FD026F8FDF91" style="color: #007ac2;">Dameng</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-68C18823-0A4A-420E-B931-60E195CFE2C6" style="color: #007ac2;">IBM DB2</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-F5C4EDAB-C665-4433-8102-D559E13EE66B" style="color: #007ac2;">IBM Informix</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-E9058179-F058-4B1C-A2CE-77AE97BE099F" style="color: #007ac2;">Microsoft Azure SQL Database</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-7C34CC11-A846-40D7-952A-5DEC97BA6D06" style="color: #007ac2;">Microsoft SQL Server</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-708131BA-63B5-4B02-B242-E9185417555B" style="color: #007ac2;">Netezza Data Warehouse Appliance</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-F1EF7573-829E-47CE-B735-5C369CF8B99D" style="color: #007ac2;">Oracle</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-1643CA16-F20D-46CF-B661-A2B43950084E" style="color: #007ac2;">PostgreSQL</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#ESRI_SECTION1_A4171FD8DC874921BD4FF76A8AB22ED9" style="color: #007ac2;">SAP HANA</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-13F8505E-82B8-415A-9EF5-61826AEF06DF" style="color: #007ac2;">SQLite</A></LI><LI><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-support.htm#GUID-C7F0D8AE-5FBD-4716-A0C1-2C9DC33924D2" style="color: #007ac2;">Teradata Data Warehouse Appliance</A></LI></UL></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>MySQL is not listed. </P></BODY></HTML> Tue, 26 Jul 2016 18:18:20 GMT https://community.esri.com/t5/data-management-questions/my-sql-data-management-sytem/m-p/657365#M37238 AdrianWelsh 2016-07-26T18:18:20Z Re: My SQL data management sytem https://community.esri.com/t5/data-management-questions/my-sql-data-management-sytem/m-p/657366#M37239 <HTML><HEAD></HEAD><BODY><P>Thanks Adrian, your information will help answer my questions. Thanks for taking the time to post <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P><P>Jane</P></BODY></HTML> Tue, 26 Jul 2016 19:16:26 GMT https://community.esri.com/t5/data-management-questions/my-sql-data-management-sytem/m-p/657366#M37239 janehansen 2016-07-26T19:16:26Z