SQL query result set extractor - Revision history

Akivela at 10:01, 15 August 2011

2011-08-15T10:01:03Z

Akivela at 14:35, 12 August 2011

2011-08-12T14:35:48Z

Akivela at 14:34, 12 August 2011

2011-08-12T14:34:32Z

Akivela at 14:33, 12 August 2011

2011-08-12T14:33:20Z

New page

'''Notice, this feature has not been published yet!'''

SQL query result set extractor is similar to Wandora's [[SPARQL extractor]] except the query format is not SPARQL but SQL. SQL query result set extractor takes a connection URL and an SQL query, sends the query to given URL, receives a result set and transforms the result set to topics and associations. As a result, Wandora user can create topics and associations out of SQL database stored data. SQL extractor starts with a menu option '''File > Extract > Databases > SQL Extractor...'''. Selecting the menu option opens up a dialog window with two text fields. Wandora user should enter the connection URL and SQL query before successful extraction is possible.

[[Image:sql_extractor_01.gif|center]]

[[Image:sql_extractor_02.gif|center]]

← Older revision		Revision as of 10:01, 15 August 2011
Line 1:		Line 1:
−	~~'''Notice, this feature has not been published yet!'''~~
−
	SQL query result set extractor is similar to Wandora's [[SPARQL extractor]] except the query format is not SPARQL but SQL. SQL query result set extractor takes a connection URL and an SQL query, sends the query to given URL, receives a result set and transforms the result set to topics and associations. As a result, Wandora user can create topics and associations out of SQL database stored data. SQL extractor starts with a menu option '''File > Extract > Databases > SQL Extractor...'''. Selecting the menu option opens up a dialog window with two text fields. Wandora user should enter the connection URL and SQL query before successful extraction is possible. Connection URL should contain also database username and password. Read database documentation to build a valid connection URL.		SQL query result set extractor is similar to Wandora's [[SPARQL extractor]] except the query format is not SPARQL but SQL. SQL query result set extractor takes a connection URL and an SQL query, sends the query to given URL, receives a result set and transforms the result set to topics and associations. As a result, Wandora user can create topics and associations out of SQL database stored data. SQL extractor starts with a menu option '''File > Extract > Databases > SQL Extractor...'''. Selecting the menu option opens up a dialog window with two text fields. Wandora user should enter the connection URL and SQL query before successful extraction is possible. Connection URL should contain also database username and password. Read database documentation to build a valid connection URL.

← Older revision		Revision as of 14:35, 12 August 2011
Line 8:		Line 8:

	[[Image:sql_extractor_02.gif\|center]]		[[Image:sql_extractor_02.gif\|center]]
		+
		+
		+	== Notes ==
		+
		+	Wandora features also a [[Database extractor]] that is used to transform whole database to a topic map.

← Older revision		Revision as of 14:34, 12 August 2011
Line 1:		Line 1:
	'''Notice, this feature has not been published yet!'''		'''Notice, this feature has not been published yet!'''

−	SQL query result set extractor is similar to Wandora's [[SPARQL extractor]] except the query format is not SPARQL but SQL. SQL query result set extractor takes a connection URL and an SQL query, sends the query to given URL, receives a result set and transforms the result set to topics and associations. As a result, Wandora user can create topics and associations out of SQL database stored data. SQL extractor starts with a menu option '''File > Extract > Databases > SQL Extractor...'''. Selecting the menu option opens up a dialog window with two text fields. Wandora user should enter the connection URL and SQL query before successful extraction is possible.	+	SQL query result set extractor is similar to Wandora's [[SPARQL extractor]] except the query format is not SPARQL but SQL. SQL query result set extractor takes a connection URL and an SQL query, sends the query to given URL, receives a result set and transforms the result set to topics and associations. As a result, Wandora user can create topics and associations out of SQL database stored data. SQL extractor starts with a menu option '''File > Extract > Databases > SQL Extractor...'''. Selecting the menu option opens up a dialog window with two text fields. Wandora user should enter the connection URL and SQL query before successful extraction is possible. Connection URL should contain also database username and password. Read database documentation to build a valid connection URL.