2. Enter the following information:
Name: dsetOrders
Data Source: dsDerbySampleDatabase
Data Set Type: SQL Select Query
Notice that under the Data Set Type, there is an additional option to use
an SQL Stored Procedure. This was not an option with the other Data
Set. This is only applicable to Data Sources that are DBMS-based. As our
example??”Derby Database??”does not have any stored procedures, this
doesn't do us any good. We can ignore this and click Next.
3. The next screen is the SQL Editor. Here, you can play around with the
left-hand tree view, to see the available tables and columns in our database.
You can either drag tables or columns over to the text editor on the
right-hand side, or you can move the cursor someplace in the text editor
and double-click on the table or column you want to add. In doing so, you
automatically put in the fully-qualified path to that table or column. You
can also filter down to see tables in particular schemas, in databases where
you have access to more than one. Additionally, you can type in a filter
to limit based on table name. A word of caution: In my experience this is
case sensitive, or "order" is not the same as "ORDER." Put the following
information in the Filter data and click on Apply Filter:
Schema: CLASSICMODELS
Filter: ORDER
Type: Table
4.
Pages:
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104