Forum Replies Created
-
Posts
-
3 things you can do:
1. buy HIPAA accellerator
2. hack schema into biztalk (search this forum for info)
3. wait for 2006 R2, which has all of the schema
-wa
More info about the /n software adapter can be found here:
http://geekswithblogs.net/bvamsi/articles/73291.aspx
That's correct. You are missing the cubes. The Recipes book is a great source, also when it comes to configuring BAM. Chapter 9 contains a number of recipes which help you in setting up your BAM activities and views and create a tracking profile.
Sounds right to me. n/software has a Secure FTP adapter. But be aware that there are many several forms of "secure" FTP and I haven't dealt with the 3rd party adapter specifically
How do you know you're using the wrong password? Are you sure you entered it correctly or that it is getting "munged" on its way to SAP?
You can try SSO: Using Enterprise SSO (Single Sign-On) with the SAP Adapter and in general (http://geekswithblogs.net/bcorazza/articles/86595.aspx)
for reference only: Sending Data to SAP (One-Way Send Scenario)(http://www.microsoft.com/technet/prodtechnol/biztalk/2006/library/bta_mysap/64556bfa-b069-44ae-98e0-606b8633e980.mspx?mfr=true)
To start with, I generally try to solve mapping issues with a pattern of built-in functoids. If it doesn't work, then I use this forum and Google to find suggestions before resorting to calling everyone I know. I've stayed away from that option for months, but it's always there.
After I exhaust my options or figure out that the pattern is too unwieldy, I head to C# and a quick windows app with simple logic in a button. If it’s 3 lines or less, I’m happy to use a script. If it will possibly be used again, I build a custom functoid. Recent additions were DateTime conversion (any localized .NET acceptable DateTime format that gets converted to xsd:dateTime) and a RegEx validator so I can return an error on a particular field.
You can build a library of custom functoids and refactor them as needed. Just remember they need to be deployed ahead of any application that uses them.
I use VPC 2004, 2007 and VM Ware workstation 5. I prefer vmware because it handles memory better when you use a farm. If you are using a BizTalk, SQL configuration on one instance, VPC is fine. I have images using 500mb up to 1.2Gb of RAM for BTS depending on available memory. However, on a 2 Gig machine, I've run a DC, SQL, and 2 BTS servers (that's 4 servers) with RAM to spare using vm ware. I'm running a DC, SQL, Oracle, and a single BTS server on a 3 Gig platform with no issues, all on VPC 2007. This runs on a Win 2003 host, but XP or Vista work just as well.
Virtualization is cleaner and easier, but only when you have the horsepower. Don't try this on a 1Gig machine with a slow hard disk.
Other suggestions: External fast hard drive over USB 2, Firewire, SATA II. Use a virtual pagefile disk to keep the pagefile from fragmenting the data drive. Store SQL and Oracle data on a separate virtual disk. If you don't use virtualization for dev, you should give it a try IMHO and learn how it best works for you. Then tell everyone you know how great it is. J
It sounds like the typical feature (bug) that you should expect after awhile. If it's Near 100% repeatable, you're lucky. Now you know what to look for. Periodically, and I mean somewhere between 1 and 99 times out of a hundred, I (and several folks I know) lose binding information, maps, and pipelines after deploying. Since this occurs in dev so often, I make sure to save Bindings regularly and even search-and-replace ****** with the actual (single) password every time I save it…but I still check on import or before adding to resources in the application.
Have you informed Microsoft about this? You may as well add it to the pile just so someone gets a chance to look at it.
Quick suggestion…
Can you map to something like this? <AChildRecord> Min=1, Max=1, <Child> Min=1, Max=unbounded.
<Top>
<AChildRecord>
<Child>
<SomeElement />
<Data></Data><MoreData></MoreData><AChildRecord>
<SomeOtherElement />
</Child>
<Child>
<SomeElement />
<Data></Data><MoreData></MoreData><AChildRecord>
<SomeOtherElement />
</Child>
</Top>If you're using a SPROC, try using OUT modifiers to retrieve data. This assumes you're doing this because you have control over and familiarity with Oracle. You can use a View in place of a table for repeatable queries, then you know what's being returned.
If you want to generate dynamic queries, no matter whether you use Native or a Sproc to call Oracle, you'll need to do some heavy-lifting to parse the response data. Although I haven't tested this, I'd suggest a sproc that returns XML. This could be interesting. J
Thanks for this post. I’ve been backing up my development machine using a standard SQL Maintenance plan for the last couple of months. Luckily I didn’t go live like this – it could have been very messy!
Nick, once again, thanks alot for all of your time and advise. You provided me with an amazing answer.
Thanks so much.
Steven
Steven,
I can see where you're coming from and asked the same questions when I was starting with BizTalk. I think the crucial question here is 'how long will a message take to go end-to-end'.
In our BizTalk B2B environment, messages will go from receive to send in under half a second. Furthermore, we take an archive of all messages before the go through BizTalk, so if we lost the databases/database server we won't be losing 'much' – we would need to re-create the environment (and I'd much rather do that from backups than have to re-deploy all of the various artifacts) and then re-submit any messages that were lost. We budget on about a day to restore the production environment (and about an hour to get BizTalk back up and running on a secondary, standby SQL Server).
However, if you have a long running business process that requires input from several systems/users and/or correlation and those transactions were lost, those business processes would need to be recovered from a backup. Period.
So, depending on the length of the business process and the time required to restore the environment (read artifacts) you may or may not need backups. However, I think it is just makes good business sense to have backups and to test them on a monthly basis – I'd hate to be the one to have to tell my boss 'erm…. we don't have any BizTalk backups'….
Nick.
