Data Replication 2
Results 1 to 10 of 10

Thread: Linked server(Attunity)

  1. #1
    Optimdev is offline Junior Member
    Join Date
    Jan 2011
    Posts
    21
    Rep Power
    0

    Deleted for other purposes

    Deleted for other purposes
    Last edited by Optimdev; 08-31-2011 at 04:49 PM. Reason: Deleted for other purposes

  2. #2
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    For Optim related issues you should consult with the Optim support.

    Note that when running under a SQL Server linked server, the default SQL Server configuration prevents the code from accessing local resources - for example files. This may have something to do with your problem. Still, you should contact Optim support for an authorative answer.

    /d
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    Optimdev is offline Junior Member
    Join Date
    Jan 2011
    Posts
    21
    Rep Power
    0

    HELP!!!Data validation!!AttunityVS ORACLE using linked server concept in SQL server

    Deleted for other purposes
    Last edited by Optimdev; 08-31-2011 at 04:47 PM. Reason: Deleted for other purposes

  4. #4
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    (should really be in a new topic...)

    >> ...except is returning some rows as difference but when we do a manual
    >> comparision i found that reality that there is no diiference in the data...

    What do you mean 'manual comparison'? Are you looking at a printout? Do you print each column with its length and trimmed length? Detail please.

    >> ...I believe attunity is adding some special characters (such as space etc )
    >> and this is causing the except query to return these differences...

    Attunity Connect does not add special characters. Different in spaces can be seen with checking the length of the columns. Try to reduce the number of columns you compare to be different to the minimum and then filter the rows to a single line that shows a difference, then study the values of the remaining columns, including their length and trimmed length. Note that different binding using different APIs may yield different handling of trailing spaces. Try to use the same API in both cases (e.g., try to get to Oracle also via ODBC).
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    Optimdev is offline Junior Member
    Join Date
    Jan 2011
    Posts
    21
    Rep Power
    0

    Thanks for the quick reply

    Deleted for other purposes
    Last edited by Optimdev; 08-31-2011 at 04:47 PM. Reason: Deleted for other purposes

  6. #6
    Optimdev is offline Junior Member
    Join Date
    Jan 2011
    Posts
    21
    Rep Power
    0

    Still facing issues

    Deleted for other purposes
    Last edited by Optimdev; 08-31-2011 at 04:48 PM.

  7. #7
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    I have noticed the Attunity OLEDB Provider and query processor for heterogeneous databases.Can i use this instead of ODBC for accessing the attunity data?
    Yes, you can use the Attunity OLEDB provider for a SQL Serveer linked server.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  8. #8
    Optimdev is offline Junior Member
    Join Date
    Jan 2011
    Posts
    21
    Rep Power
    0

    Problems in creating Linked server using Attunity OLEDB Provider

    If posibnle please let me know the config steps for creating one...i was not able to figure out.
    Thanks.

  9. #9
    Optimdev is offline Junior Member
    Join Date
    Jan 2011
    Posts
    21
    Rep Power
    0

    Deleted for other purposes

    Deleted for other purposes
    Last edited by Optimdev; 08-31-2011 at 04:49 PM.

  10. #10
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    For linked server using the AttunityConnect OLEDB provider, you need to specify a valid connection string according to the Attunity Connect manual. The Attunity OLEDB provider has nothing to do with ODBC DSNs.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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