Discussion Locked

Tool for oracle data extraction

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I currently use a tool know as SQR3 by MITI, which I believe was acquired by BRIO. I need to find a good all-around oracle tool.
Question is What tool would someone recommend to pull oracle data, link tables, create report and provide good data manipulation capabilites? example SQR3 allow me to use one instruction to unstring a deliminted field within oracle.

5 replies

by donq

Microsoft Access if you have the Oracle database driver. Access connects to ANY ODBC complient database (like DB2, Informix, Oracle, SQL-Server, etc.) and has a super report and query generator fror whatever data source!! On line Help instructs how to load the driver.

Oracle also makes a front end tool I am sure - I just don't know what it is.

by rich_johnson

Access is a great tool, But what I was looking for is a tool, that will allow me to take a field on a table an parse it to its component pieces easily. SQR allows me to do this, but my management has asked me to utilize some other tool.

by tim parkins

I use Cognos Impromptu. This tool allows for easy, GUI based joining of tables, creation of reports. It also permits an average user to easily create ad-hoc reports. It also can control access to data. It includes quite a comprehensive set of functions, some which are specific to Oracle, and others which are built into Impromptu itself.

I wouldn't use anything else now that I have gotten used to this tool.

by rich_johnson

I have a copy of this product. But what I was looking for is a tool, that will allow me to take a field on a table an parse it to its component pieces easily. SQR allows me to do this, but my management has asked me to utilize some other tool.

This discussion is closed to new replies.