import data from MySQL to ArgGIS Server

MarkWebb — Mon, 27 Jan 2014 18:11:40 GMT

I have about 100GB of data in a MySQL database that contains geospatial information. I am interested in importing the data into ArgGIS Server 10.2 that is backed by a PostgreSQL database. Is there an easy way to do this? I may receive the data in the form of CSV data from a MySQL data dump and then I want to import it into a feature class. One thought I had was to import the data via GeoEvent Processor but I wanted to see if there is an easier way.

Could someone please provide me some help or resources on how to perform this task.

Thank you,
Mark

Re: import data from MySQL to ArgGIS Server

BruceHarold — Tue, 28 Jan 2014 13:37:02 GMT

Hello Mark

The Data Interoperability extension can be used to directly read MySQL (using MariaDB libraries) and write to PostgreSQL.
100GB of data is quite a batch, you may need to break the project into chunks if you perform any manipulations on the way.

Regards

topic Re: import data from MySQL to ArgGIS Server in Data Management Questions

import data from MySQL to ArgGIS Server

Re: import data from MySQL to ArgGIS Server