GIS Tutorial
  • Home
  • Categories
    • ArcGIS
    • Global Mapper
    • Mapinfo
    • Micromine
    • QGIS
  • About
  • Contact
  • Recommended Readings
    • MAPublisher
    • Micromine
    • The Best GIS Software

Popular Posts

How to open Mapinfo TAB file on QGIS
QGIS,

How to open Mapinfo TAB file on QGIS

by adminJanuary 1, 20181 comment
How to convert polyline to polygon on QGIS 3.0
QGIS,

How to convert polyline to polygon on QGIS 3.0

by adminJune 12, 2018no comment
How to Create a GeoPackage on QGIS 3.2
QGIS,

How to Create a GeoPackage on QGIS 3.2

by adminJuly 25, 2018no comment
How to Install PostGIS on Ubuntu 18.04
Database,

How to Install PostGIS on Ubuntu 18.04

by adminAugust 5, 20185 comments

Category List

  • ArcGIS (39)
  • Database (23)
  • Free Spatial Data (2)
  • GIS Software (15)
  • Global Mapper (19)
  • Leapfrog Geo (11)
  • Mapinfo (40)
  • Micromine (27)
  • QGIS (73)
  • Surfer (2)
  • Uncategorized (2)

Follow Us

Instagram

Instagram has returned invalid data.
GIS Tutorial
  • Home
  • Categories
    • ArcGIS
    • Global Mapper
    • Mapinfo
    • Micromine
    • QGIS
  • About
  • Contact
  • Recommended Readings
    • MAPublisher
    • Micromine
    • The Best GIS Software
Micromine,

How to Link ODBC Table in Micromine

by adminDecember 22, 2019no comment
0
Shares
Share on FacebookShare on Twitter
Create odbc link micromine thumbnail

Hello everyone, welcome to the Micromine Tutorial for beginners. In the following article, I am going to show you how to create a link to an ODBC in Micromine. You will also learn how to update the link from the original source to the Micromine. In the previous article, you may read how to import the Microsoft Access tables to Micromine.

Instead of importing, we are going to create a link to the Microsoft Access table. There are some differences between importing and linking. When you are importing a table from another database such as Microsoft Access to Micromine, you will have full control of the data. You can change the column name, edit the data directly in Micromine. On the other hand, when we are linking to a table, we cannot edit the link table in Micromine. All the edits must be done in the source database.

The Benefits of Using ODBC Link in Micromine

There are some benefits when we use the ODBC Link in Micromine rather than importing the tables.

  • Supports various database systems. You can connect MySQL, MS Access, SQL Server, PostgreSQL to Micromine via ODBC
  • Support both local and cloud connection. No matter if you connect to a local or networked database, or even cloud database as long as it can connect through the ODBC.
  • Easy to manage. Since the edit and data update must be done in the source database, it is easier for us to maintain database integrity.

Steps to Create ODBC Link in Micromine

So I have created a short video on how to create ODBC Link in Micromine. Actually, I link my MS Access database to Micromine through the ODBC. As I mentioned, you may use other database systems such as PostgreSQL or MySQL. Enjoy

odbcvideo
Previous

Create Elevation Grid in Mapinfo Pro

December 14, 2019
Next

How to Export Mapinfo Table to LeapFrog Geo

December 25, 2019

Leave a Reply Cancel reply

Trending

  • How to Create Catchment Area on ArcGIS

    How to Create Catchment Area on ArcGIS

    2 months ago
  • Import Elevation Grid on Leapfrog Geo 6.0

    Import Elevation Grid on Leapfrog Geo 6.0

    2 months ago
  • How to Clip Raster Against Polygon in QGIS

    How to Clip Raster Against Polygon in QGIS

    2 months ago
  • How to Extract Points from Polygon in MapInfo Professional

    How to Extract Points from Polygon in MapInfo Professional

    3 months ago

Follow Us

Ads




Ads




Categories

  • ArcGIS (39)
  • Database (23)
  • Free Spatial Data (2)
  • GIS Software (15)
  • Global Mapper (19)
  • Leapfrog Geo (11)
  • Mapinfo (40)
  • Micromine (27)
  • QGIS (73)
  • Surfer (2)
  • Uncategorized (2)