Using the Premium ADO.NET Source Component

The Premium ADO.NET Source Component utilizes the existing ADO.NET Connection Manager to facilitate reading from databases.

General Page

The General Page of the Premium ADO.NET Source Component allows you to specify the general settings of the component.

Premium ADO.NET Source - General Page

Connection Manager

The Premium ADO.NET Source Component requires an ADO.NET connection manager. The component currently supports the following data providers:

  • SQL Client Data Provider
  • ODBC Data Provider
  • OLE DB Data Providers
  • Oracle Client Data Provider
  • ODP.NET Managed and Unmanaged
  • MySQL Client Data Provider
Data Source

The Data Source drop-down displays a list of available tables and views from the database specified in the Connection Manager. Selecting a table here will automatically populate the Command property. This is a quick and easy way to generate a basic select statement for reading from the database.

Command

The Command textbox is the command text that will be executed over the Connection Manager to read data from the database. A basic select statement can easily be generated by selecting a table or view from the Data Source property. You can then further customize the command to your liking to perform powerful queries.

Import

Loads SQL from a file into the Command property.

Export

Save the SQL in the Command property to a file.

Preview

Opens a preview dialog that shows the result (up to the first 200 rows) of executing the text in the Command property over the specified Connection Manager. Note if the command makes any changes to the database the changes will appear in the preview but are rolled back immediately. Changes to the database will only commit at runtime.

Columns Page

The Columns page of the ADO.NET Source Component shows you the available columns based on the settings in the General page.

Premium ADO.NET Source - Columns Page

On the top left of the grid, you can see a checkbox, which can be used to toggle the selection of all available ADO.NET fields. This is a productive way to check or uncheck all available fields. 

NOTE:  As a general best practice, you should only select the ADO.NET fields that are needed for the downstream pipeline components. Do this in the columns page using the checkboxes or in the General page by removing the column from the command entirely.