Data Replication 1

Search:

Type: Posts; User: DougW; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    1,790

    Carl- Since you are using Replicate as the...

    Carl-
    Since you are using Replicate as the consumer of the AIS DB2z CDC solution, item # 1 in the instructions just means to stop any Replicate tasks that are using AIS DB2 on the mainframe as a...
  2. What type of security has been implemented when using File Channel with Replicate?

    When File Channel is configured in a Replicate task, the File Transfer Service communication channel between the client and server is encrypted. FTS clients encrypt their communications using a...
  3. Replicate Transform to return DATE from a JD EDWARDs style 'Julian' date

    You can also use the following Transformation expression to return a ‘DATE’ data type:

    DATE('1899-12-31','+'||TRIM($JDEDATE/1000)||' YEARS','+'||SUBSTR($JDEDATE,-3)||' DAYS')

    Where $JDEDATE...
  4. Using Global Transformation to Add Column with update date/time field

    Adding a column showing current date/time in either LOCAL time, or UTC time.


    1. Create a new Global Transformation of ‘Add Column’ type, and give it a meaningful name.
    228

    2. Select which...
  5. Troubleshooting:Error Message Blank Table List configuring CDC Service

    Problem:
    Error Message and Blank list of tables to choose from when configuring CDC Service

    Scenario:
    When using SQL Server CDC for SSIS, I create a new CDC Service using the ‘CDC Service...
  6. Error Configuring New CDC Service - "FAILED TO START THE CDC SERVICE"

    Problem:

    When using Oracle CDC for SSIS (or any of the CDC for SSIS products), I try to create a new CDC Service using the ‘CDC Service Configuration Wizard’. After supplying the source Oracle DB...
  7. Error Configuring New CDC Service - "FAILED TO START THE CDC SERVICE"

    Problem:

    When using SQL Server CDC for SSIS (or any of the CDC for SSIS products), I try to create a new CDC Service using the ‘CDC Service Configuration Wizard’. After supplying the source SQL...
  8. Replies
    1
    Views
    2,984

    Then the problem might be with Visual Studio...

    Then the problem might be with Visual Studio (BIDS) not having permission to read the Attunity installation directory.
    To fix it, try to run BIDS as Admin by right-clicking the BIDS executable and...
  9. Replies
    2
    Views
    2,700

    Hello Ignacio- Since you have two different...

    Hello Ignacio-
    Since you have two different Attunity environments, each with a listener on a different port, you will need to have separate SQL Linked Servers configured for each.

    Regards
    Doug
  10. Replies
    1
    Views
    4,238

    No - the Attunity Connectors for Oracle and...

    No - the Attunity Connectors for Oracle and Teradata are part of the Feature Pack for Microsoft SQL Server 2008, and will not work with SQL 2005.

    Regards -
    Doug
  11. Replies
    2
    Views
    3,660

    One other important thing - I found that if I did...

    One other important thing - I found that if I did not set a 'Default Catalog' on the connection manager, I would get an error when trying to view data in the OLEDB source component.
  12. Additional troubleshooting for DB2 connections...

    Additional troubleshooting for DB2 connections with simple CLI test program

    Description:

    When trying to query tables from a DB2 data source, we are getting DB2 errors.
    How can we test the...
  13. Starting with AIS 5.0 the SERVICE_CONTEXT table...

    Starting with AIS 5.0 the SERVICE_CONTEXT table is no longer generated by the Studio but by the staging area server upon startup (if the SERVICE_CONTEXT table does not exist). The 5.0 SERVICE_CONTEXT...
  14. Problem Using 5.0 Studio and 4.8.2 Servers - No 'Service_context' metadata seen

    When using the GA 5.0 Studio to create a CDC solution using a Staging Area on a 4.8.2 server, the metadata information for the "SERVICE_CONTEXT" table is not deployed to the server. When the...
Results 1 to 14 of 17