Azure Maps
Data Solutions

The Azure Maps REST Connection Manager supports multiple authentication methods, including OAuth Authorization Code, Subscription Key, SAS Token, Client Credentials, and Certificate-based authentication. Each mode provides fields for account IDs, tenant IDs, secrets, certificates, or token files, allowing you to securely connect based on your Azure Maps environment and organizational security requirements.

When configuring the Azure Maps REST Connection Manager, you select the service name, choose the appropriate geographic endpoint, and set your authentication mode. You can also fine‑tune proxy settings, timeout values, retry behavior, API throttling, and custom HTTP headers. These options ensure secure, reliable, and high‑performance communication with Azure Maps REST services.

The REST Source Component connects to Azure Maps through a configured REST Connection Manager and retrieves data from selected objects and endpoints. You can search for endpoints, apply filter parameters, and control how datetime values are returned. The component then outputs structured column data that can be consumed by downstream SSIS transformations or destinations.

The Columns page lets you choose which fields to return from the selected Azure Maps endpoint. You can toggle all fields, explore additional outputs using the More Fields dialog, filter JSON structures, and review performance details for each field. For optimal performance, it’s recommended to only enable the fields required by your SSIS data flow.

The REST Destination Component allows you to send data from your SSIS pipeline directly into Azure Maps REST endpoints. You select the destination object, choose the appropriate action, and map input columns to REST fields. The component manages routing, HTTP methods, and metadata updates, enabling seamless data delivery into Azure Maps services.

The component offers flexible error‑handling options, including Fail on error, Ignore error, or Redirect rows to error output. Redirected rows include detailed diagnostics such as error codes, messages, and full HTTP request/response data. This allows you to troubleshoot issues, log failures, or reprocess problematic rows without interrupting the entire data flow.

The Azure Maps JDBC Driver, found within the JDBC Driver Pack, simplifies data access by allowing any Java application, BI tool, or reporting platform to query and update Azure Maps data using standard SQL, reducing coding complexity.

You can perform SELECT, INSERT, UPDATE, DELETE, and the combined UPSERT operation to manage location data, routing information, and other map service data within Azure Maps.

The Integration Gateway utilizes its Custom Webhooks feature to listen for immediate data change messages from Azure Maps, instantly processing the event to keep data up-to-date across your connected systems.