Db2 Data Studio For Mac
- It works with Oracle, DB2 for LUW, DB2 for iSeries, Microsoft SQL Server, MySQL, Sybase, Informix, Apache Derby and PostgreSQL on Mac OS X, Windows, Linux, Solaris and Java. Aqua Data Studio.
- “Aqua Data Studio is a single tool that manages all of our databases. We can edit SQL, and extract and visualize data all from within Aqua Data Studio only.” Kuiran Du, Business Analyst, Huawei Technologies Co., Ltd. (Large Enterprise, Telecommunications Equipment, Bahrain) “We could not perform our job function without Aqua Data Studio.
Further Data Studio can directly deploy the files to the web server and even configure the JDBC driver on it to connect to the DB2 database where the procedure or query lives. Read more about the web service builder in Chapter 10 of the Getting Started With Data Studio for DB2 e-Book.
Transforms database management
IBM Data Studio provides an integrated, modular environment to enable database development and administration of IBM Db2® for Linux®, UNIX and Microsoft Windows. It also offers collaborative database development tools for IBM Db2 for z/OS®, IBM Db2 for i, IBM Informix® and IBM Big SQL.
Benefits
Manages multiple databases
Enables you to easily create and manage heterogeneous database environments. Provides a deployment manager to simplify enterprise database deployments.
Streamlines database development
Uses advanced query validation, object management and system deployment features to streamline database development.
Enhances collaboration
Provides an integrated environment and shared platform to improve IT collaboration.
Supports Big SQL
Provides Big SQL connection and parser support using specific Big SQL grammar.
Accelerate database development
Empower developers to write high-quality code rapidly using optimized frameworks. Reduce time to market and enhance compliance by modeling data assets and automating database design processes.
Enhance cross-team collaboration
Collaborate using a development process that spans database, application and data access requirements. Increase data quality and consistency by using shared policies, models and methods. Improve productivity with a shared solution across roles.
Enable advanced database testing
Reduce the risks, costs and time associated with enterprise database testing processes, and improve your ability to meet service level agreements. Add rigorous testing capability by capturing and replaying production workloads. Enhance your ability to test upgrades and migrations, and implement tuning changes.
Improve database development and management
Centralize database health monitoring and job management. Use change management capabilities to alter objects, permissions and dependencies. Tune queries for best performance, and automate Db2 migration projects. Supports native encryption for Db2 10.5 FP5 and later versions. Benefit from an Eclipse SDK that enables shell sharing with IBM InfoSphere® Data Architect, Rational Application Developer and Rational Developer for z/OS systems.
