TImportSQL |
Top Previous Next |
This class can be used to import directly from a GIS enabled database. MS SQL Server, Oracle and PostgreSQL ("PostGIS") all offers storage of gis data, directly inside the database.
We have implemented it for all three and for: •.NET •32/64 bit DLL •Delphi XE7 - XE8 - 10 - 10.1 - 10.2 - 10.3 - 10.4 - 11.0.
You can reuse the majority of the shared properties from TImport with this class (CreateReport, NodeCount etc.).
This class is available with Pro only.
For .NET you need:
•GeoPackage: Microsoft.Data.Sqlite •MS SQL: Microsoft.Data.SqlClient •Oracle: Oracle.ManagedDataAccess.dll or Oracle.ManagedDataAccess.Core •PostgreSQL: Npgsql.dll and npgsql.nettopologysuite
For the MapBasic DLL version it is all compiled into the DLL.
For the VCL version you need to have UniDAC Pro installed too (version 6.4.15+ is required).
Performance
Example of importing the same dataset (Brazil, 6.5 million links), from different data sources:
Full setup: Geography, Z-levels, attribute, road name, limit and external ID.
|