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

Tags:
Business Intelligence
SQL Server
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following