cancel
Showing results for 
Search instead for 
Did you mean: 

Data Extraction from BWP to ETL

Former Member
0 Kudos

HI All,

We have a ETL tool Informtica which pulls some of the data from BW and stores in a DB.

At present the Informatica Jobs are failing, due to "Time Limit is exceeded" for reading the BWP table.

as per Basis team advice, Those Jobs are running in a DIA mode and time for extraction is max(4 hours) is already in place and it has to be change to BGD process.

- How to change the DIA Job to BGD process ?

-Is this change has to be done in BWP side or Informtica ? since the extraction is done by Informtica.

- As of now there is NO option to increase the extraction time in DIA Mode.

Kindly let us know your suggestion.

Thanks is Advance !!!

Accepted Solutions (0)

Answers (2)

Answers (2)

RamanKorrapati
Active Contributor
0 Kudos

Hi,

if your executing job at informatica side you need to run your job in background.

About those you can check with informatica team who was familiar about job scheduling.

if your executing job in bw then you may used process chains, if yes then those automatically executed in back groundas per the scheduled times.

Another work around:

if your job which pulls data from bw to inforamtica, is possible to split based on selections, then you can split it by using possible filters.

About ETL mechanism am not aware, please think about filtering and pulling less data.

Thanks

former_member186399
Active Contributor
0 Kudos

Dear Shashi,

How is the job in BWP scheduled. Is it through process chain. If not you should route your jobs through process chain so that the bgd workprocessers are used.

Also an extraction running for more than 4 hours is going to create problems. So can you  check what kind of data is getting pulled up and how.

Regards

Gajesh

Former Member
0 Kudos

HI Gajesh,

Thanks for your reply !!!

Informatica Jobs are extracting the records from BWP table..

From the details i could see , SQL statement - Only a select query is used.

From the Image there are list of DIA job is on HOLD and while one job is running state

former_member186399
Active Contributor
0 Kudos


Dear Shashi,

Not much information on how informatica works. But when you are using a 3rd party tools there are connection which supports extraction through Open hub destination. Please check that option.

If you are using OHD the jobs can be triggered through process chain and therefore wont have this jobs running for long time.

there are documents available in net which can provide you on this integration

Regards

Gajesh