Data Replication 2
Results 1 to 5 of 5

Thread: Access rights and port access (SQL Server -> Redshift)

  1. #1
    rturner is offline Junior Member
    Join Date
    Jun 2014
    Posts
    2
    Rep Power
    0

    Access rights and port access (SQL Server -> Redshift)

    I've been asked to clarify the following by our infrastructure team before they will approve an on-premise Replicate instance. Does anyone have answers to the following?

    Why does the local Replicate instance require sysAdmin access to the local SQL Server instance?

    Is this also required for one-way/read-only replication?
    Can we provide read-only access if we only want to replicate updates to Redshift (and not push updates back into SQL Server)?


    Also, does anyone know if/why the on-premise instance needs access to Redshift on port 5439, or is that just for the AWS node?

    Thanks, Rob

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6

    sysAdmin to SQL Source

    Hello Rob,


    1. About sysAdmin for SQL source, CDC logger and Attunity Stream does request sysadmin permission.
    See FAQ below:


    http://www.attunity.com/forums/chang...-cdc-1096.html


    2. For Change Data Capture(CDC), Replicate would need read/write permission. Full load should be ok for Read Only. NOTE that Replicate does not touch the SQL database at any point.


    3. The On-Premise server(Replicate) need to access to Redshift on Port 5439, because the Replicate server need to issue API command again the Redshift server.


    Thanks, Steve

  3. #3
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Hello Rob,


    1. About sysAdmin for SQL source, CDC logger and Attunity Stream does request sysadmin permission.
    See FAQ below:


    http://www.attunity.com/forums/chang...-cdc-1096.html


    2. For Change Data Capture(CDC), Replicate would need read/write permission. Full load should be ok for Read Only. NOTE that Replicate does not touch the SQL database at any point.


    3. The On-Premise server(Replicate) need to access to Redshift on Port 5439, because the Replicate server need to issue API command again the Redshift server.


    Thanks, Steve

  4. #4
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Hello Rob,


    1. About sysAdmin for SQL source, CDC logger and Attunity Stream does request sysadmin permission.
    See FAQ below:


    http://www.attunity.com/forums/chang...-cdc-1096.html


    2. For Change Data Capture(CDC), Replicate would need read/write permission. Full load should be ok for Read Only. NOTE that Replicate does not touch the SQL database at any point.


    3. The On-Premise server(Replicate) need to access to Redshift on Port 5439, because the Replicate server need to issue API command again the Redshift server.


    Thanks, Steve

  5. #5
    rturner is offline Junior Member
    Join Date
    Jun 2014
    Posts
    2
    Rep Power
    0
    Quote Originally Posted by stevenguyen View Post
    Hello Rob,


    1. About sysAdmin for SQL source, CDC logger and Attunity Stream does request sysadmin permission.
    See FAQ below:


    http://www.attunity.com/forums/chang...-cdc-1096.html


    2. For Change Data Capture(CDC), Replicate would need read/write permission. Full load should be ok for Read Only. NOTE that Replicate does not touch the SQL database at any point.


    3. The On-Premise server(Replicate) need to access to Redshift on Port 5439, because the Replicate server need to issue API command again the Redshift server.


    Thanks, Steve

    Thanks Steve, apprecate the response.

    I'll discuss alternative optoins with our infrastructure team and see if we can come up with a solution (reluctant to grant sysAdmin permissions to our production DBs unfortunately).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •