cancel
Showing results for 
Search instead for 
Did you mean: 

Using Informatica/ETL as target system

Former Member
0 Kudos

Hello,

We have a scenario which we would like to use Informatica/ETL as target system.

Is there a connection option in SAP SLT to allow connection directly to Informatica/ETL?

Thanks,

Ky Can

Accepted Solutions (0)

Answers (1)

Answers (1)

Saritha_K
Contributor
0 Kudos

Hi,

With DMIS SP2011 SP 05, it was mentioned that SAP SLT would not only allow replication to SAP HANA and SAP BW, but would also allow replication to ABAP Based targets and SAP supported DB  on a project basis. We are yet to see some official documentation on how SLT would actually support non hana target systems.

There has been a similar requirement in the past for SLT to non hana target system. Please refer to this link as well once - http://scn.sap.com/thread/3302946.

Hope it helps.

Regards,

Saritha.

tobias_koebler
Advisor
Advisor
0 Kudos

In general SLT can be connected to all SAP NW supported DBs.

   


 

MSFT  SQL Server Enterprise
  Edition


 

 

Oracle Enterprise Edition


 

 

IBM DB2 LUW/ UDB (DB6)


 

 

IBM DB/2 zSeries


 

 

IBM DB2 iSeries (former AS/400)


 

 

IBM Informix


 

 

SAP MaxDB


 

 

Sybase ASE


 

 

SAP HANA


 

Anything else is not covered. I am not sure which DB Informatica is using.

In addition SLT has an integration with Data Services to get leverage the advantages of both worlds, so if Data Services is able to write to Informatica, we can put SLT for delta and real-time and DS to post to Informatica.

Best,

Tobias

Former Member
0 Kudos

Hi Tobias,


Informatica/PowerCenter is an ETL tool similar to DS, we wish to be able to connect directly to it.

If SLT can connect to DS, I think it's possible to do the same for Informatica.


Can you provide link on instruction how to connect SLT to DS?


Best,

Ky Can

tobias_koebler
Advisor
Advisor
0 Kudos

SLT stores the data in ODP (ODQ). DS or also BWonHANA is connecting to this framework and pull the data. I do not think Informatica cannot do this.

Best,
Tobias

Former Member
0 Kudos

Hi Tobias,


A pointer to instruction how to configure DS to pull from SLT would be helpful.

We will try this in Informatica and let you know.


Best,

Ky Can