- This topic has 7 replies, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
-
Guhan,
In your Orchestration (if you're using one), create a Send Port and configure it to "Specify Later". Once the app is deployed, configure the Send Port as an SQL port; this cannot be done on the development machine, the app has to be deployed. Click the configure button and you can enter your connection settings, etc.
-
How can i test the project without specifying send and receive ports?
in receive port do we need to include a web service?
Any url or example or webcast u have?
-
When you build and deploy the application you have to use the BizTalk Administration Console to "Configure" the application. Configuration includes altering Send/Receive ports. So you can't test the application without specifying send and receive ports; they must be configured before the application starts.
I haven't worked with the PeopleSoft adapter…if PeopleSoft communicates through a Web Service, then yes you do. Otherwise, no you need to specify an adapter for PeopleSoft, which may be a SQL adapter.
-
Here are 2 excellent books that I used to learn BizTalk; this site is very helpful too.
BizTalk 2006 Recipes: A Problem-Solution Approach ISBN: 1-59059-711-7
Pro BizTalk 2006 ISBN:1-59059-699-4
-
Guhan,
I am by no means an expert on the BizTalk Peoplesoft LOB adapter, however if
you read the 'Microsoft BizTalk Adapters for Peoplesoft' document available at http://www.google.co.uk/url?sa=t&ct=res&cd=3&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F1%2F6%2F9%2F16968441-c6c8-4bd0-9410-5f4014bc61f0%2Fpeoplesoft.doc&ei=iHsYR46JFaD8wwHD5LySCA&usg=AFQjCNHdHlMQ_R2GFax-HkJXEsO_RmRk9Q&sig2=J0JmXwmTM0hMBtqKevQ_2wthis should give you a good starting point.
To answer your question, you will use the Peoplesoft LOB Adapter to retrieve
data from Peoplesoft and that data will be in an Xml format. You will then map
the Peoplesoft Xml into a format that represents an Insertgram for SQL Server
and insert the data using the BizTalk SQL Adapter that comes 'in the box'.Delving into the technical aspect of this solution, it would appear that you
cannot poll Peoplesoft (using the LOB adapter) on a receive location (see the
final paragraph on page 9 of the aforementioned document). So, you will need to
use an orchestration to send a request message (over a send port –
solicit/response) to Peoplesoft to gather the necessary data for delivery to
SQL Server. Once you have received a response from Peoplesoft, you can map the
data into the SQL Xml format and send that to SQL Server using a Send Port
configured to use the BizTalk SQL Adapter. Note, you'll need to trigger the
orchestration using a 'throw-away' message.To generate the necessary Xml schemas (XSD's), use the 'Add Generated Items'
tool in Visual Studio and use the 'Add Adapter Metadata' option selecting the
relevant adapter to use.Section 3.3.1 of the above document (Design
Pattern: Receive Handler—from PeopleSoft to BizTalk Server) will also help
with your specific problem.Hope this helps, Nick.
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.