dbForge Studio (Edge) vs. IBM InfoSphere Information Server

This tool is useful for small and large IT departments and associated data analysts that perform direct database functions such as DBA tasks or extracting/importing data. Non-technical staff members would not benefit from this tool as much as the functions are detailed and technical. However, automation engineers will find this tool very open for automation, and can generate the scripting code for any of its functions.

Incentivized

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

• Connection manager (we use it through ssh tunnels) works effortlessly.
• Great sync tools for both database schemas and data.
• Storing code snippets to be used when needed.
• Nice code suggestions while typing queries.
• Usually does very well with storing your session and opening all of your sql tabs when opening the apps next time.
• Does very well when executing large sql files (without opening the files into the application that is).
• Pretty good debugging help when a problem occurs in executing a query or a files with multiple queries.

Incentivized

• IIS best for ETL ,not ELT , and many and diffrent source systems.
• It also can process big data , unstuctured data
• It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

Incentivized

• The ability to parameterize searches more would be advantageous. For example, being able to specify to only look for certain columns, certain data type changes, etc.
• The output reports from dbForge are very plain and could contain more detail, and perhaps be structured more like a pivot table form Excel

Incentivized

• I would be nice to have a new web development environment for DataStage.
• Connectivity Packs such as Pack for SAP Application are a little pricey.
• It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Incentivized

• Scale of implementation
• IBM techsupport

Incentivized

dbForge Studio (Edge) has a great UI and it's versatile, but it still has some glitches. Its multiple database support makes it possible to stick with only one UI to handle different RDBM systems, even though you have to redefine user credentials for each new connection (no copying/cloning feature for database connections). The Edit View and diagramming features also could be improved.

Although experience here is limited, as only one question has been asked and answered promptly, the registration and licensing process was very smooth and professional. There are forums online that discuss dbForge issues, as well as a Facts and Questions section on dbForge's website, so product support does seem to exist if needed.

Incentivized

Before choosing dbForge Studio I evaluated at least a dozen tools, especially on the Visual Query Builder function. For now, I have identified only one product that has a better Visual Query Builder than dbForge Studio. This other product also manages UNIONs, while dbStudio still doesn't do it visually. However, the better alternative product is enormously slower in operations and less feature-rich than DbForge Studio

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

• Saved a TON of time when looking at massive amounts of parent/child data by allowing us to just use the master-detail browser.
• Very little training time needed for employees that are already used to using SQL Management Studio. This is a proper Windows UI application.
• Very cost effective to purchase the standard edition for every employee that needs it, but the free edition does most of what they need too!

Incentivized

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.