PMML And BizTalk
Mar 15, 2007Hello! Anybody know if can I use (and
how can I use) PMML with the rule engine of Biztalk Server, or if there
is some module that translate PMML format to Biztalk. Sorry by my
english.
ADVERTISEMENT
Getting The Model's (Decision Tree) PMML
Feb 19, 2007Hi
Can anyone tell me the steps involved in retrieving a model's (decision tree) pmml and use the model content to devleop a web based interface. I am using SQL Server 2005.
Thanks,
Nathan
Question On PMML For Data Mining
Apr 23, 2007Hi, all experts here,
Thank you very much for your kind attention.
I am having a question on the PMML for data mining. As we know PMML enables the deployment of data mining models over all the major data mining vendors' data mining platform. I want to make sure what features of data mining models are exchanged actually? Are only the contents of the mining models? Or all the relative features (from data source, data source view, atrtibutes etc. ) ? And can we reprocess the data mining models from the destination platform where the mining models are deployed different from where they are created?
I am looking foreward to hearing from you shortly and thank you very much.
With best regards,
Yours sincerely,
Can A SAS PMML 2.1 Compliant Model Be Imported Into SSAS 2005?
Mar 3, 2008Is it possible to import an SAS PMML 2.1 compliant neural network model directly into SSAS 2005?
Are there other or all SSAS models (e.g. Decision Trees) that can be created from an imported SAS PMML 2.1 compliant source?
PMML: One Node In A Decision Tree Containing Two States Of An Attribute As The Rule For Splitting?
Sep 22, 2006Hi,
is there a way to import a decision tree-model from pmml where a node contains two or more states of an attribute as the split-rule?
Example:
...
<Node recordCount="600">
<CompoundPredicate booleanOperator="or">
<SimplePredicate field="color" operator="equal" value="red" />
<SimplePredicate field="color" operator="equal" value="green" />
</CompoundPredicate>
<ScoreDistribution value="true" recordCount="200"/>
<ScoreDistribution value="false" recordCount="400"/>
</Node>
...
This node shoud contain all cases, whose color is red or green (The Microsoft DecisionTree-Algorithm would build a model with two steps like red/ not red and then green / not green). According to the DMG, this is valid PMML 2.1, but when trying to import the server complains about an unexpected value in the SimplePredicate-tag.
How can i import such a node in SqlServer 2005?
Thank you in advance for any help
Chris
SSB BizTalk Scenarios
Aug 18, 2006What are the specific types of scenarios where we could use SSB and BizTalk in tandem?
I have come across a gotdotnet sample of an SSB adapter for BizTalk. As i understand a Biztalk orchestration could be an end point for the SSB conversation.
But what advantages can be obtained using this as compared to a typical SQL adapter for BizTalk which does CRUD operations on DB.
any pointers in this directions would be helpful
TIA
Paritosh
Biztalk Vs SSIS As An ETL Tool
Jan 14, 2008Hello,
At our company we are considering building an architecture for file
imports and processing and considering both Biztalk and SSIS at this
time.
My understanding from reading the material out there regarding this
subject that Biztalk is more suited for integrating applications and
real time communication of information and SSIS is more suited for
bulk loads into databases/data warehouses and data manipulation.
Currently we are somewhat along the lines described above, but there
is a desire to use one technology over the other for importing files
and data manipulation, and I am not sure that is practical. Also
there is a debate currently as to whether Biztalk does better at
handling logic than SSIS.
I have read through the article on microsoft site that outlines the
above - http://www.microsoft.com/technet/prodtechnol/biztalk/2004/whitepapers...
However, I would like to get some input from people who have actually
used both these tools in the real world for ETL process and could
provide some insight so as to help us make an informed decision.
Thanks
KR
SQLSERVER Config For Biztalk
May 4, 2007Hi,
I have installed SQLSERVER 2005 in Windows 2003 Server with mixed mode authentication.
Now I am unable to connect it from my windows Xp client system. When I specify the credentials the following error msg displays
"Specified Database cannot be reached Incorrect Server name or login. User may not be associated with trusted sqlserver connection"
My Server Config as follows
servername :vijay
login details:
sa;sa
In Biztalk server 2006, Cofiguration wizard I gave server name as "vijay"
and
username : sa ; pwd : sa;
Kindly help me in getting it right.
Thanks
Vijay
Difference Between SSIS And Biztalk
Dec 29, 2006Hi
Can anybody please tell me the basic differences between Biztalk and SSIS and when to choose which technology over other?
Regards,
Sandeep Saran
Biztalk 2004, One Stored Procedure For 2 Tables
Dec 15, 2006Hi,
I have an orchestration that recieves a pricelist flat file and it must insert into 2 tables - article, articlePrice(for each LotSize) into sql server using a sql adapter. I also want it to check if a record exists for that lotSize and update it if it does. The records are indentified with a uniqueidentifier. So I have 3 if statements:
1 - if (<the article does not exist(checks SupplierArticleNumber)>)
<insert a record into article table>
<insert a record into articlePrice table>
2 - else if(<the article exists but not for that lotSize>)
<insert a new record in articlePrice table>)
3 - else
update the corresponding ArticlePrice row.
My problem is in writing the sp, first it checks if the article exists, if it does then it creates a row in the article table and then one into the articlePrice table. My question is how do I get a hold on the "articleGUID"(pk - uniqueidentifier) that was created on the first table on insertion in order to create the row in the second table(fk)?
And is this possible with one stored procedure? If not does anyone know in Biztalk what other way to do this?
I am new to both Biztalk and sql, so I don't really know what I am doing? I would really appreciate any suggestions!
pp
Which Edition And Build Of SQL Server 2005 To Use For Biztalk 2006?
Oct 12, 2007Hi all -
We are planning to use a 2-node SQL Server 2005 cluster as part of a new Biztalk 2006 project, and I would like some advice regarding SQL Server service packs and editions.
Testing has already been running for some time without problems, but the test environment (a) is not clustered, (b) is using SQL Server 2005 Standard Edition rather than Enterprise and (c) has neither of the SQL Server service packs installed.
As this is a major project for us, my instinct would be to use Enterprise Edition (maximise performance and scalability)
and to apply SP2 (because I thought it was best practice to be up-to-date). I would have liked to do this before we go Live so we don't run the risk of having to change afterwards if we hit a problem.
Understandably, the project guys' perspective is this: testing so far has not been affected by SQL Server bugs, and we should go Live with the environment we have tested in, albeit with the planned 2-node cluster which is seen as a 'must have'.
I have trawled Books Online, Technet and other resources without success, so any thoughts or info on required, recommended or preferred combinations of Biztalk 2006 with SQL Server 2005 editions and service packs in a clustered
environment would be greatly appreciated - thanks!
Michael
SSIS Calling Into BizTalk Business Rules Engine (BTS BRE)
Oct 11, 2007Hi,
We are planning to use the BTS BRE for our business rules and calling these from a data flow transformation (e.g. for every row in a flat file during import). One way would be to use a script component.
However, the question is that the script component would have to create and destroy BRE objects (e.g. a BRE Policy object) for every row in the flat file.
Is there a way to instantiate objects and whole on to them for the lifetime of the package or a container within a package?
Any suggestions regarding achieving the above most efficiently would be much appreciated.
Regards,
TD
XML Request (send) And XML Response (receive) Data Thru BIZTALK 2006.
Oct 2, 2007I am new to BIZTALK 2006; Please help me get started as below>>
I have XML Request (send) and XML Response (receive) data;
What are the steps needed for this to be accomplished in BizTalk to create webservice for this?
THX
How To Create A Trigger Such That It Can Delete The Rows Whenever Any Other Application Such As Biztalk Had Read The Rows ?
Mar 12, 2007I had created a trigger which sees that whether a database is updated if it is its copy the values of the updated row into another control table now I want to read the content of control_table into BIzTalk and after reading I want to delete it.Can any one suggest the suitable ay to do this?
View 3 Replies View RelatedSQL Server To BizTalk Server
Apr 25, 2003We are evaluating BizTalk as an "hub" in our integration strategy. Does anyone know how (or if it is possible)to place transactions from SQL Server (f.ex. by using triggers) into a message queue which BiZTalk can receive from ?
Any other suggestions on how to connect SQL Server and BizTalk ?