What users are saying about
192 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
33 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Likelihood to Recommend

SSIS

  • SSIS is particularly well suited for jobs that need to be consistent, repeatable, and error managed.
  • Ongoing extract, transform, load [ETL] jobs that are scheduled or manual.
  • One-time ETL with complex datasets.
  • Migrations of large datasets.
SSIS is not well suited for small or simple datasets that can be copied or exported safely to flat files for import. It is possible to do this but would generally take longer to build in SSIS unless there was a good reason to .remove manual handling of the data in transport or the action needed to be testable/repeatable.
No photo available

TIBCO Jaspersoft Community Edition

Any scenario where you need to reach back into TIBCO support is something I would highly avoid. Most responses at the second round get you pointed to engaging their professional services. The general mentality seems to be "since our product acquisition cost is low, why don't you engage PS to get the value you need" If you are looking at enterprise scenarios, I would highly recommend looking at other more established products.
No photo available

Feature Rating Comparison

Data Source Connection

SSIS
8.6
TIBCO Jaspersoft Community Edition
Connect to traditional data sources
SSIS
9.6
TIBCO Jaspersoft Community Edition
Connecto to Big Data and NoSQL
SSIS
7.6
TIBCO Jaspersoft Community Edition

Data Transformations

SSIS
9.0
TIBCO Jaspersoft Community Edition
Simple transformations
SSIS
9.9
TIBCO Jaspersoft Community Edition
Complex transformations
SSIS
8.1
TIBCO Jaspersoft Community Edition

Data Modeling

SSIS
7.0
TIBCO Jaspersoft Community Edition
Data model creation
SSIS
7.1
TIBCO Jaspersoft Community Edition
Metadata management
SSIS
6.2
TIBCO Jaspersoft Community Edition
Business rules and workflow
SSIS
8.2
TIBCO Jaspersoft Community Edition
Collaboration
SSIS
6.1
TIBCO Jaspersoft Community Edition
Testing and debugging
SSIS
7.4
TIBCO Jaspersoft Community Edition

Data Governance

SSIS
8.0
TIBCO Jaspersoft Community Edition
Integration with data quality tools
SSIS
8.5
TIBCO Jaspersoft Community Edition
Integration with MDM tools
SSIS
7.4
TIBCO Jaspersoft Community Edition

BI Standard Reporting

SSIS
TIBCO Jaspersoft Community Edition
7.8
Pixel Perfect reports
SSIS
TIBCO Jaspersoft Community Edition
8.7
Customizable dashboards
SSIS
TIBCO Jaspersoft Community Edition
7.1
Report Formatting Templates
SSIS
TIBCO Jaspersoft Community Edition
7.5

Ad-hoc Reporting

SSIS
TIBCO Jaspersoft Community Edition
6.7
Drill-down analysis
SSIS
TIBCO Jaspersoft Community Edition
6.6
Formatting capabilities
SSIS
TIBCO Jaspersoft Community Edition
5.9
Integration with R or other statistical packages
SSIS
TIBCO Jaspersoft Community Edition
7.0
Report sharing and collaboration
SSIS
TIBCO Jaspersoft Community Edition
7.3

Report Output and Scheduling

SSIS
TIBCO Jaspersoft Community Edition
8.2
Publish to Web
SSIS
TIBCO Jaspersoft Community Edition
8.6
Publish to PDF
SSIS
TIBCO Jaspersoft Community Edition
9.1
Report Versioning
SSIS
TIBCO Jaspersoft Community Edition
6.7
Report Delivery Scheduling
SSIS
TIBCO Jaspersoft Community Edition
8.7
Delivery to Remote Servers
SSIS
TIBCO Jaspersoft Community Edition
8.0

Data Discovery and Visualization

SSIS
TIBCO Jaspersoft Community Edition
6.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
SSIS
TIBCO Jaspersoft Community Edition
7.4
Location Analytics / Geographic Visualization
SSIS
TIBCO Jaspersoft Community Edition
5.1
Predictive Analytics
SSIS
TIBCO Jaspersoft Community Edition
8.0

Access Control and Security

SSIS
TIBCO Jaspersoft Community Edition
7.6
Multi-User Support (named login)
SSIS
TIBCO Jaspersoft Community Edition
7.6
Role-Based Security Model
SSIS
TIBCO Jaspersoft Community Edition
7.5
Multiple Access Permission Levels (Create, Read, Delete)
SSIS
TIBCO Jaspersoft Community Edition
8.0
Single Sign-On (SSO)
SSIS
TIBCO Jaspersoft Community Edition
7.5

