07-30-2012 10:46 AM
Is it possible to deploy an entire EG project as a stored process? I would like to use the layout of EG to develop my program and then be able to call it remotely. I know I can export all the code into a single file but this does not preserve the conditional statements I have created. ex
07-30-2012 05:05 PM
Yes it is possible to deploy an entire EG project, just not at the project level. You will have to do it at the Process Flow level. With careful
planning it can be done, especially if you have several Process Flows in one project.
Also, as you have identified not everything that you create in EG, i.e. GUI, such as the condition statements, which I assume you
created by point-and-click, don't export out or can't be included in a Stored Procedure. See screen shots to see my point. The first
one shows the message you will receive when you attempt to create stored process by right-clicking on the Process Flow. The
second image shows that while there is an export created from GUI (and works fine), you cannot export it as code. This is
because it's part of EG/SAS Integration Technologies, built in . . . that's why you are not given a choice to export it as code in the second
Hope this makes sense.
07-30-2012 05:24 PM
Essentially my project is a Stored Process and I would like to keep the logical parts to my project split up like you can do within Enterprise Guide. I see that you can right click the process flow and create a Stored Process but then you would have to do that anytime you modify any part of the process flow from which you created the Stored Process. This though may be the method that I need to follow in order to get the functionality I am looking for.