Importing Metadata from an Exiting Database

Need to get metadata from existing databases into MapWorks? We’ve made it quick and easy.

Manually entering metadata from your databases into MapWorks takes time and effort. That’s why we’ve created a simple, three-step metadata import processes that will make it easier. What takes hours or days takes minutes with some simple steps.

Three simple steps for importing your existing metadata into MapWorks:

  1. Download the template spreadsheet from the Export/Import menu in the MapWorks Mapping module

  2. Fill in the information about your data structures

  3. Upload the spreadsheet to MapWorks

But we’re not done yet. To assist you with getting the metadata for the spreadsheet, we created SQL queries that you can run to automatically extract the metadata directly from your databases. Just copy the results of the query and paste them into the spreadsheet and voilà!

The video will walk you through the process, step by step.

Scripts for your DBMS Platform

3 Steps to Import your Metadata

These scripts will need to be run using an account/login that has access to the necessary metadata tables or views for the desired databases. This will vary according to the database being used. If you run into issues or are looking for similar queries for other databases, please drop us a line at answers@themapworks.com and we will see what we can do.

Also, note that these scripts will extract the data used by MapWorks starting with the 05/23/2017 MapWorks release. If new metadata is added to MapWorks (i.e. new columns added to the template spreadsheet), updated scripts will be posted here.