Category: - clear 
Hetergeneous Replication & Replication Agent 
2Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D40485   Category: Hetergeneous Re...     Status: Archived
Tags:  

Guys,

 

am setting  up an environment where Ms Sql Server as source and HANA as a target. And facing challenges on establishing connectons. Anybody has already done similar setup, Please guide me. thanks

 

1 comment »  

 
1Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D40174   Category: Hetergeneous Re...     Status: Needs More Info
Tags:  

We need a feature in SRS to resume a failed/interrupted create subscription...direct load.

 

Currently if a table is real big (e.g., takes around 40 hours to materialize) and for some reason if DSI thread goes down while direct_load materialization is going on; catch up queue also go away and we need to re-start direct load subscription all over again by truncating data in target table.

 

It consumes huge amount of DBA time and again there is possibility of next interruption.

 

So need a way to resume subscription from where it failed/interrupted.

 

More...

2 comment »  

 
22Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D40152   Category: Hetergeneous Re...     Status: Under Review
Tags:  direct load 
Direct load materialization is supported in heterogeneous setup if target is HANA. Same fuctionality should be available for SAP IQ. One of big customer is using SRS in Analytics solution and they have many sources to integrate through SRS. Doing initial materialization becomes painful and it is taking lot of time to setup one source system. It would be very helpful to have direct load functionality avaialble for IQ so that replication setup will be fast.

6 comment »  

 
2Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D39580   Category: Hetergeneous Re...     Status: Acknowledged
Tags:  

THE IDEIA IS MAKE THE PARAMETER WORKS.

 

BELOW SAP ANSWER ABOUT THE ISSUE (Unconverted ASE source insertion in replication):

 

Regarding the fact that SAP RepServer parameter 'dsi_charset_convert' is not working I've contacted the SAP RepServer product engineering and that answer that I got about this is the following:

 

====

 

Replicating data to a different character set requires two Replication Servers with dsi_charset_convert options, RepServer is designed this way.
The primary server must be configured with the same character set as the primary ASE server (It's cp850 in your case).
The replicate replication server must be configured using the same character set as the replicate database (iso_1 in your case).
The server call open server libraries to either convert or keep the data to the target character set based on dsi_charset_convert setting.
The dsi_charset_convert parameter is a kind of confusing because peope will easily consider this is setting for a connection.
Actually it is for th

More...

comment »  

 
4Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D37344   Category: Hetergeneous Re...     Status: Acknowledged
Tags:  

Current DS-RS integration only supports primary-replication server (one repserver). No router based replication server(two or more repservers) is currently supported.  It would be great to be able to support SRS routes with DataServices, to be able to support an architecture that has two SAP replication server which are connected via a route across a WAN connection.

 

 

 

Thanks,

Keith 

comment »  

 
1Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D35669   Category: Hetergeneous Re...     Status: Submitted
Tags:  

Hello ,

 

While deploying drivers for SDA /SDI specicfically for oracle and SQL we have gone thru lots of diffrent steps and procedure to make both work on same HANA instance . 

 

Is there can be common Binaries platform for SQL and Oracle that can be deployed thru GUI mode without going thru all the hassel work at OS level and updating ODBC.ini files each time new connection is added  ?

 

Also in Replication snerio where HA is enabled these drivers are pain for deployment and there is nothing available to replication drivers or config from OS level . Can we get something in GUI mode to replicate SDA/SDI technologies by replication mean ?

 

Two things again .

 

1. Deployment for Drivers shoudl be bundled and available thru GUI .

2. Replication in HA ennviromnet is missing for SDA/SDI technologies . can we get this in GUI mode thru replication ?

 

-Suharsh 

comment »  

 
Displaying results 1 - 6 of 6