Oracle SQL Developer vs. Sisense

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.

Incentivized

I believe Sisense is perfectly suited for any organization of any size that have access to the proper resources, as the tool is very expensive. The data connectors come in all shapes and sizes out of the box, which allows a great deal of data control within the ElastiCubes. Additionally, while the platform only runs on Windows platforms, the web application can be accessed on any client: mobile, Apple, Windows, etc. This allows a much more flexible user experience, resulting in data and dashboards reaching further than any other tool.

Incentivized

• 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.

Incentivized

• Customization - lots of supported and community plugins available. Users can also adjust the look and feel through JavaScript.
• Innovation - Sisense is continuing to push the envelope by developing new features through Sisense Labs.
• Customer support - the commitment to excellent customer service and ensuring organizations get the most out of their investment.

Incentivized

• 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.

Incentivized

• The usability of the application on mobile devices needs some improvement, especially navigation and filtering.
• Dashboards that are created by multiple users can be a bit of a hassle to share by Admins.
• If you need to embed dashboards into your website, you are require to buy a license separate from the user and platform license. This is a norm on most BI visualization tools, but Sisense can seem a bit on the high side, cost-wide.

We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.

Incentivized

I think the business and myself as a user has come to rely on SiSense as a dashboarding and quick ad-hoc reporting tool. I am hoping to integrate SiSense dashboards into more parts of the business in the future. We have reduced our report turn-around time for the most part from hours/days to minutes and in some cases almost the speed of thought. Reports are also easier on the eye and more easily distributed. I would also like to say that the support and professionalism from the SiSense team has been excellent.

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.

Incentivized

New V5 is ground floor of an exciting collection of possibilities. Weekly Sisense developers come up with new functionality that they share with us in their forums. The move to HTML5 has been pleasing in that widgets auto size themselves into appropriate forms in the board but everyone of them can be popped out to full page size to be looked at in more detail

There are very few situations when there is unexpected downtime. Mostly during development, new dashboard implementation and during upgrades. other then that there were very few crashes.

SiSense is usually performing better then other solutions even if going for complex reports/dashboards(of course within reasonable frames). I haven't noticed any bad influence on other systems, usually if something happens it stays within SiSense.

Large user community support

Incentivized

SiSense's support ninjas are very knowledgeable and are exceptionally responsive. So far, all of the issues we ran into were resolved within minimum time. My sense of dealing with the support staff at SiSense is that they are very focused on not just answering your immediate question, but also to delve into the cause of the matter.

Easy and free training that allowed us quickly understand basics in SiSense and start using them. More advanced features requires some browsing through SiSense forums, but there is always support to help, and SiSense support is one of the best whith which I worked so far.

Many examples, videos and scenarios which you try on your own right away. This combined with in-person training gives you enough to utilize most of SiSense's power.

Just download and uncompress!

Incentivized

Remember to migrate the plugins. The documentation however is pretty straight forward.

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.

Incentivized

1) Easy to use, really, there is nothing too much to say. The set up is easy and not confusing. You can use it internally or externally.

2) Customer Service, having spoken to various product reps from similar industry. Sisense rep provides you with the best support to get started, and it is really appreciated.

Product is quite easily scalable. The whole installation can be easily moved to stronger machine if needed.

• It gives 100% return on investment as it is free of cost.
• No need to have multiple tools for each database
• Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.

Incentivized

• Report development time is reduced from 2~3 days to 2~3 hours.
• Report querying time is improved from 0.5~10 mins to 2~30 seconds.
• A 2-staff team delivers 10 times the BI output that we did on the old system.
• We were able to deliver BI and data analysis for all business functions instead of a very limited group of users