Forum Replies Created
-
AuthorPosts
-
I think you should be able to do it by backing up your BizTalk databases (using the proper backup jobs, not the standard SQL Server facilities) and following the instructions in the documentation on how to restore them to a different computer and having your biztalk installation point to them. You can find those docs here: Restoring BizTalk Databases to Alternate Computers.
However, notice you'll need to have biztalk already configured using domain groups and accounts; if you have it configured with just local accounts, then that won't work, and you'll need to first unconfigure your biztalk (ConfigFramework.exe /u) and run configuration again to recreate your biztalk installation from scratch, using the proper accounts for a multi-machine installation.
Is it possible to reconfigure the Biztalk group then? How do I do that?
Thanks!
You can not use the Schema Editor to promote something with a multiple occurrence.
You’ll need to write a custom pipeline component to XPath out your value and promote it. You might be able to find a sample online someplace.
Hope this helps.
September 13, 2006 at 9:52 PM in reply to: Extract data Oracle and insert Informix in BizTalk #15677Hello.
You need to configure the Oracle Adapter to query Oracle to return your records to BizTalk. Then, use a map to transform the data into your SQL Schema. Last, you can use the SQL Adapter to send the data into SQL.
You should be able to find sample of SQL and Oracle Adapter in the SDK.
Thanks Greg
Exactly what i needed. Had some trouble att first but when i found out you spelled OrganizationName wrong in your example and changed it from OrganisationName all worked perfect
Thanks again.
Johan
September 13, 2006 at 4:25 AM in reply to: Connecting BizTalk to MySQL with BTS2K6 Dynamic ODBC Adapter #15671Rather than use the windows schedule task, you could try the Scheduled Task Adapter.
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=E473FC93-5081-44C7-A9C9-84BF4E783728You could use this to initiate an orchestration that will call a .NET class to access MySQL.
Or you could call your .NET class from this adapter. It requires two classes, one to define your config properties like connection string and query and the second implements the MySQL access and returns a stream.
September 13, 2006 at 12:25 AM in reply to: Connecting BizTalk to MySQL with BTS2K6 Dynamic ODBC Adapter #15670Hi Stephen,
First of all, thanks a lot for your help.
I finally have proceed like you told me first. It works fine, of course, but I (and especially my bosses) don't really like the use of windows schedule task.
So one of my new objective will be : succeed to use the community ODBC adapter by adding the proper code.To sum up, I'm a little bit disappointed that I don't have any feedback from the community adapter on GotDotNet and I promise that when my MySql or ODBC adapter will be ready to work, I will send the source and documentation to BizTalkGurus.com, if you are interested.
Kindest regards.
Hi
answer for 1st question
For using .NET assembly in BizTalk project , you need to first add it in reference section , then you need to create a variable which is of type is class used in that assembly (This is creating object of class , normally we create in any language) , now use this varible in your expression shape to access methods of that class ……
But the most important thing is before using .NET assembly , you need to add few line in AssemblyInfo file these are
[assembly: ComVisible(false)]
false)]
[assembly: CLSCompliant(true)]
[assembly: EnvironmentPermission(SecurityAction.RequestMinimum,Read="USERNAME")]
and provide strong name key loaction in same AssemblyInfo file
Also add [Serializable] tag just above the class declaration
Sudershan
Hi , the probable any easiest solution is , go to BizTalk Explorer and undeploy the old assembly , there is one option to undeploy the assembly you will get it by right clicking on that assembly .
After undeployment come to your project and then try to deploy your orchestration ….hope it will works for you too
Sudershan
September 12, 2006 at 12:46 PM in reply to: An error occurred in the BizTalk Server 2004 connector #15667It looks to me Duplicate Interchange number(the file with interchange number already processed)!!
Allow Duplicates or Check the Current interchange number
And Process the File again with Max interchange number+1
Hope this hels you.
Nar-
The output is dependent on your mapping, not just the schema setup. Your for-each needs to drive the TransactionCategory
node instead of the CategoryID nodeYou shouldn’t need an Orchestration in most cases.
In your case, to accomplish what you want you would need an Orchestration.
There was a thread on this about 3 weeks ago, it might help: http://www.biztalkgurus.com/forums/thread/4573.aspx
Nope, in BizTalk 2004 it’s rather a pain.
You might want to look at the BizTalk 2004 Deployment Helper Tool I have on this site. It’ll make life a little easer in some cases. Also, using binding files (even for dev work) might save some time as well.
Good news is things are easier in 2006.
This was fixed, it was a root node issue.
-
AuthorPosts