How to integrate "Blaze Advisor" rule engine to "SSIS"?
Hi,I am a Microsoft BI Developer and currently working on Pharmaceutical BI project. In this project, Client wants to integrate his Blaze Advisor rule engine to SSIS so that he can change the rules in Blaze advisor any time and see the effect of it on the source data. Hence, my question is:How can i integrate the "Blaze Advisor" to "SQL Service Integration Services" (Microsoft SQL Server ETL tool) which will use my Business Rules ( Written in Blaze Advisor) in the transformation task and process all my source data with the same business logic?My Trails to Solve this problem:I have written the rule in the Blaze Advisor & Imported it's rules into .Net file which includes *.Server, *.Client and some other files. I have used the DLLs in this solution in my SSIS script task but it's not supporting to it. It is demanding for *.Server & *.Client files there. - Can you suggest me a way to integrate SSIS with Blaze Advisor? - How can i use the Blaze Advisor's .Net output files as DLLs into my custom transformation?I'll be really greatful to you if you could suggest me an approch for this particular business problem.Thank You!Regards,Sandeep
March 15th, 2008 4:37pm
It would be very halpful if you were to share some information with the community what "Blaze Advisor" is, how it works,and how you hope to use it - this will be key to providing any meaningful feedback to you. With this said, you can call any .NET assembly from the Script Task (for control flow) and Script Component (for data flow) or you can build your own custom tasks and transformations. There is a great volume of information readily available online - all you need to do is search for it. If you're looking for more specific input, you'll probably need to ask some more specific questions.
March 15th, 2008 11:16pm
Hi Matthew, Thanks for the reply. As you've suggested the resources for the Scripting SSIS tasks, I've already gone through those such as Scrpting SSIS book by rational Press, Expert SSIS, All the SSIS webcast released by microsoft (2005 & 2008 both), blogs such as Simple-talk & conchang. Buth here the case is too complex & bit different as below: Blaze Advisor is Rule engine which is used to write all the Business Rules/Logic & Functional Rules for the whole organization at one place. This Blaze advisor is used as a central repository for all the business rules and all the processes & workflows within the organization are run through these rules. Why it needs to be integrate with SSIS? For SSIS, Blaze Adviser will act as a Transformation Task (Engine) where I'll define all the rules for the transformation So that at any point I can change these rules easily and study the impacts of the changes in the rule on the output data. However, Thanks for your kind notice. -- Sandeep
March 17th, 2008 7:03pm
As Matthew said, you should be able to reference the .NET assembly from a script component. It sounds like the .DLL needs these other files but can't find them for some reason.Where do those files normally reside?
March 18th, 2008 5:04am
Hi, I am going to use Blaze advisor too, but I've no idea how to use and implement in my project with Blaze Advisor. I mean how Blaze Advisor works with projects, Is there any example that how can I start it. Any help kindly appreciated.
March 27th, 2008 4:45pm
HI sandeep, Following issues that we have faced while creatin.NET DLL 1) Created a class which contains some properties in it. And created a ruleset which contains some rules. Defined ruleflows which contains rulesets. Tested the rules by writing the main function in Blaze itself then it works fine and got expected results. But while deploying we are unable to see the class name In the dropdown list in the wizard. We stuck up here. Is this the right way of deploying? Can we deploy the class which is created in Blaze advisor itself? 2) We tried in another way by importing the .NET class into the Blaze and followed the same steps as above and tried to deploy. Then we got a .NET application as output. This application contains client.cs, server.cs etc and one solution file. We edited the projects in VS2005 and Tried to build the application, but we failed to do it as we got so many errors. We are unable to resolve those errors. What is the use of this .NET application that we got as an output? So can you please suggest us that how can we use the rules created in blaze into our .NET application. Thanks & Regards ChandraSekhar
June 18th, 2008 11:22am
Hi chandra Sekhar ,my client also want to use blaze advisor to force business rules kindly can you help or provide me some link how to deploy blaze advisor as webservice and use it in our application.thanks in advance !!!!!mahender
March 4th, 2009 9:11am
Hi Sandeep! Did you ever get anywhere with this project? I am faced with a similar task. Thanks! MikeMichael R Milligan
December 15th, 2010 1:56pm