Data Replication 1

Search:

Type: Posts; User: akanksha.1787; Keyword(s):

Search: Search took 0.00 seconds.

  1. Error in recreating external table in sqldw azure

    Hi Experts,

    We have a scenario where we occasionally come across an issue with creation of external tables in sqldw azure.

    We were trying to perform data replication from Oracle to Azure SQLDW...
  2. How to increase the throughput of records being read from Oracle Source DB

    Hi Experts,

    Could you please help us understand, how can we increase the throughput while reading records from the source oracle database.
    The throughput we get varies higly with various peaks...
  3. Thanks for your response Hein. We managed to get...

    Thanks for your response Hein.
    We managed to get the 'Atler' table access for the said applicaition and noticed that the changes are now not only being captured by the tool but are
    also getting...
  4. CDC not getting applied on the SQLDB target table

    Hi Hein ,

    Thank you for your response.

    We realized that our user does not have the Alter table access on the source database.
    I know the manual says the user should have 'ALTER ANY TABLE'...
  5. Updates not getting reflected in the SQLDB although Replicate captures it

    Hi Experts,

    There is an issue we are facing where the changes made to the source(Oracle) DB are not getting reflected to the target (SQLDB).

    We are using the Replicate version 5.1.1.94.
    The...
  6. Replies
    6
    Views
    3,463

    CDC not getting applied on the SQLDB target table

    Hi Steve,

    We are using the Replicate version 5.1.1.94.
    The warning we are getting is related to the primary key viz.

    " 00005668:2017-02-03T04:52:49 [ASSERTION ]W: Only a part of primary key...
  7. Decreased Throughtput/Transferred Volume

    Hi Experts,

    We have been facing an issue where the transferred volume of data while replicating from Oracle views to Azure SQL DW ranges from 150-250.
    We have about 14 million records and...
  8. Replies
    6
    Views
    3,463

    CDC not getting applied on the SQLDB target table

    Hi Steve,


    Even I am facing a similar issue where a task has been running without fail for last 20 days
    and was capturing changes. Suddenly, its not capturing any update made to Source...
  9. Thank you for your response steve. Regards,...

    Thank you for your response steve.

    Regards,
    Akanksha
  10. 'String Qualifier for .csv created in Blob Storage by the Attunity Replicate'

    Hi Experts,

    We have a scenario where we were loading data from an Oracle source into Azure SQL Datawarehouse.
    The task failed after loading about 1 million records.

    Below is the error message...
  11. Replies
    1
    Views
    1,640

    CDC to perform SCD type 2

    Hi Experts,

    Does, the Attunity Replicate tool also implement the SCD Type 2.
    As in ,does the tool maintains the various old and new versions of the updated records like in other ETL tools?
    ...
  12. Hi Hein, Thank you for your response. I was...

    Hi Hein,

    Thank you for your response.
    I was able to set the internal parameter as you suggested.
    I will respond back if I am able to see the views with all grants in place for the user.
    ...
  13. Performing CDC using Views as Source for Oracle/Non-Oracle Databases

    Hi Experts,

    We have a requirement in our project, where we have to replicate data by using Views as Source for Oracle Database.

    When we create a source endpoint using 'Oracle' type we could...
  14. A small correction, its actually the Attunity...

    A small correction, its actually the Attunity Server that went down and not the target SQL DB server.

    Regards,
    Akanksha Bassin
  15. How to restore the CDC task failed due to server downtime

    Hi Steve,

    Even I am facing the same issue where a running task got stopped as the target sql db server went down.
    Now I am unable to resume the task as it cannot find the ' last redo log'.
    Any...
  16. Error in performing CDC for Oracle Source

    Hi Experts,

    We have another case where we have given all the grants mentioned in the attunity guide to the user but still are facing issues in performing CDC
    for an oracle source.

    Attached is...
  17. Exact DB changes and grants to be provided to enable CDC in oracle source

    Hi Experts,

    I have performed the below steps but still getting an error while performing the CDC for oracle source. Attached is the log for the same.
    Could you help me with the exact grants to be...
  18. More Information on the Suspended table

    Hi Experts,

    Just to add, our table got partially loaded and the replication process stopped after encountering an error.
    The log says, stopped due to previous error, no other information.
    ...
  19. How to find the reason of the Suspended Table

    Hi Experts,

    We have a situation, where one of the tables failed to replicate during full load and got suspended as par the log.
    We could not find any significant error in the log file.

    We got...
  20. Thank you for your useful responses Steve and...

    Thank you for your useful responses Steve and Hien.

    Hein,
    I came across the internal parameter while exploring the tool and could not find any values there nor and option to add any value...
  21. How and Where to Set Internal Parameter in Advance settings in Manage Endponts

    Hi Experts,

    Need your views on how and where to set the 'Internal Paramater' showing up in Advance Setting of Manage Endpoint Connections.

    Regards,
    Akanksha Bassin
  22. Limitations for Using SQL DB as a target end - point

    Hi All,

    We plan to use SQL DB as a Target end-point in our project for one of the applications.
    The Attunity Replicate Manual only talks about using SQL DW as a target but not SQL DB.
    We know...
Results 1 to 22 of 22