How to access ODBC connections


The connections through the Windows ODBC standard (Open Database Connectivity) expand the possibilities of access to data sources based on basic connection drivers that the operating system itself or some other applications can provide

Access to certain file types, or tables in certain types of databases, may be limited depending on the data providers that a spatial data management application incorporates. But if this application also includes data providers for standard access or connections, such as ODBC and others, the range of possibilities of access, and therefore of manage, geospatial data can grow significantly

Consider, for example, the ability to access spreadsheets in Microsoft Excel as if they were tables in a geospatial database. That will not only open access to Excel files themselves, but also to any of the file formats that Excel can import or open (CSV, DBF, TXT, etc.)

The products in the Spatial Manager™ suite include, among many others, a powerful data provider to read ODBC data sources, that allows you to access tables that contain point type Features or WKB (Well-known binary) geometries

In the example you can see in this video, Spatial Manager™ for AutoCAD is used to import to an AutoCAD drawing of a city a large number of streetlights from an Excel spreadsheet, which includes the coordinates of these streetlights using a Latitude/Longitude system (CRS: WGS84 / EPSG: 4326)

We use a Block definition in the drawing to import the streetlights. This Block definition includes some Attribute definitions whose values ​​will also be imported from their corresponding data in Excel. The target drawing is defined using the CRS UTM30-ETRS89 (EPSG: 25830) so that the coordinates of the source streetlights will be transformed from EPSG 4326 to this CRS inside the import process

Almost all such steps shown in the video would apply equally in Spatial Manager Desktop™

Note: This video also discusses what the right way is to create or edit ODBC access for 32-bit and 64-bit applications, when using 64-bit operating systems

Please, watch the video:

 

Download

 

Summary
Review Date
Reviewed Item
Post
Author Rating
51star1star1star1star1star