Looking for a replacement for SSIS

One Star

Looking for a replacement for SSIS

Hi,
We are looking for a replacement for SSIS for several issues that we currently running into. We are curious if Talend meets these requirements and is an acceptable replacement.
We have complex business rules that are part of our transformation process from XML inputted data into a MS-SQL server DB. The data that needs to be processed in "real-time" consists of data for a single user composed of 10 different types of data (coming from an XML data message). Two of these data types contain most of the data and may contain upward of a couple hundred records. Hence we are viewing the process as running micro-batches of information. SSIS foot print (startup and overhead time is too great for this to be a real-time solution for us.) We are looking for another ETL tool that can meet are requirements.
1) can be run programmatically
2) can run distributed transactions (our staging db is on a different server than our production DB).
3) is fast. Want to do our transforms in real-time i.e, 5-10 sec (or less) for a moderate size dataset.
4) run many concurrent users. Since we are trying to have real-time processing of the data while a user is active we can have upwards of 250 concurrent users so we are looking for an ETL tool that can fit this requirement both from a memory resource and DB connection (i.e., don't want to run out of resources or get DB deadlock issues)
5) Support for MS-SQL Server
How does Talend do across these requiremenst?
Does Talend produce a java program that can be tuned to our needs or our we running some form of interpretted process (like SSIS)?
Thanks for Your help.
One Star

Re: Looking for a replacement for SSIS

Do anyone have a study/comparison between Talend and SSIS?
One Star

Re: Looking for a replacement for SSIS

Hi all,

Do anyone have a document on comparison between SSIS and Talend and how it is?
Thanks for your help.
Four Stars

Re: Looking for a replacement for SSIS

hI ALL
I processed XML which is very complex which has many looping elements. I used to process both in SSIS , TALEND i believe processing XML File in Talend is good we can retrieve every looping element to form into a single record.
Problem with Talend is we need to have good not strong knowledge on Java as well as XML to process this kind of complex XML FILES.

tHANKS
ANIL KUMAR
______________________________________________________
HAPPY NEW YEAR TO U AND TO UR TEAM

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download