Mobile Capabilities

SSIS
TIBCO Jaspersoft Community Edition
5.9
Responsive Design for Web Access
SSIS
TIBCO Jaspersoft Community Edition
7.8
Dedicated iOS Application
SSIS
TIBCO Jaspersoft Community Edition
5.4
Dedicated Android Application
SSIS
TIBCO Jaspersoft Community Edition
5.1
Dashboard / Report / Visualization Interactivity on Mobile
SSIS
TIBCO Jaspersoft Community Edition
5.2

Application Program Interfaces (APIs) / Embedding

SSIS
TIBCO Jaspersoft Community Edition
7.0
REST API
SSIS
TIBCO Jaspersoft Community Edition
7.2
Javascript API
SSIS
TIBCO Jaspersoft Community Edition
7.0
iFrames
SSIS
TIBCO Jaspersoft Community Edition
7.2
Java API
SSIS
TIBCO Jaspersoft Community Edition
7.1
Themeable User Interface (UI)
SSIS
TIBCO Jaspersoft Community Edition
5.9
Customizable Platform (Open Source)
SSIS
TIBCO Jaspersoft Community Edition
7.8

Pros

SSIS

  • SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
  • It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
  • When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.
No photo available

TIBCO Jaspersoft Community Edition

  • Very intuitive tool - An Advanced reporting user can figure out in a day on the end to end operations.
  • Easy customization - Simple changes in UI makes it less headache for the end user who maintains the tool. Being an open source product (offers Jasper web services) makes a lot developer friendly compared to SSRS, Cognos etc.
  • Easy Connectivity - Can connect to any data source (can connect to multiple data sources) for a single report - can be customized.
  • Community - A very strong community available online, videos - on basic how to questions, also provides assistance to use case specific scenarios.
  • Ease of Reporting - Can create a reports with in few clicks with out struggle.
  • Domain Designer - A very powerful tool you can create a dataset using clicks with out writing SQL code.
  • OnDemand Scheduling - A very good scheduling feature and a has got lot more simplistic compared to other popular tools like Cognos.
  • Jasper Studio - Very good programmatic tool (desktop tool) lets you customize the reports more company specific, can embed complex coding with 3rd party languages like Java, Groovy (scripting language).
No photo available

Cons

SSIS

  • SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
  • SSIS is not available on any environment other than Microsoft Windows
  • SSIS does not function with any database engine back-end other than Microsoft SQL Server
No photo available

TIBCO Jaspersoft Community Edition

  • Easier to customize the Jasper Server GUI. More flexibility with the input controls look and feel and maybe more input control types to select from.
  • Have browser event functionality in the reporting itself.
  • An easier way to iterate through an object. Maybe an option that tells the report Java run-time to stop following the report sequential flow and first integrate through this stated object many times.
  • An easier way to create a list and add values to this list.
  • Maybe one could stipulate the process flow of what needs to be computed first in a given field.
  • The crosstab is a bit buggy on the Jasper studio side, so if that could be improved.
  • Better and more examples of custom components
  • The jive functionality on the tables needs an update. It looks so old and outdated.
Josia Engelbrecht profile photo

Likelihood to Renew

SSIS

SSIS 9.1
Based on 3 answers
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
Luca Campanelli profile photo

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 6.0
Based on 6 answers
Even though there are challenges with Architecture, sizing and other areas with Jaspersoft provided that Jaspersoft comes up with the right set of innovation, performance, scalability, and documentation in future it will be great expansion (win-win) situation for the clients and as well as Jaspersoft.
No photo available

Usability

SSIS

SSIS 8.7
Based on 8 answers
If you use any of the Microsoft tools, it is easy to get using and understand since it uses Visual Studio and SSMS to work with. There are extensions you can get and some of those can be difficult to work with but usually they slide in nicely. The one thing to understand though is there is some installation and configuration on the SQL Server side that can take some time.
Steven Gockley, MBA, MCSA profile photo

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 5.3
Based on 5 answers
There is a lot of room for improvement, but the basics are easy enough for non technical end users to pick up. It does allow them to get started, but it requires a lot more effort to customise their reports after that. The online community is very limited as well, so there isn't a lot of reference material available through a simple google search. A lot of people would have to go through the support channels to do things, which ultimately means they don't end up doing it, unfortunately.
No photo available

