Question

  Asked: Mar 21 2008   6:58 PM GMT
  Asked by: SQL Server Ask the Experts


How do I integrate SQL Server Integration Services and Blaze Advisor?


SQL Server, Business Intelligence, SQL Server integration/interoperability, SSIS

I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the source data.

How can I integrate the "Blaze Advisor" to "SSIS” (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?

I wrote the rule in the Blaze Advisor and imported its rules into .Net files, 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, and it is demanding for *.Server and *.Client files there.

Can you suggest 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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



You will probably need to contact Blaze Advisor and see if they have an SSIS module which can be used to drive the changes.

Another option would be that you setup all the settings within SSIS to be dynamic and have the package first query for all the settings from the Blaze Advisor database (I assume that it has one) and then adjust the SSIS package based on the output from the Blaze Advisor database.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and DataManagement.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register