Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Mapping data lookups
- This topic has 2 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
April 30, 2009 at 7:38 AM #22273
The client I am working for at the moment is creating a truck load of different integration solutions, and there is a common requirement that keeps cropping up that makes me think there must be a “product” that can help me.
Basically almost every integration has a need for data values to be mapped from a value one system understands to a value understood by the target system.
While this is a simple thing to implement on a per project basis by creating a database per system that holds these mappings, the number of these databases and tables is growing every time an integration is added. Some of these databases then need a user friendly way of maintaining this data once the solution is live.
What I would like is a peice of software that will provide a sensible way of setting up and mapping source to target data through an UI. Some rudimentary security model placed on top of this to ensure restricted user access to this lookup data, and a web service or some other api that will allow a lookup of this data.
I have had a good rummage around the internet, but I can not find something that focusses on only this need only.
Any ideas anyone??
-
April 30, 2009 at 12:18 PM #22274
There is Cross Referencing functionality in Biztalk. Database tables, data management tools and mapper functoids.
http://kannannova.blogspot.com/2007/11/biztalk-cross-referece-samples-maps-and.html
http://blog.biztalk-info.com/archive/2007/02/14/BizTalk_Cross_Referencing_Funcionality.aspxAlso check this out:
http://www.codeplex.com/BizTalkXRef-
May 1, 2009 at 1:32 AM #22278
Thanks for the comment.
This is not really what I was after. I have looked into the cross referencing functionality and while it meets the need of data value mapping, it does not have a interface that would meet the following requirements…
– Manage the data held easily so that a power user can easily upload edit and remove data.
– Secure management of the data using some kind of permissions so that certain power users had permission to view certain data types
– Easily map from several fields to a single value. This implements one to one mapping. I know this can be done using some sort of delimiter between fields like ###, but again it makes data management of these values a more difficult job.
I have found this which I think is the same thing as you sent me
http://www.softpedia.com/progDownload/Cross-Reference-Data-Manager-Download-121732.html
But it is far from perfect and has no security model, hey ho, may look at enhancing this tool further should my client allow it 🙂
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.