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
9
votes
2 answers

Install Oracle Attunity Drivers in Visual Studio 2017

I am trying to make a demo install for the future environment of your SSIS (Extraction / Transformation) layer. For this to be successful I need the Oracle Attunity Drivers. I have installed: Visual Studio 15.9.7 SQL Server Data Tools…
Michael
  • 183
  • 1
  • 1
  • 9
6
votes
3 answers

Is there a best way to get data from snowflake to s3

Is there a best way to get data from snowflake to s3. ? the data snowflake shows will be in s3, but we don't have access to that bucket. And we only need to get the specific tables from Snowflake not the entire data.
chandra mouli
  • 53
  • 1
  • 3
6
votes
2 answers

How to do a one-time load for 4 billion records from MySQL to SQL Server

We have a need to do the initial data copy on a table that has 4+ billion records to target SQL Server (2014) from source MySQL (5.5). The table in question is pretty wide with 55 columns, however none of them are LOB. I'm looking for options for…
Cody Brumett
  • 61
  • 2
5
votes
1 answer

Attunity connectors are not showing in SSIS for VS 2017, SQL Server 2017

I have seen this post for VS 2015 but not VS 2017. I have tested Visual Studio 2017 SSDT - both Enterprise and Professional, and SQL Server 2017. I followed the post here and tried installing the Attunity Connectors for Oracle both V5 (found here)…
ds_practicioner
  • 733
  • 8
  • 20
5
votes
2 answers

SSIS - Using parameters in Oracle Query using Attunity Oracle Datasource

I am using the Attunity Oracle connector in SSIS to connect to a remote Oracle Server. In my SSIS package, I need to connect to an Oracle database to fetch the data based on datetime parameters. I followed the suggestions here to write a SELECT…
Prateek Singh
  • 863
  • 1
  • 8
  • 28
3
votes
2 answers

Sqoop Socket timeout detected: Read timed out while reading data from Mainframe and insert into Hive

Please find my below problem and help me to resolve it. I have a sqoop statement which brings data from Mainframe to Hadoop(Hive) using attunity jdbc driver. sqoop import \ --connect…
Tharunkumar Reddy
  • 2,773
  • 18
  • 32
3
votes
1 answer

CDC change data capture start time - Postgres replication

I'm using AWS DMS for Postgres-postgres migration. For on-going replication for other engines there is a parameter CDC start time where we can specify the start time of picking up up changes for replication but unfortunately postgres does not…
RMu
  • 817
  • 2
  • 17
  • 41
2
votes
0 answers

Attunity component Source and Destination for Oracle in Visual Studio 2019 SSIS

I have Microsoft Visual Studio 2019 community Edition. SqlServer Data tools. And the Attunity component for SSIS. I downloaded and installed the component from the Microsoft Attunity/Oracle download. The Oracle Source and Oracle Destination does…
J Armbruster
  • 71
  • 1
  • 2
2
votes
1 answer

Microsoft SSIS Connectors by Attunity Version 4.0 NOT showing on Visual Studio 2015

In one of our company meetings with Microsoft we were advised to use Microsoft SSIS Connectors by Attunity Version 4.0 if we extract data from Oracle. We used to extract the data from Oracle using Oracle Provider for OLE DB. I have tried to install…
Victor Barajas
  • 193
  • 1
  • 9
2
votes
0 answers

How can I configure a BIML element for attunity Oracle connector?

I read from Using the Attunity Oracle Connector with Biml a way to define an element for Attune Oracle connector by using CustomSsisConnection element . It's different from the actual connection definition in place in the project connection I have…
RAFAEL ANTONIO VENTURA
  • 53
  • 8
2
votes
2 answers

How to create a dummy columns in SSIS 2008

I have a Flat file (.csv) ID, Name 1, ABC 2, CDE 3, DEF I want to the Insert these columns into the target Oracle Table with the sysdate to be inserted into the Load_Dt Column Create Table Temp1 (Load_Dt Date, ID Number, Name…
Ras Knorr
  • 43
  • 6
2
votes
1 answer

SSIS - How to convert real values for Oracle?

I'm facing a problem in a package to import some data from a MySQL table to Oracle table and MS SQL Server table. It works well from MySQL to SQL Server, however I get an error when I want to import to Oracle. The table I want to import contains an…
K4timini
  • 711
  • 2
  • 14
  • 34
1
vote
0 answers

OracleConnection not detecting Oracle Client in BIML Express

I'm trying to establish a connection (using Bilm) with an Oracle database using the OracleConnection and OracleSource objects in BimlExpress for Visual Studio Enterprise 2017 using the following Biml script:
Efrainq07
  • 11
  • 1
1
vote
1 answer

SSIS package with Oracle Connection Attunity: The ORACLE registry key cannot be opened

Please could someone help me on similar/same issue as in this TOPIC - SSIS package that connects to an oracle DB using Attunity Connection Manager My environment situation is: DEV Virtual Machine: VS2019 Version 16.8.1 (Microsoft SQL Server…
wojjy
  • 41
  • 7
1
vote
2 answers

Problem trying to run SSIS package with Oracle Connection Attunity

I'm having the following issue: I have an SSIS package that connects to an oracle DB using Attunity Connection Manager. It does connect in my local pc (to a remote oracle db server) and extracts and all, seems to work. The problem comes when I load…
Baldie47
  • 1,148
  • 5
  • 16
  • 45
1
2 3 4 5