xmla scripts in datastage

[Harini]

Hi all,

Can anyone tell me how to run xml scripts, in datastage?


Thanks in advance.

[eostic]

Check out the xml stages...each of them has some degree of ability to run xslt (albeit within the design of the stage, usually for producing columns of output to be sent to a link).

Otherwise, search the forum...there are lots of ways to invoke things outside of DataStage, assuming that you can call what you are doing now from the Operating System.

Ernie

[Harini]

Correction: It is XMLA

Thank you for the response.

I did search the forum, and most of them dealt with extracting data from XML, whereas my requirement is executing this script..

I guess, i have to run the file from unix, and then call the command from DS..

Would be happy, if anyone can throw some light upon this..

Thanks,
Harini

[chulett]

You would do this just like any other O/S command, depending on the need: Execute Command stage, Before/After ExecSH, DSExecute() etc etc. Many ways to skin that cat.

[Harini]

Thank you Craing..


Below is the sample file:

<Batch xmlns="http://schemas.microsoft.com/analysisse ... 003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ddl2="http://schemas.microsoft.com/analysisse ... 3/engine/2"
xmlns:ddl2_2="http://schemas.microsoft.com/analysisse ... engine/2/2"
xmlns:ddl100_100=
"http://schemas.microsoft.com/analysisse ... ne/100/100">
<Object>
<DatabaseID>Nwind2008</DatabaseID>
<CubeID>Northwind</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch


I would like to know how to execute this (unix command) after the job runs..


Thanks in advance,
Harini

[chulett]

How would you do it without DataStage? That is the question - and then you basically do that from DataStage.

[Harini]

No.. I meant executing the script is Unix's headache, isn't it?

I would like to know the command which would run the xmla file..

What datastage does is, it gives a option to run unix commands...
We can't say that datastage execute the script, can we?


Thanks and Regards,
Harini

[chulett]

You are missing my point, it seems. Yes, DataStage is perfectly capable of executing any O/S command, script or any other beast doesn't matter. After Job ExecSh in the job's Properties.

[Harini]

Yes, i got your point. Thank you..

Am not quite sure of the command used in Unix to run the XMLA files.. Any idea pls?


Thanks and Regards,
Harini

[chulett]

I've given you several ideas so far. Figure out how to do it outside of DataStage - I have no clue what that would actually be, never having heard of "xmla" and really wouldn't consider that a "script" - and then you'll know how DataStage can do it.

[Harini]

yes, it is just that, i was not confident whether one can execute a xmla file, from unix, like running a shell script.

I would have to write this is "After job sub-routine" in my job properties..

E:\Practise\filename

Hope i got it right..

- Harini

[chulett]

Let us know.

[mkolbe_IHC]

Any update on this? I've been told I can process an SSAS cube using XMLA and I'd like to do that in Datastage if possible.

[eostic]

One can only guess from the details of this thread that xmla is nothing more than an executable that "receives" its arguments, commands and properties from an xml document.

Perhaps xmla is "the" command from (said vendor) that looks for an xml document like the ones in this thread, and pulls out various properties. It's easy to see that the first example shows "Northwinds" which we all know is a demo database name for some SQL Server scenarios.

A quick search on google confirms this --- xmla (in at least one instance) stands for "XML for Analysis" and is some sort of Microsoft offering. Presumably you make a call in a Microsoft environment to something that takes this xml as input.

As noted throughout this thread --- if you know how to call if from the DOS command line (or from unix, if they have ported such a thing, or if other vendors use such a format), then you can invoke it in many ways from DataStage.

First figure out how to call or invoke this command line executable in the operating system of choice.

DataStage can certainly call and invoke such a thing, and of course, can help you "build" the xml needed to feed it.

Ernie

[ray.wurlod]

A Google search for "execute XMLA file" returned over 20,000 hits. Surely one of these will have your answer!