Badges

650 Points
Real User
8 Years
Top 5
Popular
Leaderboard

User Activity

4 months ago
SSIS largest weaknesses right now are 1) Visual Studio/SSDT is only 32 bit. It needs to be 64 bit because that's the only thing that gets deployed and SSDT gets extremely unstable when your application gets large - likely because you start going over the max memory…
5 months ago
Note tThere is some level of logging - you can look in the security area and some level of access although limited.  Also you can write your own extensions in the triggers so you could customize the logging yourself.
6 months ago
Primarily for enterprise DW data movement from and to sources as well as between architectural layers of the EDW.  We also use it for batch operational integration between applications. 
7 months ago
You've already been given excellent advice.  There's a multitude of challenges and things that are important to get right.   However in my experience I've found that there can be the best intentions and plans for success but in the end I have too often witnessed significant…
9 months ago
The insight into running packages comes from the BiXpress Audit and Notification frameworks which are an extra cost per developer. But it's invaluable. And I would argue it gives you insight into what's running like no other tool on the market can. Its as if you were…
9 months ago
Check out my review where I lay out the pros and cons. https://www.itcentralstation.com/product_reviews/ssis-review-30205-by-garym
Almost 2 years ago
There's so much to this question that to answer it properly would require an extensive presentation. I am curious however when people review tools they aren't very familiar with...yes SSIS has debug feature and it's just as robust as any .net debug...with breakpoints,…
About 2 years ago
Thanks Ricardo, sounds like ODI is vastly improved. The ability to run things like OS code is actually one of the things I like about SSIS as its easy to call out to anything external via script components. However what isn't always easy from any job control type of…
About 2 years ago
Which component(s) of their products are you using (there are many different ways to implement from ETL plugins to CRM plugins)? Thanks
About 2 years ago
Why do you think Oracle will support ODI long term any more than their prior ETL tools such as OWB or the tool they bought in the 1990s from Sagent, both of which are gone now? Some history for you....ODI used to be a weird combination of two completely different tools…
About 2 years ago
How does it compare to other ETL tools or have you only ever used this ETL tool? Thanks
About 2 years ago
Is this a plugin to Talend ETL or standalone? Why do you need to manually "pen the Talend Administration Center to check the status of the process" to check - does it not notify you (email, txt) if there's an error? What kind of errors do you have (we run similar…
About 2 years ago
Which product did you use to do this (they have multiple products for this)? Was it the stand alone product, the SSIS plugin, the rest web service call, Dynamics plugin, etc... Thanks
Over 2 years ago
Thomas, you will have to contact the vendor. I think their list prices are on their web page so not sure why you are asking a technical forum.
Almost 3 years ago
Mark Bennett gave an appropriate answer. I have used both and both have pros and cons. The selection starts with your requirements and expectations. If you dont know those then you are just guessing. Careful of anyone who says one " is better because...." as they may not…
Over 3 years ago
An update for us...watch out when you upgrade SSIS to 2016, it's not fun. Also I split matching into multiple dataflows and this slashed runtime by about 75% (from 4 to 1 hour for full exact match with advanced survivorship).
Over 3 years ago
An update regarding this software review I want to mention; this review is now 2 years old so if you are evaluating this software you should consider any improvements made since that time. I still stand by my initial assessment for the software that was current 2 years…
Over 3 years ago
Try upgrading to 2016, the business rules interface is dramatically improved.
Over 3 years ago
Curious people's experiences when they mention "fail a lot" or scalability. I've used many ETL tools in my career - most of them very expensive and I'd put SSIS up against any of them for reliability and performance (within limits). Scalability is largely comparing to…
Almost 4 years ago
I suggest looking at comparing SSIS verses Informatica in terms of meeting your unique needs and then assess each one's capabilities in cloud verses your expectations for why you want it off-perm. Note that any tool can run on Azure cloud in IaaS/PaaS. Azure SSIS as…
Almost 4 years ago
The big boost you mentioned going from ETL to ELT is to be expected (in other words doing push-down of your joins which is what that really means). That unfortunately is the typical problem with newbie or incompetent ETL developers - they don't realize that ETL tools…
Almost 4 years ago
It 100% depends on your needs in terms of data volume, availability, # of potential concurrent users, # of data sources, complexity of data sources. I'm assuming by platform you mean tools/software/hardware? Are you thinking BI as well or just backend? Cloud-based…
About 4 years ago
Update - the tool is now SqlServer/SSIS 2016 compatible!
About 4 years ago
Joe, Actually we spent 6 weeks and the vendor was doing it and the requirements and all the coding and staging was already done so the amount of actual work to do was relatively small. And there was pretty much nothing usable at the end of that. The issues that the…
About 4 years ago
Agreed on all points - especially the need to multi-thread - I also had to split up our processing due to this to speed it up. However even so it still appears much faster than any other similar tool I've used in the past. And YES regarding resize! That's SO annoying. No…
About 4 years ago
Why does MelissaData software need to be on the same SQL server instance? You mean where SSIS is installed? That can be installed on a separate server if you want. That's entirely up to you and not a limitation of the tool.
About 4 years ago
What do you mean by "workflow" component? There's no such thing in SSIS - its called Dataflow. I'm also not aware that Melissadata has anything like that either so this is very a confusing review. Please elaborate.
About 4 years ago
Is the question regarding Informatica or SSIS?  I can't speak for Informatica but SSIS starting with 2012 version allow environment controlled parameter values. What this means is the ETL changes automatically based on where it's running if you use the sql agent scheduler…
Over 4 years ago
What version are you on, please provide more details. Don't plan on millions of records unless on 2016 version - read my review. It starts to choke once you get anywhere near 100K records in an entity let alone millions. Its fine for small reference data - I used it…
Over 4 years ago
You mentioned the admin and BI tools...the issue all the cloud solutions face (at least SaaS) is they don't have all these tools. SqlServer environment isn't just a database, its a really really big toolbox. If you only need the database then a stripped down SaaS…
Over 4 years ago
Howard, yes our database name/server name changes across the environments. We manage this via visual studio configuration environments when creating the ispac or doing deployment from VS but that's just for initial setting defaults to show up within the jobs so we don't have…
Over 4 years ago
BTW...Re. Integration Services...you mentioned that ..."platform variables, since these are not easily managed and deployed. Our testers have had a great deal of difficulty swapping environments, particularly where the connection information changes (underlying database…
Over 4 years ago
Yes PowerBI is a world of difference from Powerquery/pivot/view - realize those are just Excel plugins, nothing more. PowerBI is both an independent desktop tool like Tableau and Qlikview plus it deploys to the web and soon to on-prem using SSRS server. And it gets updates…
Over 4 years ago
Have you considered PowerBI in comparison to Tableau and QlikView? If not, why not?
Over 4 years ago
C Lewis, that's great you've been successful at using the product. I'm completely baffled how you made it work with any volume of data but I'm glad to hear someone can make it the tool work for them.
Over 4 years ago
Re. SSRS for adhoc reporting, I would argue SSRS was not meant for adhoc reporting - that's the purpose of PowerBI and Excel PowerPivot. The people who use SSRS should be data consumers who want specific formats whereas adhoc reporting is data explorers who will want a…
Almost 5 years ago
Oscar - much appreciated. I love your product and just want to see it become even better. I'm very impressed with the improvements over the past few years. I did brief POC a couple years prior before it did survivorship and liked what I saw even then. I'm impressed that your…
Almost 5 years ago
2016 version due out in a few months is even much better and the first significant upgrade since 2012...if you haven't yet used SSIS I'd wait until 2016 and start there if you can. 2014 is unchanged from 2012.
Almost 5 years ago
Howard, would like to know more about why its not ideal. It seems to me that even if you could share an instance as both tabular and MDB (remember that they are completely different technologies), it would not allow you to scale easily. In fact I would not run them both…
About 5 years ago
So what were the pain points? Which ETL tool are you using? Please explain.
About 5 years ago
Note: the upcoming 2016 version is a major enhancement especially for UI and business rules.
About 5 years ago
Update regarding deployment instability... It is caused by very large projects and using the default install shortcut 32bit deployment wizard. Running the 64 bit version resolves the issue.
About 5 years ago
Azhar, SSIS has same issue. SSIS reports "metadata needs refresh" syntax error which is easy to fix but of course requires re-deploying the ETL objects. It begs the question however - do we really want it automatically refreshing and potentially causing data…
About 5 years ago
I suspect that MDS 2012 version is likely very much behind competitors, albeit one must remember that MDS is basically free and competitor products are typically very expensive. It works for our current needs which are simplistic. I've used Oracle DRM - wise choice as its an…
About 5 years ago
If you don't like visualization features of SSRS in 2012, wait for 2016! Its much improved. And you now have Datazen and PowerBI in the stack if you want to do dashboarding. They now have complete solution stack seemingly missing nothing and almost free if you already have…
About 5 years ago
Over 5 years ago
This review is great but should just make clear, this is express version only. There are many versions of sql server.
Over 5 years ago
Note regarding deployment...although file-copy is one way of running it that's not recommended. The tool comes with SSISDB database for deployment to SqlServer server that provides logging, reporting and storage on the server that includes versioning. It also integrates with…
Over 5 years ago
What does "Microsoft BI" mean? I'm confused as that's not actually a tool but represents many. There's many reporting tools in the Microsoft stack, some PC specific, some standalone server, some Sharepoint integrated (PerformancePoint which is being deprecated) and some can…
Over 5 years ago
So tell me why I should buy Tableau (which is quite expensive) over just using free PowerBI Desktop which seems very similar and also built into and integrates with Office365? Seems Tableau made sense a year ago but no longer. Same with Qlikview.
Over 5 years ago
It does in fact allow running both tabular and MDB on same server. You have to run independent installs and name the instance 2 different names. I suggest researching this further as it may not be straight forward but is in fact not a constraint.
Over 5 years ago
That's an excellent summary of matching thanks! Do you have anything that "addresses" survivorship in dataflux?
Over 5 years ago
Can you provide more detail regarding it's specifics around de-duplication such as golden record survivorship and any augmentation services it provides?
Over 5 years ago
Over 5 years ago
How is the scheduler now days in terms of supporting conditional execution of jobs and passing in dynamic parameters? Also with logging - do you still have to write your own extracts to get useful logs out of its repository? Did you use the push-down option and if so, how…
Over 5 years ago
Commented on SSIS vs Hadoop
Thanks Ibrahim, that's hilarious "Two sweet technologies, probably shouldn’t be compared to each other but we’re doing it anyway" - thanks for doing this comparison! Very nicely written and summarized. Good work.
Almost 6 years ago
Hasham, are you reviewing SSIS 2012 or 2008? Clarifying that would be helpful as there are many differences between the versions. 2012 has a repository that logs and reports much more than just errors - it logs performance and comes with performance dashboards. You have…
Almost 6 years ago
Additional advice...considerations on selection should include: Need to integrate with applications (e.g. MS Dynamics requires SSRS), self-publishing BI, data exploration verses canned reporting, cost (there's world of difference between the tools here from free to 7…
Almost 6 years ago
Its still unclear if you're already an Office 360 user whether you have to pay for the pro version or not. Does anyone know? Their announcement was sufficiently vague.
About 6 years ago
Tableau is a great tool, no doubt about it. However we all want simple answer to the question of whether its the right tool for our organization and unfortunately, it really does depend. If you have small amounts of data in relatively simple data sources and you need…
Over 6 years ago
It was an interesting comparison with some useful insight which I appreciate but it gets muddy when you start mixing in the entire platform. I suggest comparing just the BI tools themselves and leaving database and ETL out of it since those are completely separate…
Over 6 years ago
All good points, but I might disagree with Damien on one point - that sometimes tools such as Tableau are sold as supposed replacements for ETL tools and even the need for a DW. Executives are often sold on the emotional impression that visualization tools with in-memory…
Over 6 years ago
You stated that its too bad Microsoft didnt include something like Tableau with Excel but it actually did as of Excel 2013! It's called PowerView, coming out I think about the time you wrote your review. Would be very interested in a comparison between the two. I've…
Over 6 years ago
Use of configuration files for SSIS is a really bad idea and in fact is deprecated by Microsoft with 2012. Not only is using them no longer advisable but the new method of using job and package parameters significant advantage over many competing ETL tools. Managing…
Over 6 years ago
The assumption that you are referring to batch/ETL data integration rather than process mentioned by Abhishek said is critical. The primary difference between ETL verses IAI being in the areas of expected latency, data format, and data verses process transformation. I say…
Almost 7 years ago
Two things 1) we already had this discussion on a LinkedIn group if you can find it. If you have questions about pros/cons of SSIS specifically - see my review of SSIS on this site. If I had one thing I'd say is significantly better with SSIS than Informatica, its…
Almost 7 years ago
So the question I think that's on many minds reading your question is, why? Why would you compare vendors to something you already have that's free? Is it you feel that OEM isn't meeting your needs? If so, then please explain what you need it to do. I would instead…
Almost 7 years ago
It seems like a lot of how you differentiate Biztalk vs. SSIS would apply when comparing any ETL tool to an EDI/webservices/bus middleware technologies and products. So this may serve as a starting point when discussing when one should use one type verses the other. This is…
Almost 7 years ago

Reviews

WhereScape RED Logo
Over 5 years ago
WhereScape RED
Melissa Data Quality Logo
About 5 years ago
Melissa Data Quality

Articles

Questions

Over 6 years ago
Business Intelligence (BI) Tools
Over 5 years ago
Data Integration Tools
About 5 years ago
Data Integration Tools
Almost 5 years ago
Data Quality
Over 4 years ago
Data Integration Tools
About 4 years ago
Data Integration Tools
About 4 years ago
Data Quality
Almost 4 years ago
Cloud Data Integration
Over 3 years ago
Data Integration Tools
Almost 3 years ago
Data Integration Tools
Over 2 years ago
Data Quality
9 months ago
Data Integration Tools
9 months ago
Data Integration Tools
6 months ago
Data Integration Tools
4 months ago
Data Integration Tools

About me

Nearly 30 years of IT experience starting with DEC PDP, PC programming and then onto IBM mainframe using Software AG software and a role as an Adabas DBA. Then an Oracle DBA for a number of years in the 1990s on Sun and HP servers with smattering of SqlServer. Started doing data marts and star schema design towards the end of the 1990s. Since then built a number of marts on Oracle and an architect on an EDW using Teradata and Informatica.