Microsoft SQL Server and Azure SQL Database Non-Spatial Reader/Writer

Licensing options for this format begin with FME Professional Edition.

Overview

The Microsoft SQL Server Non-spatial reader and writer modules provide FME with access to attribute data held in live Microsoft SQL Server database tables. This data may not necessarily have a spatial component to it.

FME provides read and write access to live MS SQL Server databases via Microsoft's ActiveX Data Objects (ADO).

Workbench Reader Overview

Click the Reader Parameters button and establish a Microsoft SQL Server Non-Spatial database connection.

FME considers a database data set to be a collection of relational tables. The tables must be defined in the mapping file before they can be read. Arbitrary where clauses and joins are fully supported.

Workbench Writer Overview

Click the Writer Parameters button and establish a Microsoft SQL Server Non-Spatial database connection.

The Microsoft SQL Server writer module stores attribute records into a live relational database. The Microsoft SQL Server writer provides the following capabilities:

• Transaction Support: The Microsoft SQL Server writer provides transaction support that eases the data loading process. Occasionally, a data load operation terminates prematurely due to data difficulties. The transaction support provides a mechanism for reloading corrected data without data loss or duplication.
• Table Creation: The Microsoft SQL Server writer uses the information within the workspace to automatically create database tables as needed.

Format Resources

Microsoft SQL Server and MS Azure SQL Database Non-Spatial

• Quick Facts

• Feature Representation

Microsoft SQL Server and MS Azure SQL Database Non-Spatial Reader

• Reader Parameters

Microsoft SQL Server and MS Azure SQL Database Non-Spatial Writer

• Writer Parameters
• User Attributes
• Format Parameters

Safe Software Inc. www.safe.com