Reliability and Availability

SSIS

No score
No answers yet
No answers on this topic

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 9.0
Based on 1 answer
Good as of now
katragadda rajesh profile photo

Performance

SSIS

SSIS 8.4
Based on 6 answers
You can, of course, accidentally make sloppy code or workflows but it’s not a tools issue if you run packages in an inefficient way. With a company of our size, we never had any performance issues but I can imagine for larger companies that this will have a greater focus.
No photo available

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 8.0
Based on 1 answer
Good, but the performance is the same (even for a fewer number of records)
katragadda rajesh profile photo

Support

SSIS

SSIS 9.0
Based on 5 answers
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Chris Morgan profile photo

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 6.9
Based on 8 answers
We have only had a couple of tickets to be open while using Jaspersoft. Each time we have a very prompte responses that would meet our expectations. We always felt that our issues were being address in a timely manner
No photo available

Online Training

SSIS

No score
No answers yet
No answers on this topic

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 4.2
Based on 2 answers
While the training was somewhat beneficial, a lot of what was taught to us was what we managed to figure out in the weeks prior. It did provide some useful tips and reference material, but overall something more tailored to our requirements would've been better.
No photo available

Implementation

SSIS

SSIS 10.0
Based on 1 answer
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Luca Campanelli profile photo

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 6.1
Based on 7 answers
New releases can be very buggy, also lacking when it comes to standard time zones and formats that are outside the US. As a company we never feel comfortable implementing a new release for at least 3-6 months due to errors that are found
No photo available

Alternatives Considered

SSIS

Look for where you are going to load the data and from where are you extracting it. A lot of those who sell you the DB already have tools for ETL. I have heard good things at an enterprise level from great colleagues about Informatica, but honestly, I prefer SSIS.Although I did like TIBCO Jaspersoft and it can be mixed with TIBCO Spotfire for data analysis. If your ERP is SAP, then you must keep in mind using SAP BusinessObjects. As for free tools, and if you have a great and constant team of scripting (Perl, Python) engineers, then you can think about going open source.
Jose Pla profile photo

TIBCO Jaspersoft Community Edition

Crystal reports is very expensive and does not integrate well with java based servers. Jasper also provides community edition, if we every want to downgrade the use, we always have the option of eliminating the server and using the reports as they are. Jasper also give you the opportunity to build BI on case by base basis including Dashboards.
Arvind Jagini profile photo

Scalability

SSIS

No score
No answers yet
No answers on this topic

TIBCO Jaspersoft Community Edition

TIBCO Jaspersoft Community Edition 7.0
Based on 1 answer
CC test fails if >200 users are logged in at same time
katragadda rajesh profile photo

Return on Investment

SSIS

  • I use SSIS to automate tasks that I'm repeatedly asked to do. "Hey, can you go into the system and close any open orders that we've fully filled?" Sure....then I schedule a package to do that for me every hour so I'm never asked again. It saves me time, which gives value to the company.
  • It removes the risk of human error. When people build files and send them, there's the risk that it doesn't happen the same way every time or gets forgotten. With SSIS, you spend some up front time building a process, but then you deploy it and forget it (unless it emails you that there was an error. You are putting error handling in your ETL, right?). Very repeatable and consistent business solution.
Greg Goss profile photo

TIBCO Jaspersoft Community Edition

  • Jaspersoft Community Edition has not had any significant impact on our ROI as we have purchased the commercial edition of the product.
  • The only impact on ROI is that when we bring on new developers, he or she can begin work using the community edition while awaiting the installation of the commercial edition.
No photo available

Pricing Details

SSIS

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

TIBCO Jaspersoft Community Edition

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

SSIS
8.7
TIBCO Jaspersoft Community Edition
8.1

Likelihood to Renew

SSIS
9.1
TIBCO Jaspersoft Community Edition
6.0

Usability

SSIS
8.7
TIBCO Jaspersoft Community Edition
5.3

Reliability and Availability

SSIS
TIBCO Jaspersoft Community Edition
9.0

Performance

SSIS
8.4
TIBCO Jaspersoft Community Edition
8.0

Support

SSIS
9.0
TIBCO Jaspersoft Community Edition
6.9

Online Training

SSIS
TIBCO Jaspersoft Community Edition
4.2

Implementation

SSIS
10.0
TIBCO Jaspersoft Community Edition
6.1

Scalability

SSIS
TIBCO Jaspersoft Community Edition
7.0

Add comparison