topic Re: Exporting Business Rules from Different Server in Administration and Deployment

Exporting Business Rules from Different Server

JohnJPS — Wed, 12 Sep 2018 13:26:48 GMT

We are trying to facilitate automated archival of artifacts during a "move to production." Our process runs on our production environment and may include MAS components, the building of which involves work in Decision Manager. We don't really care about DM for supporting MAS, but wanted to allow users to specify a DM folder, and we would automatically call the BRM_EXPORT* macros, and archive it all.

So, the question is - is there an easy way to invoke the BRM macros in one environment, when calling from a separate environment? (About all I can think of is remote procedure call to sasbatch, with a .sas file that specifies what to run), but that just seems a bit complex... can we call the BRM macros from any API accessible from C#?)

Thanks - John

Re: Exporting Business Rules from Different Server

JuanS_OCS — Thu, 13 Sep 2018 14:00:53 GMT

Hello @JohnJPS,

here my ideas to you:

1- Easiest, but might require additional SAS license: to make use of SAS/CONNECT if you do have it on both environments.

2- Create a scheduled task (local, in source environment) that runs every X time and checks for an empty file. If present, executes the export and places results in a shared folder (to the destination environment), of course deleting that empty file once the process is finished.

3- Use remote commands such as sysinternal tools if you are in Windows, or ssh if you are in Linux.

4- A funny but interesting option: create a stored process and convert the stored process into a Web service, what would allow you to call it with normal HTTP request (soap, json) or rest API.

The trick is to create as small and simple components as possible, with easy communications/interfaces too. 🙂

Re: Exporting Business Rules from Different Server

JohnJPS — Thu, 13 Sep 2018 15:52:53 GMT

I actually went with #4... what I'm doing is pretty trivial and it seemed like such overkill to do it any other way. The stored process is just a few lines of base SAS, and calling it via SASBIWS/json is a great, simple solution. Thanks!

Re: Exporting Business Rules from Different Server

JuanS_OCS — Fri, 14 Sep 2018 07:16:15 GMT

Good choice! I would have gone for that one as well 🙂 Glad to hear it helped