SQL query result set extractor
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
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. | ||
| Line 8: | Line 6: | ||
[[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. | ||
Latest revision as of 13:01, 15 August 2011
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.
[edit] Notes
Wandora features also a Database extractor that is used to transform whole database to a topic map.
