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

Attunity Replicate - tables in Azure are created without clustered indexes

I have a large(~33 millions records) on-premise SQL Server database which must be replicated to an SQL Azure database (near-realtime replication is required). I'm trying to use Attunity Replicate software to achieve this. I created a task with Full…
nativehr
  • 1,131
  • 6
  • 16
1
vote
1 answer

SSIS 2008 shared data source for attunity

I am using Attunity (V 1.2) connection for Oracle in my SSIS 2008. Our Oracle DBAs are often changing the passwords and I have to change all my SSIS connections one by one accordingly. Is there a way to change all attunity connections? (Specially…
Dushan
  • 21
  • 3
1
vote
1 answer

Attunity Terada - Sql Server 2008 R2

Can anybody tell me if it is possible using Attunity for Teradata database and a Sql Server 2008 R2 database to have the "false load" loaded in a database and the logs in a different database? Thank you so much, Bogdan.
BogdanM
  • 957
  • 4
  • 15
  • 32
0
votes
1 answer

Missing the ORACLE connection manager type in "Add SSIS Connection Manager" list. (Visual Studio 2019)

I can't see any ORACLE components in my Visual Studio, although I installed software/components/connectors in the order described in Microsoft Documentation. I can't set up the Oracle connection for the SSIS packages; the "Oracle Source" and "Oracle…
Ghena
  • 1
  • 2
0
votes
0 answers

Getting error when importing from SSMS into Visual Studio (SSIS). (Some of the packages in the project use the Oracle connector)

I faced a problem when I tried to import some projects from SSMS into Visual Studio. I discovered I have the same issue with all projects using the Oracle connector. If the project uses the SQL Server connectors for included packages, everything…
Ghena
  • 1
  • 2
0
votes
1 answer

VS2019 Oracle connection not working in SSIS

I have installed the Professional version of Visual Studio 2019 and I am unable to connect to Oracle DB Source using the Microsoft connector. I am getting the below error. Can someone please help with this? TITLE: Microsoft Visual…
Doodle
  • 481
  • 2
  • 7
  • 20
0
votes
0 answers

Attunity zero timestamp value insert into mySQL DB

we are using Attunity tool to insert data from mySQL Database into other mySQL Database and there is a problem with '0000-00-00 00:00:00' values in columns defined as a timestamp in source database. Attunity task doesn`t return any error message,…
bennes
  • 71
  • 1
  • 3
  • 10
0
votes
1 answer

How to load flat file into Oracle database

I am trying to import data from a csv file to an Oracle database, I am using Visual Studio 2017 I have downloaded all required components such as SSDT 15.8; and Attunity version 5.0 I was wondering if someone could please guide me on how I can load…
comp_user
  • 60
  • 7
0
votes
1 answer

SSIS package will not run on server, but works fine on Dev machine

I am using Attunity drivers to connect to an Oracle source through SSIS in order to publish to my SQL Server (2019) The package runs just fine on my laptop in VS2019 and publishes to SSIS catalog on my server When I try to execute the package I get…
Henrik Poulsen
  • 935
  • 2
  • 13
  • 32
0
votes
0 answers

Parameterized query in SSIS Oracle data load

I am learning to use SSIS to use between our Oracle ERP system and my SQL Server data warehouse When loading transactional data (Inventory transactions) I have a unique auto increment integer Transaction_Id column that I would like to use in my SSIS…
Henrik Poulsen
  • 935
  • 2
  • 13
  • 32
0
votes
1 answer

Using Oracle Source & Attunity in BIML

I would like to transfer data from oracle to SQL with biml. So far I was able to create a (simple) package to transfer data manualy. This package contains a SQL_Destination-Connection (Native OLEDB), an Oracle-Source Connection (oracle connection…
Gregor Prohaska
  • 41
  • 4
0
votes
1 answer

Need some understanding on Attunity connection with SAP ECC on Oracle

I am trying to create Attunity endpoint for SAP ECC on Oracle. From the Attunity documentation, it seems to be a two step process. Create a Oracle DB endpoint connection (passing connection string and credentials) Use the above configuration (as…
Akshay
  • 55
  • 7
0
votes
1 answer

Error while connecting to Oracle Endpoint in Qlik replicate "cannot load libclntsh.so.11.1"

The replicate server is installed on Linux and i am trying to connect to a oracle database as source which is on a different server. While testing the connection i am getting the attached error message. The libclntsh.so is already defined in the…
max
  • 23
  • 5
0
votes
1 answer

SQL Sever table is not showing value for a column in a table

We're replicating the data from Oracle to SQL Server using Attunity. In Oracle database , the table MEMO has a Description column which has some value. (for ID = 1) Description = 'This is test record' But SQL Server is not showing that value in the…
Santhosh Reddy
  • 13
  • 2
0
votes
0 answers

Line Feed not transmitted to Oracle with Attunity driver on SSIS

I'd like to load data from Azure to an oracle database through SSIS with an Attunity driver. Now I've noticed that the character "Line Feed" (Ascii 10) is not inserted. When I do the same with an oledb driver instead of Attunity as destination, the…
Swiss_BI
  • 1
1 2
3
4 5