Forum Replies Created
-
AuthorPosts
-
I don’t know much about what’s actually stored internally in SSO, since it’s completely undocumented. If you’re using SSO yourself for credential mapping, then I would say you can be pretty sure it is storing account SIDs in there. Also, notice that SSO applications are secured (i.e. they have permissions created either explicitly, or implicitly by biztalk when it stores sensitive information in the SSO DB, like adapter settings), and those probably use SIDs directly.
As for the change, I doubt you can make it in those two steps and still keep everything working in between (authentication won’t work very well).
July 2, 2009 at 4:03 AM in reply to: I want to route the incoming file (based on the filename) to different directories #22768You may have to assign this property to a string variable in an expression shape before the decide shape.
stringVariable = test(FILE.ReceivedFileName);
Then in the decide shape:
stringVariable.Contains(“ABC”)
July 2, 2009 at 3:26 AM in reply to: I want to route the incoming file (based on the filename) to different directories #22767Thanks for your reply.
I created an Orchestration Message parameter “test”
I have this in the expression of the decide block
test(FILE.ReceivedFileName).Contains(“ABC”)
I am still getting the error (Illegal dotted name)
Please let me know if I am doing anything wrong
I only have one Biztalk 2004 Server, and I do have a backup of the SSO Master Secret.
For the first stage, I just want to change the domain membership of the Computer Account from Domain1 to Domain2, and leave all the Active Directory Service Accounts in Domain1.
Thereafter, I’ll try to change the service accounts to Domain2.
Do you know if the SIDs of the Service Account and Computer Account of the BizTalk server is stored within the SSO Master Secret?
July 1, 2009 at 10:02 PM in reply to: I want to route the incoming file (based on the filename) to different directories #22765InputMessage(FILE.ReceivedFilename) will return a string with the received file name. Where InputMessage is the name of the message you receive in the orchestration.
You could try:
InputMessage(FILE.ReceivedFilename).Contains(“ABC”);
Make sure you installed the BizTalk Developer tools. It is a check box on the installation. If you think you missed it, launch the installer and you should see it either checked or unchecked.
I’m not sure that’s a supported scenario at all. I’m pretty sure your entire configuration will just go to hell, and will require significant work to get up and running (if at all possible). It’s not just the SSO; remember that all the security configuration in biztalk is tied to your domain, so you’ll need to fix all the database security roles in the biztalk dbs, fix up all the security groups used by hosts and other service processes used by biztalk, IIS AppPools, etc.
Regarding the SSO stuff, you need to remember that the SSO master secret is stored in the registry, protected by windows, in a location and encryption mechanism tied to the user account the SSO service is configured to run as. At the least, you’ll need to restore the SSO master secret to all your SSO servers (or only one, if all you’ve got is a single biztalk server) after you switch the accounts…. (you do have a backup of your master secret, right?)
Hi Clay,
In your Oracle database, create an auxiliary table with the same data structure as your main table where you will be pulling your records from, and add an extra column to that auxiliary table as an integer type column that serves as a batch increment indicator (which will be useful later on).
Still in Oracle, when creating your stored procedure, do the following:
– Define a parameter variable as integer type that will serve as the batch increment indicator
– In the body of the Stored procedure, define an INSERT statement to insert rows into your auxiliary table using the TOP predicate to select a range of records from your main table. In your SELECT statement clause, use a WHERE clause to filter against those existing records in the auxiliary table based on a set of criteria that defines the uniqueness of each record. Remember to include the above parameter variable in the SELECT statement.
– After the above INSERT statement, define a SELECT statement to extract those rows from your auxiliary table whose batch increment indicator value matches the value of the parameter variable.
Back in your BizTalk orchestration, after you have generated the SQL schema that matches the signature of the aforementioned Oracle stored procedure, in the flow of the orchestration, define a Loop shape where you will be first calling your Oracle stored procedure in request/response style through an adapter, passing a batch increment value (defined in a scoped variable at orchestration level), then you will transform the response message from the Oracle SP, and use its output message to pass into your SQL adapter call. Each time your orchestration goes through the loop, you will increment the batch increment value. The condition to terminate the loop is to check on the rows returned from the Oracle SP call: if there are no more rows in the last call to Oracle SP, then set a flag that will break out of the loop and terminate the orchestration.
Following up on my original reply to your post, there is another way to send all your 1.6 million records from Oracle to SQL Server in one shot: you will have to define your stored procedure in SQL Server to have a parameter variable of type Xml, which will then receive the BizTalk message in serialized format; however, you will have to parse the data in your SQL SP, using XQuery, to populate the SQL table on that end, which doesn’t impact the SQL engine performance-wise, but I have not tested this kind scenario with this volume of records and I don’t know what your level of skill is with regards to XML and XQuery parsing, in order to implement this.
I hope all this information helps.
Best,
Daniel.
I installed Biztalk 2009 on my machine, but the project templates don’t show up in Visual Studio 2008. Why is that and can i get them from somewhere?
Normal
0false
false
falseMicrosoftInternetExplorer4
<!–
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:””;
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:”Times New Roman”;
mso-fareast-font-family:”Times New Roman”;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:”Times New Roman”;
mso-fareast-font-family:”Times New Roman”;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
–>/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:””;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}Thanks Daniel,
When all is said and done I need to retrieve 1.6 million records from Oracle
and get them into SQL. I like the idea of limiting the number or records
fetched from Oracle. I could retrieve 10,000 record chunks and pass them
to SQL. Is there a simple way to do this, or documentation? I’m not
exactly sure where to start.Regards,
Clay
Thanks Greg!
No. It means that during a single poll, the adapter will pick up only *up to* 5 files. If more were found at that time, the rest are left there to be picked up at the next polling interval. Threads don’t enter the picture at that point, really.
Hi,
Thanks for the reply…
I have max number of files as 5…does this mean that if i have 10 files in the recv location , 2 threads will pick up 5 each or 1 thread will pick up 5 in 2 sucessive polls?regards
How many files are picked up on each polling interval will depend on the batch settings you configured in the receive location. I’m referring to the Maximum Files and Minimum Files options under the “Batch” category.
As for multi-threading, pretty much all adapters use multiple threads one way or another, but what is it exactly that you want to know?
Hooray, I have solved the problem by piecing together a couple of blogs on binary attachments and mime encoding.
Turns out that the way to do this is to convert the base64 data back to a byte array, create a editable memory stream from this byte array and add this using the message addpart() method. The following code that does this….
public static void AddMIMEPart(XLANGMessage msg, String partName, String partFileName, string encoding, String partData)
{
switch (encoding.ToUpper())
{
case “BASE64” :
StreamFromBase64 ms = new StreamFromBase64 (partData);
msg.AddPart(ms.CreateStream(), partName);
msg[partName].SetPartProperty(typeof(MIME.FileName), partFileName);
break;
default:
throw new Exception(“Stream is not in a recognized encoding type”
); -
AuthorPosts