developer.* Blogs - Connecting to Oracle Databases - Comments

More qualities?

Mario Van Damme — Mon, 26 Jun 2006 08:03:28 -0700

Apparently I have a quality I wasn't even aware of : "mind reading". I'll see what I can do with that in future :-)

I regularly hear people saying that they don't do their reporting on native Oracle databases, but rather on SQL Server databases. I guess the main drive for this is:
- The business reporting features are good
- Oracle experts are harder to find than SQL Server experts.

Glad to have been of help and good luck with your Oracle project.

Best regards,

Mario.

Oracle, mind-reader

Donna L Davis — Fri, 23 Jun 2006 10:28:54 -0700

The reason I haven't been able to post lately on d.* is because I have been wrestling with this very issue! Thanks, Mario-the-mind-reader. We are going live with an Oracle based third-party system on Monday and I have to make sure several interfaces to other systems don't break. I worked with Oracle several years ago, but since we are a SQL Server shop, I had long ago reused those brain cells. This week I bought "Oracle for Dummies". We are in the process of setting up connectivity from SQL Server 2005 to Oracle so we can dump data (nightly) into a reporting database on SQL Server so that we can have our own familiar playground for creating views, as well as reduce contention for reporting.

Connecting to Oracle Databases

Mario Van Damme — Fri, 23 Jun 2006 08:00:05 -0700

From time to time, many of us are confronted with Oracle databases. Whether it's for capturing the database schema, to exchange data, to write a database application, etc. This blog entry will give you some tips on how to do this without a lot of suffering.