DSXchange

If someone had noticed already.
SAP BW Pack V4.3.3 (not V5) released by IBM on Oct 25, 2016 - supports Netweaver 7.x data sources.

Cheers,
Abhijit Gaikwad

Excited sharing a good news. :-) Latest PACK for SAP is V8 (released per GA), whereas latest PACK for SAP BW is 5 (GA release is planned towards end of September 2016). Just heard from a known IBM Pre-sales person, Switzerland. So far version 4.3.2.3 PACK for SAP BW restricted the Data Stage users t...

I can share my way of doing something similar. XML stage from Data Stage could not help me much, owing to sheer volume of data being transformed within the ETL job. Moreover, there were several XML files being created in the output directory. The only good thing about the XML stage is the dynamic wa...

SReddy,

Show us the problem and we suggest you a good remedy.

The Hash file is simply not there. Kindly make sure that the file exists, use command line to verify if you need.

Hari,

I request you to rephrase your query and also assist that with WHY?

Some of our colleagues at DSXChange may suggest you a better design.

Pls dont explain what stages you have used or you intend to use. Let the readers decide it for you.

I hope, you get a quick answer.

Arpit,

Pls get in touch with your DBA, he would certainly be in good position to help you.

He may also help you know the differences in the behaviors of your queries (Toad and DataStage).

Lastly, try posting your query here.

Kind regards,
Abhijit Gaikwad

Shruthi,

Kindly explain us the logic for sorting the files.

Files may be sorted on following attributes:
Modified Date
File Name
.
.
.
Many othet atrributes

I hope, that helps.

Dear san, Firstly, no text file is delimited even if we call it a delimited file. Lastly, this point is very important to understand. Delimiter is readers way of parsing the text contained within by assuming a delimiter. e.g. For argument sake, let us take the following A,B,C E,B,G 1,B,3 7,B,9 Anybo...

I think, I got the answer. services file under windows\system32\services\etc shows this information. sapdp00 3200/tcp sapdp01 3201/tcp sapdp02 3202/tcp sapdp03 3203/tcp sapdp04 3204/tcp sapdp05 3205/tcp sapdp06 3206/tcp sapdp07 3207/tcp . . . sapgw96 3396/tcp sapgw97 3397/tcp sapgw98 3398/tcp sapgw9...

Thanks Chanaka, Krishna. May I know where are they defined in BW environment. I do not have much idea. I am more keen in knowing whether the communication from DataStage 8.1 to and fro is not blocked by the firewall. Do you think opening these port ranges be sufficient ?? Thanks in advance. Kind reg...

I doubt what you say Chanaka.

Netstat-a shows me ports (ranging from 1011-1055) connected to SAP BW server.

Had to go for complete (from scratch) installation.

Problem solved.

Friends and Seniors,

Does anybody have an idea about the ports used while conversing with SAP BW?

Should that change assuming SAP BW is replaced SAP Netweaver BI 7.3 ?

Any information in this regard is appreciated.

Thanks and many regards,
Abhijit Gaikwad

Hello simonico1982,

Inadequate details, you have provided. It shall lead you nowhere.

Kindly put in necessary details.

Abhijit

Hello, The newer packs are being released by IBM from time to time. For knowing the latest BW pack for DS 7.5 for BI7, you need to get in contact with IBM Sales/Support. F.Y.I. DS 8.1 comes with a version of 4.3.2.10 for BW Pack and it supports both BW 3.5 and BI 7.0. Other imformation can be gather...