How to Connect Micromine Origin to a .MDF File of MGFFT Database via ODBC

Overview

This article provides step-by-step instructions on how to connect Micromine Origin to an *.MDF file representing the Geobank for Field Teams (MGFFT) database using ODBC.

Prerequisites

• Ensure that ODBC is properly set up on your system.
• Confirm that the MGFFT database is accessible.
• You have the necessary permissions to connect to the database.

Steps to Connect Micromine Origin to MGFFT Database

Step 1: Open ODBC Import in Micromine Origin

1. Open Micromine Origin.
2. Navigate to File > Import > ODBC.
   
   
   
   
3. Click Select Datasource.

Step 2: Create a New ODBC Data Source

1. Choose Machine Data Source.
2. Click New and select either System DSN or User DSN, depending on your requirements.
3. Click Next, then select the appropriate ODBC Driver for SQL Server (e.g., ODBC Driver 17 for SQL Server).
4. Click Finish.

Step 3: Configure the Data Source

1. Name the data source (e.g., "GBFFT").
2. Connect it to the local server:
   • Geobank for Field Teams uses (LocalDB)\GBSQL2019.
3. Click Next.
   
   
   
   
4. Choose the authentication method that matches the server's settings (e.g., Windows authentication).
5. Click Next.

Step 4: Attach the Database

1. Select 'Change the default database to:' and choose the appropriate database from the list.
2. Attach the following database file: C:\ProgramData\MICROMINE\Geobank Mobile\Db\Database.mdf
3. Click Next.
4. Click Finish.
   
   

Step 5: Test and Confirm the Connection

1. Click the Test Data Source button to ensure the connection is successful.
   
   
   
   
   
   
2. If it works, you can click OK.

Step 6: Import Data into Micromine Origin

1. Locate the newly created ODBC data source.
2. Select the tables you need.
   • It is recommended that Queries/Views be used for an easier data handling experience.
3. Click Import.
4. The data should now be available in Micromine Origin.
   
   

Next Steps

Now that you have successfully connected to the MGFFT database, you can follow standard Micromine Origin instructions to utilize the data for analysis and visualization.

---

Troubleshooting Tips:

• Verify the SQL Server instance name and authentication settings if the connection fails.
• Ensure the other application does not lock the MDF file.
• Check if the ODBC driver is installed and updated to the latest version.

For further assistance, consult the Micromine Origin documentation or your IT support team.

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access