Skip to Content
avatar image
Former Member

Export Jobs to ATL from BAT file

Hi Experts,

I would like to know how to export jobs into .atl files with Data Services XI 3.2 using al_engine.exe from a BAT file.

I found some tips but I am unable to get the same ATL output file as from the GUI export.

%LINK_DIR%\bin\al_engine.exe" -NMicrosoft_SQL_Server -Ssqldb -QDSRepo -Uuserid -Ppswd -XpJ@jobname_JobBt.atl@jobname_JobBt@D

I want to exclude the DataStores and export a single job to a single ATL file.

This will allows us to keep versions of the jobs in an SVN library for source code versioning.

I have been able to import the ATL files with this method thanks to sample BAT file from:

http://wiki.sdn.sap.com/wiki/display/Snippets/DataServices-ATLImport+Automation

I have been able to export the entire repository with the -X parameter successfully.

%LINK_DIR%\bin\al_engine.exe" -NMicrosoft_SQL_Server -Ssqldb -QDSRepo -Uuserid -Ppswd -X

Kind regards,

VA_pdj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 06, 2012 at 07:50 PM

    Hi,

    as far as I know, you cannot export ATL files the way you are planning to do (you probably could write a script that removes the unwanted information, but that might be cumbersome).

    What you can do, though, is to do an XML export. Thus, in case it would be acceptable in your situation to use the XML import/export, you could use the functionality from al_engine (I only tried with the windows version, maybe it is different under Linux/UNIX).

    You could use the following command

    al_engine.exe -NMicrosoft_SQL_Server -UUserID -PPassword -Shostname -QRepo -XX@J@filename@jobname@D
    

    If there is a function to do this via ATL, it is well concealed.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thank you for your XML solution - unfortunately we already have all of our jobs in SVN in ATL format, so changing to using XML files is not going to fly.

      It is unfortunate that the al_engine.exe process does not appear to be working for Export of individual ATL jobs.

      Wonder if it is on the SAP radar to get it working properly eventually.