xmla scripts in datastage
Moderators: chulett, rschirm, roy
xmla scripts in datastage
Hi all,
Can anyone tell me how to run xml scripts, in datastage?
Thanks in advance.
Can anyone tell me how to run xml scripts, in datastage?
Thanks in advance.
Last edited by Harini on Tue May 11, 2010 5:32 am, edited 1 time in total.
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
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
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Correction:it is XMLA
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
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
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
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
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
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
Last edited by Harini on Tue May 11, 2010 6:35 am, edited 1 time in total.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1
- Joined: Thu Dec 16, 2010 5:07 pm
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
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
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: