If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > Searching for the right tool

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-12-06, 09:48
Dainis Dainis is offline
Registered User
 
Join Date: Jul 2006
Posts: 3
Searching for the right tool

I'm looking to make a report that looks like this:

creatorName1
-------------
1) FirstName LastName Email Address Picture + other fields
2) FirstName LastName Email Address Picture + other fields
3) FirstName LastName Email Address Picture + other fields
4)
.
.
.
n)

creatorName1 Stats:
Count of records by creatorName1
Count of "complete" Records by creatorName1 (where all desired fields are filled in)
Percentage of creatorName1 records complete

creatorName2
-------------
1) FirstName LastName Email Address Picture + other fields
2) FirstName LastName Email Address Picture + other fields
3) FirstName LastName Email Address Picture + other fields
4)
.
.
.
n)

creatorName2 stats:
Count of records by creatorName2
Count of "complete" Records by creatorName2 (where all desired fields are filled in)
Percentage of creatorName2 records complete
--------------------------------------------------------------

Ideally, the same tool would also allow me to import and export data in various formats (including XLS). Otherwise, I'd use another tool.

--------------------------------------------------------------
Tools I've come across:
EMS SQL Manager 2005 for MySQL
--Good early support from their tech team, support then stopped completely, then started up again...not getting the import or the report to work.

CS2
---Reverse Engineers, but the reports don't seem to provide data analysis.

Database Tour
---For some reason, it connects to the database, but does not show any data

Foxy SQL
---I can't seem to get this to work

IntelliVIEW
---Worked immediately, great support...looks like I can create the kinds of reports I need, but they only sell a 5-pack user license. They don't sell single-user licenses, so, unless the company changes their policy, we can't use their tool.

VisualMining
---Good support, haven't got the tool working yet.

NetChartsDesigner
---Haven't gotten the DB connection to work in this tool yet.
--------------------------------------------------------------

I haven't finished the configurations of all of the applications, as a few look less promising than others.

Also, I don't have a problem learning how to do these things "manually," but it would be great to have some guidance as to which books and sites you recommend. Ideally, the tools would take care of the reports and the importing/exporting...and then I could take a peek behind the scenes and gain greater understanding of what's going on in the DB and the queries.

Hope this post isn't too long for a newbie to the community, I wanted to make things clear.

Best wishes,
Dainis
Reply With Quote
  #2 (permalink)  
Old 07-12-06, 09:55
Dainis Dainis is offline
Registered User
 
Join Date: Jul 2006
Posts: 3
relevant posts/tools

Searching this forum revealed the following additional info:

Navicat
SQLYog
Free, Open Source Database Design tools
Cognos-Impromptu Web Reports
Neural networks software

...looks like I might need to try a few more packages...whew!

Cheers,
Dainis
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On