Hi Avadhut Narayan JoshiThe use case is achievable using Spark. Connection to SQL Server possible as Mich mentioned below as longs as there a JDBC driver that can connect to SQL ServerFor a production workloads important points to consider, >> what is the QoS requirements for your case? at least once, at most once, exactly-once >> how to handle Spark Streaming job restarts? (because of error or you have to put a new version of application) >> What are your error handling strategies? >> How do you deal with late arriving data since you are doing aggregations?It is best to make downstream systems idempotent, that is very less troublesome way to have maintainable production workloadsBest RegardsVP thanksVijay
-- Sent from: http://apache-spark-user-list.1001560.n3.nabble.com/
