Stack Overflow
Stack Overflow

Questions tagged [attunity]

Attunity is a provider of information availability software solutions that enable access, sharing and distribution of data across heterogeneous enterprise platforms, organizations, and the cloud.

From attunity.com

Attunity is a leading provider of information availability software solutions that enable access, sharing and distribution of data across heterogeneous enterprise platforms, organizations, and the cloud. Our software solutions include data replication, change data capture (CDC), data connectivity, enterprise file replication (EFR), managed-file-transfer (MFT), and cloud data delivery. Using Attunity’s software solutions, our customers enjoy significant business benefits by enabling real-time access and availability of data and files where and when needed, across the maze of heterogeneous systems making up today’s IT environment.

70 questions
1
vote
1 answer

java.lang.IllegalArgumentException: A KCQL error occurred.FIELD_ID is not a valid field name

I have data stored into a kafka topic and i want to move to cassandra using the CassandraSinkConnector from landoop. I am having this error while i am trying to start the connector: Caused by: java.lang.IllegalArgumentException: A KCQL error…
jacktrade
  • 3,125
  • 2
  • 36
  • 50
1
vote
1 answer

Alter CLOB without SOURCE_LOOKUP

I am attempting to alter CLOB data to STRING(3999) row by row in a table. I am currently using SUBSTR([fieldname],1,3999), however when checking the result table against the source table it shows a NULL result despite data existing within the…
Matthew Clink
  • 31
  • 6
1
vote
0 answers

SSIS / Oracle Attunity for Integration Services

Thanks ahead of time for the assist! I'm currently undergoing an investigation into slow loading times using SSIS to transfer data from our Oracle servers to SQL (Part of a Data warehouse effort) and we're suffering from extremely slow loading…
Jonathan Rogers
1
vote
1 answer

Run SQL script on Attunity in SSIS

Currently I am running a script in sqldeveloper to get my data from oracle and dump into CSV file and then I import CSV file into SQL Server. Now, I have VS 2017 and I am trying to get same data into SQL server from Oracle database through Attunity…
mak101
  • 147
  • 1
  • 11
1
vote
1 answer

ORACLE_HOME Error When Testing Connection with Oracle Connector by Attunity for SSIS

I'm having the same problem. Here is my setup... Windows 10 64-bit SQL Server Data Tools v10.0.40219.1 SP1 Attunity Oracle Connector for SSIS (32-bit and 64-bit) v2.0 Oracle client 64-bit installed v12.1.0 Oracle client 32-bit installed…
Adam
  • 3,891
  • 3
  • 19
  • 42
1
vote
2 answers

Check performance of ETL in SSIS

How can I check how long it lt took to extract data and load data in SSIS. I am using Attunity connector now for extracting Data from Oracle and then using OLE DB destination to load it in SQL Server. Using Attunity is not making any difference in…
Doodle
  • 481
  • 2
  • 7
  • 20
1
vote
0 answers

Attunity driver fails when run from sql server agent job

This is unique. My package runs perfectly in Visual Studio debug mode, but when I put it to run via sql server agent, I get the following error: 'Oracle source cannot run on installed edition of Integration Services. It requires Enterprise…
Prabhat G
  • 2,974
  • 1
  • 22
  • 31
1
vote
0 answers

Timeout Error Connecting to Teradata Server From SSIS using Attunity Driver - "[WSock32 DLL] 10060 WSA E TimedOut"

I'm facing an issue connecting to Teradata from SSIS using Attunity connector. My environment details as follows: Windows 2016 SQL Server 2016 (Enterprise Edition) VS 2015 Attunity Driver 5.0 Teradata drivers installed - 15.10.05 When I run the…
Sai
  • 21
  • 4
1
vote
1 answer

SSIS - Teradata Attunity Connector and SQLServer 2016

I have no problem running an SSIS package from VS2015 on my dev machine transferring from Teradata 15 to SQLServer 2016 using Attunity 4.0 and all of the following from TTU 16.10.01: ODBC Driver OLEDB Access Module .Net Data Provider TPT…
ItalloSan
  • 23
  • 5
1
vote
1 answer

SSIS Microsoft Connector for Oracle by Attunity for VS2015 Not Showing

I downloaded and installed the Microsoft Connector for Oracle by Attunity from the following location for VS 2015 to use with SQL Developer 2014: https://www.microsoft.com/en-us/download/details.aspx?id=44582 It installed correctly, but for some…
ptownbro
  • 1,240
  • 3
  • 26
  • 44
1
vote
1 answer

Joining 2 Oracle tables using Join in SSIS

I have to get data from database1 something like select * from tab1 where dtCol > <*dtVariable*> The value of dtVariable comes from database2 from select * processdt where proc_name = 'PROCESS1' Can you please let me how to do this? I am using…
Ras Knorr
  • 43
  • 6
1
vote
2 answers

Attunity Replicate sample installation

I am trying to install Attunity Replicate into a local virtual machine with CentOS 7 on it. I can see that it is running - using 'ps -ef | grep repctl', and I know that the 3552 port is open in the firewall, and the host is visible (using 'nc -zv …
al-dann
  • 2,545
  • 1
  • 12
  • 22
1
vote
0 answers

New JDBC Driver for JBoss 6 EAP

Goal Add the Attunity Driver to the JBoss server so that the datasource can be created. I assume that the error below is due to the driver not being loaded properly. The initialization of the datasource might fall due to network issues. I want to…
michaelbahr
  • 4,837
  • 2
  • 39
  • 75
1
vote
0 answers

SQL OrderBY throwing error

I am currently working on three tables where , I need to orderby based on two columns which are part of two different table . Where as I need to JOIN three table to extract the resulted output. For eg my query is as below . select…
sharath Yogananda
  • 101
  • 1
  • 2
  • 6
1
vote
0 answers

Connect Oracle Database FROM SSIS Package SQL Server

I am using the Microsoft Connector for Oracle by Attunity with SQL Server 2010 Integration Services. Install the Microsoft Connector for Oracle by Attunity.SSIS Package connected succeed oracle connection manager editor. First of all create one…
vinoth annamalai
  • 11
  • 3
1
2
3 4 5