SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Running data quality jobs using a .BAT file under the SAS licence structure

Reply
Occasional Contributor
Posts: 19

Running data quality jobs using a .BAT file under the SAS licence structure

Hi

I hope somebody can advise..

Until now, we have had a Dataflux licencing structure (v2.5 of DMS) and have been running jobs using the dmpexec.exe module

Our .BAT files would contain code to initiate the job and look something like this eg (taken from the SAS Help documentation - an actual example has been attached)

"C:\Program Files\SASHome\DataFluxDataManagementServer\[instance_name]\bin\dmpexec"

We have recently moved to a SAS licence structure and installed v2.6 of the product.

My installation hierarchy structure now looks like

"C:\Program Files (x86)\SASHome\x86\SASStudioSingleUser\3.3......"

Below this are directories names \build, \installs, \lib and \war

Can anybody please advise where I can find the exec module to enable me to run my jobs in a batch mode and what my batch file should look like now

(and SAS - could you please update your documentation to reflect this too)

Thanks

Nigel

Attachment
SAS Employee
Posts: 75

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to NigelLight

Here's the DM Studio 2.6 user guide topic about running jobs from a command line:

Running Jobs from the Command Line

Does the subheading "Using the dmpexec Command for DataFlux Data Management Studio" help?

Occasional Contributor
Posts: 19

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to DaveR_SAS

Hi,

Thanks but unfortunately this doesn't help as this refers to the dmpexec module which used to be there under the Dataflux installation but is no longer there under the new SAS structure - see original post

Regards

Nige

SAS Employee
Posts: 75

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to NigelLight

dmpexec_26.jpg

Nigel, in my 2.6 image, I see a dmpexec command file and script file in the bin folder. Do you not see these in your 2.6 image?

Occasional Contributor
Posts: 19

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to DaveR_SAS

Hi,

Sadly I'm now different to this ...

This looks like out old Dataflux installation (as per our 2.5 installation). We now have a SAS installation/licence and don't have the dmpexec module any more

The Dataflux Bin directory now looks like this (with only .dll files below the snap) :

Dataflux Bin directory.JPG

The SASHome directory looks like this

SASHome directory.JPG

A totally different set-up and nothing like yours:smileyconfused:

Nige

Occasional Contributor
Posts: 19

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to NigelLight

:smileygrin:Found it  (or think I have)... it is in the Program Files directory, not the Program Files (x86) directory (as usual)

Looks like SAS now have SASHome in both directories!

SASHome directory.JPG

Off home here now - end of the working day in Europe but I'll give it a go in the morning

Thank you for your assistance

Nige

SAS Employee
Posts: 75

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to NigelLight

Thank you for describing your installation! I'll look into this.

SAS Employee
Posts: 75

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to NigelLight

Nigel, the screen shots above show SAS Studio 3.3 in the path, which is different than DataFlux Data Management Studio 2.6. DataFlux DM Studio is a 32-bit application, so I would expect it to be in the Program Files (x86) folder. Based on what 2.6 doc says, I would expect the path to dmpexec to be something like:

C:\Program Files (x86)\...[dmstudio_install_home]\[install_instance_name]\bin\dmpexec.*"  

Is that not what you are seeing?           

Occasional Contributor
Posts: 19

Re: Running data quality jobs using a .BAT file under the SAS licence structure

Posted in reply to DaveR_SAS

Dmpexec 2.6.JPG

Hi,

Thanks for the answer - it may be that, when we installed, we had an option of installing in either 32 or 64B mode. We chose the latter (since we run Windows 7 in 64B) - knowing that this previously was only a 32B application Smiley Sad

I was wondering on the way into work this morning whether SAS has split the installation to accommodate this action.

nb Sorry - in my haste to leave last night I attached the wrong screenshot:smileyblush: hopefully this one is more useful

Nige

Ask a Question
Discussion stats
  • 8 replies
  • 514 views
  • 3 likes
  • 2 in conversation