Terminology
Understanding DPL Studio Terminmology
Connection
A Connection contains the configuration settings used together with a connector to allow DPL Studio to access data from a data source. Connections help establish communication between DPL Studio and external data sources.
Connector
A Connector is a software component that enables DPL Studio to communicate directly with a specific data source.
Examples of supported data sources include:
- Oracle Database
- Microsoft SQL Server
- Microsoft Access
- XML Files
- Text Files
The connector acts as a bridge between DPL Studio and the external system.
Query Types
A Query represents a process that generates tabular data within DPL Studio. All query types are handled similarly inside DPL Studio, even though they serve different purposes.
The main query types are:
- Standard Query
- Aggregation Query
- Transform Query