Likelihood to Recommend
The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
If you have an Oracle Data warehouse, then you do not actually need a different IDE for your data development. In the past, it was necessary to have TOAD or something similar, but now the new versions of SQL developer allow it to be used for most use cases. Very stable and great for analysts and DBAs.
- Crunches huge datasets
- Has versatility in functionality and grouping capabilities
- Native XML macro language is easy to master
- The platform has great visualization tools
- Performs well even with large amounts of data
- Helps finds SQL errors before runtime
- Easy to install and upgrade.
- Embedded documentation for PL/SQL functions is lacking
- Integrations with other data sources
- Not useful if you don't have strong SQL skills
While we have used SQL, 1010data is really the only industry standard product available for our use.
I think that Toad may be a better tool for actual developers but not for analysts. Notepad++ is great, and I use it and SQL Developer hand in hand with each other.
Human Resources Information System Analyst
GenworthInsurance, 1001-5000 employees
Return on Investment
- This has sped up the process of analysis.
- We can now automate process which were performed manually.
- Analysis can be performed more frequently.
- SQL Developer has proven itself invaluable in the development of more than 100 sophisticated reports for our end-users.
- Without SQL Developer, we would have to purchase some other tool for developing and executing queries against our Oracle data.
Sr. Business Intelligence Developer
Manheim - A Cox Automotive companyAutomotive, 10,001+ employees
Premium Consulting/Integration Services—
Entry-level set up fee?