BTS - 解决方案设计 [英] BTS - solution design
问题描述
我们需要将一些Oracle数据与 进行整合。 AS 400 ..
有问题的数据是文本数据+ mages。基本上有10-20K记录带图像。在AS 400方面，他们希望文本部分在一个单独的CSV文件和所有图像作为分隔的.jpg文件 通过FTP。
我正在探索各种设计选项..我不希望图像通过消息框流动，一个大小很大的东西也是 尝试avaoid为此编排并使用纯消息传递解决方案..
1。我想这样做，
1.创建 收到位置，执行程序获取 只有数据的文字部分
2.创建2个发送端口 使用FTP
     1.One使用 自定义管道与平面文件解析器和 改变 传入数据到csv和
上传到FTP，这符合 一个要求。
      2. 创建 另一个发送端口订阅了相同的消息，但在内部它将执行一个 自定义
发送管道线组件，并调用 .net component ，调用oracle存储过程以获取来自 的图像数据。 Oracle数据库，循环通过具有图像的数据阅读器并将
图像逐个发送到FTP发送端口。
我不确定它是否可能，因为它是一个黑客，我试图从发送管道生成多个消息..如果它不可能我可以在自定义接收管道中执行该部分，然后将图像存储在本地文件存储中。然后 
重复与上面相同的步骤来发送数据..
你们认为什么是解决方案。我刚刚收到了发送管道的影响，数据读取器循环和ftp端口连接到它下游..有一个更好的方法来处理 这个？
1。其他解决方案是 没有太多的BizTlak，开发一个纯粹的.net 组件循环通过数据读取器 并使用.NET FtpWebrequests将图像流+文本文件直接上传到FTP。没有适配器 或任何其他组件
如果您应该使用BizTalk或仅使用自定义.Net解决方案，这在很大程度上取决于您的具体要求。您可以将BizTalk视为"仅"。一个工具箱，为您带来很多功能，这对于自己构建来说既困难又耗时。如果
需要可伸缩性，事务，可靠性，监控等，你应该使用BizTalk，因为它开箱即用。
如果你决定使用BizTalk这个我我想我会选择在接收管道中将图像流式传输到磁盘的选项。接收管道还应该创建一个小消息（包含存储在磁盘上的文件的文件名），消息框中流过
。在发送管道中，文件将流式传输回消息，您可以使用FTP适配器将文件传送到AS400。当您这样时，您可以在BizTalk中完全实现流程，从而实现更好的可跟踪性。 （例如，收到消息A时的
以及何时发送到AS400）。除此之外，您还可以使用轮询从Oracle检索数据。
We have a requirement wehre we need to integrate some Oracle data with AS 400 ..
the data in question is text data + mages..Basically there are 10-20K records with images..On the AS 400 side they want the text part in one single CSV file and all the images as separated .jpg file over FTP.
I was exploring various design options..I don't want the images to be flowing thru the message box, one thing the size being big and also trying to avaoid orchestration for this and use a pure messaging solution..
1. I was thinking of doing this ,
1. Create recieve location, execute a procedure to get only the text part of the data
2. Create 2 send ports that uses FTP
1.One uses the custom pipe line with flat file dissembler and transforms the incoming data into csv and uploads it to the FTP , which meets the one requirement.
2. Create another send port subscribed to the same message , but internally it will execute a custom send pipe line component which invokes a .net component , calls a oracle stored procedure to get just the image data from the Oracle database , loop thru the data reader which has images and send the images one by one to the FTP send port .
I am not sure its possible, because it being an hack, I am trying to generate multiple message from the send pipe line.. If its not possible I can do that part in a custom recieve pipe line and then store the images in a local file store. Then repeat the same step as above to send the data..
What do u guys think abt the solution. I am just converned abt the impact of the send pipe line with a data reader loop and ftp port attached to it down stream..Is there a better way to handle this ?
1. The other solutions is not much of BizTlak, develop a pure .net component loop thru the data reader and upload the image streams + text file directly to the FTP using .NET FtpWebrequests. No adapters or any other component
Hi,
It very much depends on your exact requirements if you should BizTalk for this or just use a custom .Net solution. You can view BizTalk as "just" a toolbox that brings you a lot of funtionality that is hard and time consuming to build yourself. If you need scalability, transactions, reliability, monitoring, etc. you should use BizTalk because it brings this out of the box.
If you decide to use BizTalk for this I think I would go fo the option where you stream the images to disk in a receive pipline. The receive pipeline should also create a small messages (containing the filenames of the files stored on disk) that flows through the message box. In the send pipeline the files are streamed back into the message and you can use FTP adapter to deliver the files to AS400. When you this you have the flow completely implemented in BizTalk which allows for better tracebility. (e.g. when was message A received and when was it sent to AS400). Besides that you can use polling for retrieving data from Oracle.
这篇关于BTS - 解决方案设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
