Load Ingest Data
Results 1 to 3 of 3

Thread: Microsoft Attunity Connectors v5.0 for Oracle

  1. #1
    ben_wooduk is offline Junior Member
    Join Date
    Jun 2019
    Posts
    3
    Rep Power
    0

    Microsoft Attunity Connectors v5.0 for Oracle Expression SQL Command

    Is anyone else struggling with V5 oracle connector? We are trying to upgrade our SQL Server and therefore our Attunity connector for Oracle but i cannot find the same SQL expression functionality that i am using with v3.

    With v3 i could bring in the Oracle source connector and set the query, once parsed i could right click the DFT task, choose expression and apply a variable / formula against the Oracle source.

    I no longer have this option, has this been removed?

    Name:  2.PNG
Views: 147
Size:  3.7 KB
    Name:  SQLCommandNotAvailable.PNG
Views: 147
Size:  34.7 KB
    Last edited by ben_wooduk; 06-11-2019 at 11:03 AM.

  2. #2
    ben_wooduk is offline Junior Member
    Join Date
    Jun 2019
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by ben_wooduk View Post
    Is anyone else struggling with V5 oracle connector? We are trying to upgrade our SQL Server and therefore our Attunity connector for Oracle but i cannot find the same SQL expression functionality that i am using with v3.

    With v3 i could bring in the Oracle source connector and set the query, once parsed i could right click the DFT task, choose expression and apply a variable / formula against the Oracle source.

    I no longer have this option, has this been removed?

    Name:  2.PNG
Views: 147
Size:  3.7 KB
    Name:  SQLCommandNotAvailable.PNG
Views: 147
Size:  34.7 KB

    Anyone? Looking like i need to pay for another product to use in SSIS for Oracle. :(

  3. #3
    ben_wooduk is offline Junior Member
    Join Date
    Jun 2019
    Posts
    3
    Rep Power
    0
    Ended up paying for the Devart connector, much better in every way!

Posting Permissions

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