Follow

How can I read data from my database into Strater?

Strater allows data to be read directly from several sources, including Excel XLS and XLSX, dBase DBF, and Access MDB and ACCDB files. Click File | Open and select these files directly to create maps directly from the data.
 

Other files, such as information in a database can also be read using the Microsoft ODBC connections. Surfer uses Microsoft's DataLink program to access databases.  DataLink provides support to access databases stored on a network (such as Oracle).  For information about how DataLink works, please refer to Microsoft's website and help files.  You may find this page useful for establishing the connection.

 

Note: If you will be connecting to a database, you will need to have the same version of Strater as the version of your database software. So if you are using a Microsoft Access MDB file and you have the 32-bit version of Microsoft Office, you will need the 32-bit version of Strater.

 

Method 1: Loading a Recently Loaded Database

  1. Click the File | Open command.
  2. Click the Load Database button in the Open dialog.
  3. If a database has been recently loaded, the Recent Database Connections dialog appears. You can click on the recently loaded database and click OK
  4. In the Data Link Properties dialog, verify the Connection string is correct and click OK.
  5. In the Database Tables and Fields dialog, select the table and any fields that you want to import and click the OK button. The information should be imported into the worksheet.

 

Method 2: Loading a New Database (Access example)

  1. Click the File | Open command. 
  2. Click the Load Database button in the Open dialog.
  3. If a database has been recently loaded, the Recent Database Connections dialog appears. You can click on the recently loaded database and click OK
  4. In the Data Link Properties dialog, on the Provider tab, select the appropriate driver, such as Microsoft OLE DB Provider for ODBC Drivers, and click Next.
  5. On the Connection tab, toggle Use connection string and click the Build button.
  6. In the Select Data Source dialog on the File Data Source tab, click the New button.
  7. In the Create New Data Source dialog, select the appropriate file type, such as Microsoft Access Driver (*.mdb), and click Next.
  8. In the Create New Data Source dialog, press the Browse button.
  9. In the Save As dialog, choose the directory where the database file is located. Type in a File name for the data source connection. This can be the same as the database file that you are opening, or it can be something entirely different. Click the Save button.
  10. In the Create New Data Source dialog, click the Next button.
  11. In the Create New Data Source dialog, click the Finish button.
  12. In the ODBC Microsoft Access Setup dialog, click the Select button.
  13. In the Select Database dialog, select the database file that you wish to open and click the OK button.
  14. In the ODBC Microsoft Access Setup dialog, click the OK button.
  15. In the Select Data Source dialog, click the OK button.
  16. In the ODBC Microsoft Access Setup dialog, click the OK button.
  17. In the Data Link Properties dialog, click the OK button.
  18. In the Database Tables and Fields dialog, select the table and any fields that you want to import and click the OK button. The information should be imported into a new Strater table.

 

Method 3: Loading a New Database (SQL example)

  1. Click the File | Open command.
  2. Click the Load Database button in the Open dialog.
  3. If a database has been recently loaded, the Recent Database Connections dialog appears. You can click on the recently loaded database and click OK
  4. In the Data Link Properties dialog, on the Provider tab, select the appropriate driver, such as Microsoft OLE DB Provider for for SQL Server, and click Next.
  5. On the Connection tab, click the Refresh button to refresh the list of connected SQL databases.
  6. Click the drop-down list under Select or enter a server name: and select the appropriate SQL server.
  7. Select the appropriate log on option in the Enter information to log on to the server section. Input any User name and Password, if required.
  8. Click the drop-down list under Select the database on the server and select the appropriate database.
  9. Click OK.
  10. In the Database Tables and Fields dialog, select the table and any fields that you want to import and click the OK button. The information should be imported into the worksheet.

 

Updated September 27, 2016

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.