Schedule EG Project in DI Studio?

[deleted_user]

Is it possible to directly convert an EG project into a job available for deployment on our external scheduler (LSF)? In the past, we have exported all of our code in the EG project to one .sas file and incorporated that into the process flow for the job in DI Studio.

Is it possible to incorporate an EG project or project flow directly into a job in DI Studio?

EG 4.1
DI Studio 3.4

TIA,
doc23

[ChrisHemedinger]

No, it's not possible to schedule an EG project to run within DI Studio.

You can schedule a project to run on your desktop (using the Windows scheduler), or export the code as you have been and schedule that as a batch job within DI Studio or another tool (such as cron or AT).

Chris

[twocanbazza]

Hi Chris.

Are you looking at integrating in the future? Ie, having a similar deploy option in EG that registers the job in Metadata, or being able to export to DIS job.

Reason for asking is a lot of users use EG for the prototype/development for ETL then there is a hassle to re-create the job in DIS for deployment. I know would be easier to do in DIS first but people use the tool they know....

You comment "or export the code as you have been and schedule that as a batch job within DI Studio or another tool (such as cron or AT)."

If you do this you lose the good bits that DIS offers if such as impact analysis (only works well if job is created properly in DIS) rather than a code blob. etc.

This gets me on to the point of more integration between the different parts of SAS, EG development seems to be separate from all the other SAS products in regards to consistency in gui etc.

Barry

[LinusH]

What you could is for making this partly usable is to use the "Import SAS code" functionality in DIS (4.2 and later).
It will import your EG flow (.sas), and try to translate them into DI transformations and tables. All steps will end up as User Written code, but if you are lucky, tools such as Impact analysis will work.

/Linus

[twocanbazza]

I was waiting for someone to suggest that tool, it has it good points however I have had a play with this and found it doesn't seem to match up metadata objects if they exist in the code and metadata so a lot of work is required afterwards... but yes that tool does help somewhat....