DSXchange

We removed the .imf file , reconfigured the Idoc. After that we have been able to read all the necessary fields.

Working on 8.7.0.2 I am reading Idocs from SAP ECC , I have no issues reading most of the segments, but in one particular segment I am unable to read the data in a few fields. Although I am able to select the fields in the segment. I can see that the fields have data in SAP WE02 and also in the Idoc...

Correct, we have the license of the SAP Adaptor. As I mentioned earlier we have an Integration partner who is trying to load to SAP using LSMW , which I feel is very inefficient, takes days to load 1 million rows , hence the approch of using DataStage to load SAP. So if we use Idocs, the integrator ...

Correct, we have the license of the SAP Adaptor. As I mentioned earlier we have an Integration partner who is trying to load to SAP using LSMW , which I feel is very inefficient, takes days to load 1 million rows , hence the approch of using DataStage to load SAP. So if we use Idocs, the integrator ...

We are trying to move from Legacy systems to SAP , what I am trying to understand is , can we load the data from Legacy system to SAP using IDocs via DataStage. For eg can I load materials into MARA table.

Hi

Is it possible to load data directly into SAP tables using Idocs ?

-Ganesh

Important : Make sure the firewall is open on port 1521 between your ETL Server and Oracle DB Server.

I am trying to select a job to associate to the operation, but it shows me to select a Server job, can we not a select a Parallel job ?

How would I convert it from binary to ASCII

I am reading an EBCDIC file in which there is a binary field, based on the value of the binary field I will have to read different segments of the record. I can read this field as binary from the file but in the transformer I want to write a constraint against this field to determine the segment. eg...

Thanks lstsaur, point duly noted.

I am using 'call' , this gives the correct results.

I am trying to call Oracle Package using Oracle Connector using the PL/SQL Block , exec ACMS.util_acms.truncate_table('ACMS.ACRU_MNTNC_WRK') but I am getting an error : Error code: 6,550, Error message: ORA-06550: line 1, column 12: PLS-00103: Encountered the symbol "ACMS" when expecting o...

Please let us know what he resolution to this was

I think I am missing the Xp 64 bit libraries..but am not sure.. is there a way to check which one I am missing....

-G