DBArtisan from Embarcadero Technologies (acquired by Idera) is a database administration toolset.
N/A
Oracle Warehouse Builder
Score8.7 out of 10
N/A
Oracle Warehouse Builder (OWB) is a data-warehousing centered data integration solution, from Oracle. It offers basic ETL functionality for building a simple data warehouse, as well as advanced ETL functionality supporting enterprise data integration projects, along with connectivity for Oracle and SAP applications.
N/A
Pricing
DBArtisan
Oracle Warehouse Builder
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
DBArtisan
Oracle Warehouse Builder
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Features
DBArtisan
Oracle Warehouse Builder
Database Development
Comparison of Database Development features of DBArtisan and Oracle Warehouse Builder
Feature
DBArtisan
8.5
3 Ratings
0% below category average
Oracle Warehouse Builder
-
Ratings
Version control tools
8.02 Ratings
00 Ratings
Test data generation
8.83 Ratings
00 Ratings
Performance optimization tools
8.02 Ratings
00 Ratings
Schema maintenance
9.83 Ratings
00 Ratings
Database change management
8.02 Ratings
00 Ratings
Database Administration
Comparison of Database Administration features of DBArtisan and Oracle Warehouse Builder
Feature
DBArtisan
8.0
3 Ratings
0% below category average
Oracle Warehouse Builder
-
Ratings
User management
7.93 Ratings
00 Ratings
Database security
8.03 Ratings
00 Ratings
Database status reporting
8.02 Ratings
00 Ratings
Change management
8.02 Ratings
00 Ratings
Data Source Connection
Comparison of Data Source Connection features of DBArtisan and Oracle Warehouse Builder
Feature
DBArtisan
-
Ratings
Oracle Warehouse Builder
9.5
5 Ratings
13% above category average
Connect to traditional data sources
00 Ratings
10.05 Ratings
Connecto to Big Data and NoSQL
00 Ratings
9.02 Ratings
Data Transformations
Comparison of Data Transformations features of DBArtisan and Oracle Warehouse Builder
Feature
DBArtisan
-
Ratings
Oracle Warehouse Builder
10.0
5 Ratings
21% above category average
Simple transformations
00 Ratings
10.05 Ratings
Complex transformations
00 Ratings
10.04 Ratings
Data Modeling
Comparison of Data Modeling features of DBArtisan and Oracle Warehouse Builder
Feature
DBArtisan
-
Ratings
Oracle Warehouse Builder
8.2
5 Ratings
3% above category average
Data model creation
00 Ratings
10.04 Ratings
Metadata management
00 Ratings
6.04 Ratings
Business rules and workflow
00 Ratings
9.04 Ratings
Collaboration
00 Ratings
8.94 Ratings
Testing and debugging
00 Ratings
7.04 Ratings
Data Governance
Comparison of Data Governance features of DBArtisan and Oracle Warehouse Builder
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
The best place for Oracle Warehouse Builder is at the business IT level. It's not suited for business-level users. They are easy confused. One way to reduce the confusion for the developers is to set up the workspaces based on the requirements that are discovered in design sessions. Once this is complete, the implementation of Oracle Warehouse Builder can take flight and be successful.
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
User interface is easy to use, and in some ways better than Toad. The left hand side shows all databases, and you can drill down to instance, storage, schemas, tablespaces, and performance views. The right hand side displays the details of the selected object.
This is the best tool if you want to manage multiple RDBMS platforms in a single tool using the same familiar interface. Other third party tools can do it also, but it's not nearly as integrated as this, and may require additional plug-ins installed. DBArtisan excels at this, and can perform cross-platform data migrations easily.
It has different DB analysts, which can help diagnose issues with performance, optimize storage, detect fragmentation, and plan for capacity growth. For almost any action you want to take, you can generate the DDL for preview, and/or schedule it to run at a specific time.
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
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
What I noticed is that sometimes OWB doesn't generate the best SQL in the package especially when there are a high number of source tables in the ETL. It would be nice if ETL developers were allowed to update the generated packages in the database directly.
Another thing - moving OWB ETLs from one database to another one could be easier - for example it would be nice to just copy the generated packages from one database to the other one without doing the deployment of these ETLs through OWB.
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
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
It has a positive ROI on our organization. It's better than OEM and SQL Developer. Although the license could be expensive, it is perfect for large organizations, especially with multiple RDBMS platforms.
Most features are redundant between DBArtisan and Toad. I would not recommend using both if you already own one of them. Just download the trial for the one you're not using, and see what works best for your organization.
DBArtisan is great for DBAs and would be my personal preference. Toad is good for developers and DBAs alike but I feel like sometimes the interface is too busy and too clumsy to use.
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