User Tools

Site Tools


projects:querybuilder

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
projects:querybuilder [2011/01/21 15:18] rlunaroprojects:querybuilder [2022/12/02 22:02] (current) – external edit 127.0.0.1
Line 5: Line 5:
 The objective is to replace the query designer of access with a similar tool. This is because access have known liminations with the size of the MDB files that make it inadequate for running enteprise-size or huge databases.  The objective is to replace the query designer of access with a similar tool. This is because access have known liminations with the size of the MDB files that make it inadequate for running enteprise-size or huge databases. 
  
 +===== Conclusions =====
  
-===== My notes =====+I have to conclude that there is no winner at all. The tool I was searching need to allow the migration of data between databases, permit to connect with existing Access databases and allow to store the results of a query in a new table. 
  
-I've search in codeplex, google and sourceforge for the most suitable products. And in the next section I've put those that more or less appear to be "active", to satisfy the needs of users without great knowledge of technology and focused in getting results instead of getting an sql made. +This last point, the storing of the data in a new query, where the most disapointing, because I didn't found a tool that could achieve this. This could be because a match between the different data types is needed and no one can guarantee that it will work in any case.  
 + 
 +Solutions??? My boss have told me that the solution should come from an [[http://en.wikipedia.org/wiki/Extract,_transform,_load|ETL tool]] (Extraction, Transform and Load). I will look over three possible tools:  
 + 
 +  * Power Center 
 +  * Data Stage 
 +  * [[http://kettle.pentaho.com/|Pentaho Kettle Project]] 
 + 
 + 
 +===== Proceedings ===== 
 + 
 +To find out what whould be the correct tools, I've search in codeplex, google and sourceforge for the most suitable products. And in the next section I've put those that more or less appear to be "active", to satisfy the needs of users without great knowledge of technology and focused in getting results instead of getting an sql made. 
  
 ==== http://www.activequerybuilder.com ==== ==== http://www.activequerybuilder.com ====
Line 23: Line 35:
  
   * **Webpage:** http://www.basenow.com   * **Webpage:** http://www.basenow.com
-  * **Price:**+  * **Price:** starting from 49$, profesional edition 99$
  
 **My Impression** **My Impression**
Line 36: Line 48:
  
   * **Webpage:** http://www.dbqwikedit.com   * **Webpage:** http://www.dbqwikedit.com
-  * **Price:**+  * **Price:** 40$
  
 **My Impression** **My Impression**
Line 52: Line 64:
 ==== FlySpeed SQL Query ==== ==== FlySpeed SQL Query ====
  
-  * **Webpage:**  +  * **Webpage:** http://www.activedbsoft.com/overview-querytool.html 
-  * **Price:**+  * **Price:** 22euros
  
 **My Impression** **My Impression**
Line 66: Line 78:
  
 It doesn't allow to launch batch jobs.  It doesn't allow to launch batch jobs. 
 +
 +==== http://www.querytool.com ====
 +
 +  * **Webpage:** http://www.querytool.com
 +  * **Price:** 180 euros
 +
 +**My Impression**
 +
 +I were unable to connect to the oracle database. Probably a bad design in the connection interface make it difficult to achieve. 
 +
 +Location of tables very quickly, you don't have to wait until the list is filled. 
 +
 +Can't save the sql into a text file, and cannot store the result table into a new table (for make further queries). 
 +
 +
 +==== http://sourceforge.net/projects/sqleonardo/ ====
 +
 +  * **Webpage:** http://sourceforge.net/projects/sqleonardo/
 +  * **Price:** free
 +
 +**My Impression**
 +
 +It's a java application that uses the power of JDBC to connect to many databases and ease the creation of queries. 
 +
 +However, it is somewhat difficult to install -you have to install the jar file and provide access to it across the system- and you have to provide the necessary drivers for the application. 
 +
 +It takes some time to create a query, but finally it does the job. 
 +
 +It doesn't have support for jobs. 
  
 ==== http://www.sqlquerybuilder.com ==== ==== http://www.sqlquerybuilder.com ====
Line 90: Line 131:
  
  
-===== Products I am evaluating =====+==== http://sourceforge.net/projects/sqlmaster/ ====
  
 +  * **Webpage:** http://sourceforge.net/projects/sqlmaster/
 +  * **Price:** Free
  
-http://sourceforge.net/projects/sqlmaster/files/+**My Impression**
  
 +It only works with mysql. Furthermore, the query builder doesn't work very well...
  
-http://sourceforge.net/projects/vsqlbuilder/ 
  
-http://sourceforge.net/projects/sqleonardo/+===== Products I am evaluating =====
  
-http://www.querytool.com 
  
-http://www.originlab.com/index.aspx?go=Products/Origin/ImportingData/DatabaseAccess 
  
-http://www.sqlquerybuilder.com+ 
 +http://sourceforge.net/projects/vsqlbuilder/  - discontinued, use instead pgAdmin Query Builder. It's only for postgres.  
 + 
 + 
 +http://www.originlab.com/index.aspx?go=Products/Origin/ImportingData/DatabaseAccess - I've had a look at it and it seems to be more of the same.
  
 Curious:  Curious: 
Line 111: Line 156:
  
  
-===== And the winner is... ===== 
- 
-No winner yet.  
  
  
projects/querybuilder.1295619487.txt.gz · Last modified: 2022/12/02 22:02 (external edit)