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
you.

Nov 15 '05 #1

Subscribe Post Reply

960

PLEASE IGNORE THIS POST AND READ THE ONE TITLED "DATA MAPPING ADVICE
NEEDED", THANK YOU.

SORRY!

Nov 15 '05 #2

Similar topics

XML standards and architecture

by: Shashank | last post by:

HI All, Our team need to get understanding of various XML standards and how they fit together from architecture & design perspective. Can you suggest any resource for the same? regards,...

.NET Framework

Component Based Architecture Advise Needed

by: Michael Crawford | last post by:

Hi, Where would one start for this type of application: I want to create an vb.net container application that has the gives the end user the ability to install and uninstall plugins or add-in...

.NET Framework

3-tier winforms architecture

by: David Noble | last post by:

We've been developing a web site using 3-tier architecture for 18 months now. There is a common layer that defines the classes - using XML schemas. The data layer acts as a wrapper to 3 databases...

.NET Framework

References for designing a "Plug-In" software architecture

by: Gary James | last post by:

This may not be a direct C# question, but since I'll be using using C# for development, I thought I'd pose the question here. I'll soon be involved in the design of a new software product that...

C# / C Sharp

web architecture question

by: Brian | last post by:

Tim- Might I suggest you take a look at book by WROX titled ASP.NET Website Programing Problem - Design - Solution Visual Basic .net Edition The ISBN is 1-86100-816-3 This book offers some...

ASP.NET

Web Service Architecture question

by: John A | last post by:

I have a Web Service that I am reponsible for that we use for data integration purposes. Recently I have been tasked with sending some of this data to a third party. Because they need to receive...

.NET Framework

Business Logic Architecture

by: Chad Grooms, MCSD >> [VB.NET,C#,ASP.NET] > [VB.NET | last post by:

Hey all, I have a few questions regarding .NET BLL design. I am a somewhat self-taught developer with limited resources, so I know there are some concepts here and there that I might have missed...

.NET Framework

Books about SW Design/Architecture

by: Ludwig Wittgenstein | last post by:

Other than the Design Patterns book, which book(s) is/are the best to learn object-oriented software design/architecture from ?

C# / C Sharp

app design/architecture question

by: CSharpguy | last post by:

I have a 03 .NET web that does not use Typed DataSets, it uses a Busines Layer/DataLayer classes. Alot of my reading on .NET 05 is using the DataSets for the datalayer/business layer. I have a 05...

ASP.NET

Survey about Architecture and Design Patterns

by: Joerg Rech | last post by:

Dear software practitioners, consultants, and researchers, we are currently conducting an international survey about architecture and design patterns. Our goal is to discover how familiar people...

C / C++

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General