28th April 10:13
Architecture & Design Question
I need to build a tool to map data from various database schemas into a
system I have built. Essentially I am looking for the type of mapping and
data transformation functionality that BizTalk provides, without the
orchestration. Most of my small clients cannot afford BizTalk, so I need to
come up with a different solution.
The solution I provide need to be generic enough to work with data from SQL
Sever, Oracle, MySQL, Access, XML files, etc. In other words I am not sure
what the clients of my system will have as a data store, I just know that I
need a way to map their data into my C#, .NET, SQL Server based system.
This is a function I need to have my clients configure themselves so they
can interface with my software.
Since I have relied on BizTalk for this type of functionality, I have no
idea how to approach this. Any thoughts, samples, white papers, hyperlinks
or suggestions on open source software would be greatly appreciated! Thank