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
0
votes
0 answers

Getting DB2 FETCH not valid, cursor in unknown position after upgrade from 7.1 to 7.3

We have Attunity Replicate running which does a change data capture on the data. The Replication works by first doing a full load of a table, then constantly updates the data using the DB2 journal. We recently upgraded from 7.1 to 7.3, and the full…
Jeremy Teemull
  • 11
  • 2
0
votes
1 answer

Migration task failed at 'load data local infile' while migrating the data from RDS MySQL to Azure Database for MySQL using Attunity Replicate MSM

I try to migrate data from Amazon RDS MySQL to Azure Database for MySQL using 'Attunity Replicate for Microsoft Migrations(Replicate MSM)'. For this I setup the Replicate MSM tool on a Windows 10 machine locally, then I define & test the source &…
Akay Nirala
  • 1,136
  • 7
  • 13
0
votes
1 answer

Error when trying to connect to Teradata as source using Attunity

I am getting the following error when I try to connect to Teradata as source using attunity "SYS-E-HTTPFAIL, Cannot connect to ODBC provider Fatal error has occurred." I have restarted Attunity console and server screenshot of the error I confirmed…
malek khazen
  • 3
  • 3
0
votes
1 answer

Issues kicking off Attunity Replication job - Task Server

My org is just beginning to work on replacing our existing DWH platform with Snowflake/Attunity/WhereScape and some (for now) unnamed Data Vis. tool, but we're running into a weird error and I'm hoping someone has seen the same thing and can maybe…
Matt Swanson
  • 21
  • 5
0
votes
0 answers

Incremental Loading using Attunity Connector

I have been trying to do incremental loading using Attunity connector. Below is the package I am using. But its giving out errors. Can some one guide me on how I can proceed to get the latest records. Oracle Source is getting the latest updated…
Doodle
  • 481
  • 2
  • 7
  • 20
0
votes
1 answer

PC restaged, installed VS2017, Attunity driver for Tdata, package starts, finished, canceled

I have an SSIS package that ran fine under SSDT for VS2012 and an earlier version of the Attunity drivers for Teradata. On my restaged Windows7 PC, I installed VS2017, MS VS Tools for Applications 2017, and MS Connector for Tdata by Attunity…
Beth
  • 9,531
  • 1
  • 24
  • 43
0
votes
2 answers

SSIS connectivity to attunity

I am getting this error in SSIS ****Exception from HRESULT: 0xC0202040 Error at [OLE DB Destination [81]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source:…
Sukanya
  • 33
  • 1
  • 1
  • 9
0
votes
1 answer

Can Apache Kafka/NiFi convert data into a JSON file?

Lets say you have a business Application producing and storing Enriched Product Master Data in its own environment, one the enrichment is completed you want to make that data available on a CouchBase Database. In order to get that data from Business…
MSD
  • 311
  • 2
  • 3
  • 20
0
votes
1 answer

SSIS - Missing column OBJID when importing from Orace using Attunity drivers

My customer uses a tool called IFS (an ERP system), which runs on Oracle (the customer runs 11.2). My job is to extract information from there using Microsoft SQL Server Integration Services (or SSIS). To do so, we're using the Attunity drivers for…
SchmitzIT
  • 9,227
  • 9
  • 65
  • 92
0
votes
1 answer

SSIS Oracle connection string as project parameter is not being replaced at runtime

We move data from Oracle 11 to SQL 2014 using SSIS project deployment model. We use Attunity 3.0 connector. Connection string to oracle data source is a project parameter and is also stored in a table in SQL. We use custom stored procedure that…
Sri
  • 111
  • 1
  • 4
0
votes
1 answer

new TNS Entry not working in visual studio/attunity

Im using visual studio 2013 & the attunity connector to connect to oracle and extract data. As its visual studio, i have the 32 bit oracle drivers installed. Note both connections work when testing via a 32 bit & 64 bit UDL. For the first TNS Entry…
JD_Sudz
  • 194
  • 1
  • 12
0
votes
1 answer

SSIS 2012 - Errored out with Merge Join Transformation

I am trying to create a merge join in SSIS 2012 but i am getting below error "Validation error. Data Flow Task: No input columns found. At least one input column must be mapped to an output column." Here is what my Data Flow is I have 1 Flat file…
Ras Knorr
  • 43
  • 6
0
votes
1 answer

SSIS - Using Attunity connector with Oracle Express Edition

I've been trying to setup a local test environment by installing Oracle Express Edition. I've got a test database up and running and can query that database from Oracle SQL Developer. I then installed the Attunity Oracle connector. I found…
Rubio
  • 1,067
  • 1
  • 14
  • 25
0
votes
0 answers

SSIS - How to ignore sequence value for a table using Attunity Oracle Destination

I am trying to load data in oracle table. The table has sequence for the primary column (ID). When I try to ignore the column in attunity destination it is throwing error. But it is working in oledb destination. How can make attunity destination to…
user416
  • 516
  • 3
  • 12
  • 34
0
votes
1 answer

Plain SQL Pagination

We want to implement pagination with plain SQL, but can't use a few important keywords because of the legacy database not understanding them. The goal is to get 20 entries instead loading and programmatically paginating 15,000 entries. They keywords…
michaelbahr
  • 4,837
  • 2
  • 39
  • 75
1 2 3
4
5