IBM watsonx Code Assistant is a family of domain-specific AI Code Assistants & Agentic IDEs built on IBM Granite foundation models. The product portfolio provides targeted generative code recommendation, refactoring, and application modernization capabilities across enterprise domain environments, including IT automation infrastructure and mainframe enterprise systems. Note: IBM is progressively transitioning its domain-specific watsonx Code Assistant tooling into IBM Bob, a unified agentic…
N/A
Oracle SQL Developer
Score8.1 out of 10
N/A
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
I would recommend for understanding your Mainframe components not for the GenAI piece involved from just my experience. The explanations were not up to the quality we wanted but its deterministic side provided a lot of value for different members of my team. The visuals would be great. I am not sure where it currently stands
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.
It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It can automatically revamp specific parts of the COBOL code and very useful when we want to maintain the existing codebase but improve its structure. I can highlight a block of COBOL code and use Watsonx Assistant to suggest ways to simplify and optimize it.
Legacy codes, mostly written in COBOL, are cryptic and difficult to understand. Watsonx Assistant analyzes the code and provides insights into its functionalities and dependencies. A great help when working on older applications where understanding the codebase is crucial.
A step-by-step approach to modernize our applications slowly and steadily, so that we can control the process better. I don't have to change everything at once. Instead, I can focus on specific COBOL modules and automatically convert them to Java.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Inability to run multiple queries on the same database. You can only run one query on a given database.
Analytical models created from complex tables isn't accurate, and needs work.
Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Security is very important in the mainframe world. At Watsonx, we work in the trusted Z environment, which has strong security rules, stricter than those of other cloud-based solutions. My domain is primarily mainframe modernization and Watsonx Code Assistant for Z is specifically used to understand and work with COBOL, the language used majorly in mainframe environments, not any general-purpose language that used in various platforms. It understands the nuances of COBOL and Assembler specific to the Z environment, something crucial for my work.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
While manual review and adjustments are still needed, it's a 50-70% reduction in manual coding. Think about it - a project estimated to take a year is done in 4-6 months.
We've been able to introduce new features and improvements more quickly by updating our technology faster. One relevant example is we recently released an important update to our main product 45 days earlier than planned.
It has been a smart move and it's really paid off for our company. We've cut down a lot of time we used to spend doing things manually. We now spend our resources more wisely, work faster and finish projects sooner and as a result, we've reduced our development costs by 25%.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
