SOLVED: Export DataFlows to XML using command line

dataservices job design
1

Hi all,
Having posted about 6 questions, I thought it time to put something back in…

I needed to export a dataflow to XML and found it poorly documented; so here it is:

Using a command window, CD to C:\Program Files\Business Objects\Data Integrator 11.5\Bin or whereever BODI is installed for you.

The command to run is al_engine -Uxxxx -Pyyyy -Qzzzz -XXD@“C:\output.xml”@aaaa

Replace:
xxxx: repository username
yyyy: repository password
zzzz: repository database connection
aaaa: dataflow name to output

Note the option -XXD which is export dataflow to xml, took a while to workout that I had to use D and not Dataflow or something else.

Hope this helps.

ignition00 (BOB member since 2007-07-16)

2

Enter al_engine by itself to produce all the available documentation on al_engine. Pretty straightforward.

SteveLN (BOB member since 2007-12-11)

3

In order to export Access data to an XML file, follow the steps:

Step 1:
Click on the External Data Ribbon, then choose Export More XML File

Step 2:
Access will ask for the path to store the XML file. It will provide option to browse to the location to choose the path and name the XML file.

Step 3:
This involves the step to choose the file type. By defualt access provides 3 file types. Namely
Data (XML) – creates a XML file with all the content of all the records in the table as selected.
Schema (XSD) – it doesn’t contain any data, but stores the definition which describes the selected table.
Presentation (XSL) – defines how a browser can convert the data in the XML file into HTML web page (which displays normally online).

If one wants to export the related tables as well one can select the more option on this screen.Here in our example we choose the first option [Data(XML)].

Step 4:
Click on OK to generate the XML file.

Step5:
If some one wants to repeat this same process without going through the wizard once again, then they can do so by checking the option “Save Export Steps”.

Eliza

elizas (BOB member since 2010-02-15)