Properties of Relational Database window
Use this window to select a relational connection and a table or view as a data source by using the following options:
- Connection
-
Select the relational connection that connects to the database.
- Table or View Name
-
Once a database is configured and the connection string is successfully tested, a list of available tables and views is displayed.
Click Refresh to open or update the data in the Table Records area below.
- Table Records
-
This area provides a read-only preview of the first 50 records of the referenced table or view.
If there is a problem with either the Connection or the Table or View Name, an error icon
displays. Hovering over the icon provides more information about the specific error.
Definitions for the buttons at the bottom of this window can be found in Common Transformation Designer Buttons.