DSXchange

Yes I know we are doing ETL and not presentations. But I thought might be able to execute an API or so from a routine passing the data or using excel or so.

Have anybody done that before?

Anyway, thangs you guys for the answers.

Hello All,

I'm having a request to process some Data from CSV Files and create some charts as a result.
Is it any way to do the creation of such graphics in DataStage ?

Any hint would be great.
Thanks a lot in advance

Note that this is not the Execute Command stage but rather the Execute stage which is unique to a Windows server install. Not the same animal. Thanks for the reply, but I dont understant to whom you call animal. Anyway, Yes, I have Server Edition in a Windows System installed and I see the name of ...

From the command line (CMD): powershell -File Script1.ps1 (works good) From Powershell : .\Script1.ps1 (works also good) In DS Execute Command Stage : - Command = powershell - Parameters = -File <scriptpath>\script1.ps1 Error: --------------- Backup_Test..JobControl (@Execute_Command_1): Executed: p...

Hello Guys, I 'm having problems when I want to execute a powershell Script remote from an Execute Stage or in a routine using CALL DSEXECUTE. So, the script ist to execute Db Backups locally on the remote server and it works just fine when I run it from my CMD or PS shell. Nevertheless, when I do t...

That souds very good idea.

Please can you make visible the entire message to me, because I'm still not a Premium member.

Thanks a lot in advance

Hi Guys, I have the following Situation: I have to create an XML File with 1 Header and 1 Content Group per row from Input File. Everything works fine as Long the Input Rows contains different data. The problem is when some rows have exactly the same data. Then, the XML Output Stage builds a group f...

Thanks a lot Ray!. I have done as you suggested and worked perfect.

Thanks a lot for you help

Rgds
Max

Thanks a lot for your reply, Ray. But unfortunately, I'm still not a premium member and I cannot see the full message.

Would it be possible for you to reply ot my message in any other way, or tu send the reply to my email.

Thanks a lot in advance
Rgds
Max

Does anybody have any hints regarding how to reject rows in a transformer when they have NLS Errors? My Job Looks like : XML Input file --> Transformer --> Hash File What I want to do is to check NLS compatibility in every row I read in the transformer and reject the ones not compatible or the ones ...

You have a lot of pre-work to do.... a) determine how to call a web service from Java. Get it working stand-alone. This is a java skill independent of DataStage. If you don't know how to do i ... Thanks for the reply but I cannot see your comments because I'm not PREMIUM Member. Can you post it in ...

Hello all, I have a requirement to implement a Job where I have to call a Web Service using SSL Authentication (Client Authentication only), provide an XML as Input and receive and XML (from the web Service) as Output. The Problem is, DataStage doe not Support Client Authentication but mutual authen...

This can potentially be a very complex process...."if" the wsdl describes nothing but a single large column to be sent to the service, then this is the general methodology.... (xmlinput to wsTransform ... Thanks for the reply, but I'm not a premium member and can't see the entire answers ...

Hi all,

I need to use SSL .p12 key to authenticate with the WSDL service.
Can somebody tell me how can I import the ssl key in DataStage?

Thanks

Hello all, I have a request to imnplement a WSDL service in order to send xn XML as request and to receive an XML with response. The job I have created is. Folder --> XML_INPUT -->WSDL Client Just to see the response in the log file, but after XML_INPUT I'm getting the following error: NRR_Target..X...