Database Management: Comprehensive Admin Tools; Business Intelligence; Integrations/Migrations

Business/IT alignment
Data analysis
Database Management Systems
IT architecture
Knowledge management applications
Online transaction processing
Systems management software
Permit me to preface this communication with accolades to the TechTarget team for providing this forum. I am certain it will prove invaluable for IT and business professionals. I would like to poll the members regarding their respective takes of the following database management initiatives targeted for our organization: We are in a mixed and disparate RDBMS environment housing our core processor and financial-specific systems, as well as our DMS, CRM, Call Center, Contacts, Accounting, and proprietary Data Warehouse (to name a few). 1. What is the recommended set of database administration tools to manage DB2, Oracle, Sybase, and SQL platforms? 2. What is the best approach to extending/replacing our proprietary data warehouse and reporting solutions to an enterprise-oriented platform-independent business intelligence solution? 3. What are the best practices and required skill set for data integrations and migrations of same? Any insight regarding the above would be greatly appreciated. At this level of generality, we are seeking a high-level overview or response as to best guide our efforts. Thanks in advance, ericggordon

Answer Wiki

Thanks. We'll let you know when a new response is added.


I would have said Platinum but they got bought out by Computer Associates. So I would suggest Quest Technology or BMC. I would swing towards Quest most of the Platinum devolopment and support ended up working for them. Each company has toolsets that allow you to manage several diffent DBMS from one console. I am not sure if either one covers the range you have listed here (in one tool).

As for questions 2 and 3. I am guessing you want to look for a bigger better BI solution. Not sure I can help you on that one. I am very Oracle centric. So I may point you in the wrong direction ;-). If your planning on moving data to a different DBMS check your migration path options you want to make sure you know how long it takes to move data around it may take more than once in some cases. Make sure you have user (this can mean develepment/QA also) buy in at all stages if you are going to replace they way it looks to the end user. Keep training plans in mind when changing architecture as well. See if you can setup some kind of bundle with the vendor when talking of purchases. Remember they are hungry for businsess and will sometimes throw stuff in at purchase time rather than after the initial outlay.

Good luck
Frank P.

Discuss This Question: 4  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • 17051966
    Question 1) I can speak only for Oracle since that is my expertise. I used DBArtisan for about eight months as a DBA tool. Other than that I do not use any tools. I write my own scripts or get them from Oracle MetaLink or other websites and customize them for my use. This practice allows me to delve into the inernal level of Oracle and get a better grasp of things happening there. Also, since I do not depend on any specific third party tools, my scripts remain portable across companies so that I can continue to function even when a specific tool is not available with a new company. I used this principle in my most recent book on database performance tuning and optimization to make my book independent of any third party tools. With Oracle 9i and even with 8i, Oracle continues to automate the database administration process to allow DBAs more time for handling more involved problems. I strongly recommend using Oracle's own tools and utilities. Also, Oracle Tech Support staff are extremely helpful and professional in solving customers' problems. For the last ten years I have consistently received superb services from them. Question 2) This question is too vague and open ended for me to provide any precise response. Question 3) This is almost as vague as # 2. In general, you will need analysts for data modeling and logical database design, developers and DBAs for the actual implementation of the design at the physical level, and DBAs for the adiministration of the database. The design of a data warehouse is very different from that of an OLTP database. For example, denormalization is used in DW while one strives for 3NFs in an OLTP database. Ensure that your data modelers are familiar with DW design issues. You can contact me directly if you need more information. Good luck on your venture. Sitansu S. Mittra
    0 pointsBadges:
  • RichardG12
    I would agree with BMC products. They seem to have the best combination of utilities for managing the environment. They are not necessarily the best products but, in my opinion, have the best suite of products, if you want to stay with one vendor. Don't exclude looking at the IBM products for DB2. They have come a long way in terms of performance. Unfortunately, I have nothing to add on your other questions.
    0 pointsBadges:
  • Scottism
    We have a simlar environment and chose to use Embarcadero's tools. We use DBArtisan for managment, Performance Center for Performance Monitoring and Change Manager for migrations. We've been using them quite successfully over the past year.
    0 pointsBadges:
  • Pztrickmcneese
    1. Embarcadero makes a fine suite of tools for all your current platforms. You will have to but distinct versions by platforms but will have the same interface and similar tools for all. 2. Under your current scenario platform independance is virtually impossible. Were it me, I would concentrate on reducing the number of datbase vendors as the first step. 3. You will reuired very talented multi-discpline DBA's and SQL coders to accomplish your goals.
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: