Appboard/old/sql query adapter - Revision history

imported>Jason.nicholls: /* Connection Configuration */

2014-07-17T16:36:05Z

Connection Configuration

← Older revision		Revision as of 16:36, 17 July 2014
Line 11:		Line 11:

	==Connection Configuration==		==Connection Configuration==
	The basic configuration is similar to the normal [[~~Database_Data_Adapters~~\|JDBC adapter]]. The major difference is the '''sqlQuery''' field:		The basic configuration is similar to the normal [[appboard/old/database_data_adapters\|JDBC adapter]]. The major difference is the '''sqlQuery''' field:

	[[File:JDBC_SQL_config.png]]		[[File:JDBC_SQL_config.png]]

	Next to the '''sqlQuery''' is a button that pops up a multi-line editor for the query. Your query may be entered in either place.		Next to the '''sqlQuery''' is a button that pops up a multi-line editor for the query. Your query may be entered in either place.

imported>Jason.nicholls at 16:34, 17 July 2014

2014-07-17T16:34:46Z

← Older revision		Revision as of 16:34, 17 July 2014
Line 1:		Line 1:
			{{DISPLAYTITLE:SQL Query Adapter}}
			[[Category:AppBoard old]]
	==Why use a JDBC SQL query adapter?==		==Why use a JDBC SQL query adapter?==
	When using the basic JDBC data adapter, you are presented with the visible tables and columns within those tables with little control over how they are formatted or filtered. This is quick and easy when the data exists in the form it is needed, but often there is a need for more control. Examples of situations where the JDBC SQL adapter is required include:		When using the basic JDBC data adapter, you are presented with the visible tables and columns within those tables with little control over how they are formatted or filtered. This is quick and easy when the data exists in the form it is needed, but often there is a need for more control. Examples of situations where the JDBC SQL adapter is required include:

imported>Jason.nicholls: moved SQL Query Adapter to appboard/old/sql query adapter

2014-07-17T16:34:06Z

moved SQL Query Adapter to appboard/old/sql query adapter

← Older revision	Revision as of 16:34, 17 July 2014
(No difference)

imported>Cmace: copied from internal

2012-06-26T15:44:42Z

copied from internal

New page

==Why use a JDBC SQL query adapter?==
When using the basic JDBC data adapter, you are presented with the visible tables and columns within those tables with little control over how they are formatted or filtered. This is quick and easy when the data exists in the form it is needed, but often there is a need for more control. Examples of situations where the JDBC SQL adapter is required include:

*the required data comes from a SQL stored procedure
*some SQL calculations need to be done (eg. date calculations, etc)
*complex joins need to be done in the source
*the raw data set is too large to handle in memory and you need to select a dynamic subset of that data

==Connection Configuration==
The basic configuration is similar to the normal [[Database_Data_Adapters|JDBC adapter]]. The major difference is the '''sqlQuery''' field:

[[File:JDBC_SQL_config.png]]

Next to the '''sqlQuery''' is a button that pops up a multi-line editor for the query. Your query may be entered in either place.