SSIS Components for DigitalOcean

Build 20.0.7587

Data Model

The CData SSIS Components for DigitalOcean models entities in the DigitalOcean API as tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

Using Collaborative Query Processing

The component offloads as much of the SELECT statement processing as possible to the DigitalOcean APIs and then processes the rest of the query within the component. The following sections document API limitations and requirements. See SupportEnhancedSQL for more information on how the component circumvents API limitations with in-memory client-side processing.

Views

Views are tables that cannot be modified. Typically, read-only data are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587