SSIS Review

Easy data retrieval and data flow with excellent reporting features


What is our primary use case?

We've used the solution to create some data flows for one of the governmental sectors here in Saudi Arabia. I have created some applications for exporting data from Oracle databases to SQL databases.

What is most valuable?

I like that the data connections and all ODB connections are able to retrieve data from so many different databases. That's not only from SQL but also from other data sources as well. The data flow, which controls the data, including where to store it, is an excellent feature and is one of the most interesting points about SQL Integration Services.

The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great.

What needs improvement?

More coding is needed to make it easier. It needs more development and enhancement. It also needs to offer different integration services for SQL. We had to do a lot fo the implementation ourselves, but more automating of the processes would make things easier.

Data migration needs to be simplified. I've found that it is really difficult to match, especially regarding data types. The old records often have different data types than we have now have in newer databases. Converting or transferring this kind of data is very important, and right now it's very difficult.

There were also not enough instructions from Microsoft in regard to this application or this technology, which can easily be improved upon.

For how long have I used the solution?

I've been using the solution for one year.

What do I think about the stability of the solution?

The solution is stable, as long as you provide good infrastructure for the servers you're dealing with. That means making sure the SQL will be very stable as well as the SAN storage, the RAM, the CPU, and other components of the server. It is quite important.

What do I think about the scalability of the solution?

The solution is very scalable. A client contacted me two months after deployment with a request to enlarge the services and add some more customization, which I managed to do easily. It's an enterprise-level solution, with the whole of Saudi Arabia using it for something called an E-Visa. People are applying for a visa to get into Saudi Arabia through this application. The number of users is quite high and worldwide.

How are customer service and technical support?

We haven't needed the assistance of technical support so far.

If you previously used a different solution, which one did you use and why did you switch?

Previously, we used the .NET framework, which we are still using as well.

How was the initial setup?

The initial setup of the solution was easy. Deployment took less than two hours. You only need one person to implement and maintain it. At the same time, we do have another person who monitors the server-side.

What about the implementation team?

I deployed the solution myself.

Which other solutions did I evaluate?

As a teacher, I worked with SSIS, so I previously used this solution. I didn't look at other options.

What other advice do I have?

In terms of advice I would give in regard to implementing this product, I'd say to examine your business needs in relation to the solution. You need to make sure those are met before implementing it. A lot of companies use data filers and they already have existing databases. You need to make sure the solution you choose is able to deal with old databases of client records.

I would rate this solution ten out of ten. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller.
Add a Comment
Guest
Sign Up with Email