News

Attunity Adds Change Data Capture Links Between SQL Server and Oracle

Attunity Ltd. today released software that allows developers to apply change data capture (CDC) between Microsoft's SQL Server and Oracle databases.

Oracle-CDC for SSIS replicates and synchronizes updated data between Microsoft's SQL Server Integration Services and Oracle databases in real time, according to Attunity officials. The CDC tool works in conjunction with connectors the company released in October that provide high-speed links between SSIS and Oracle and Teradata platforms.

SSIS is a free component offered with SQL Server 2005 and 2008 that enables integration and extract, transform and load (ETL) with third-party databases, reporting tools and data warehouses. It has become a de facto ETL tool for large Microsoft-centric enterprises looking to integrate data across platforms, said Gartner analyst Ted Friedman.

"[Users] are finding it to be a very cost-effective alternative to some of the heavier-weight, more comprehensive solutions out there," Friedman said. Among those higher-end data integration and ETL tools are IBM's DataStage and Informatica's PowerCenter.

Within the realm of data integration, CDC has emerged in recent years as a key function for organizations that need to conduct bulk data transfers and batch processing in short windows of time. While the amount of data might be substantial, typically only a small percentage of the overall data within a repository has changed. CDC only replicates the changed information to speed the data transfers and minimize infrastructure requirements.

CDC is used by some large banks that expect data from a customer's online transaction to be updated in real time throughout other channels, including branch systems, ATM machines and call centers. Point-of-sale is also a suitable application.

It is also becoming popular for situations in which decision makers need to act on current data, Friedman said. "I clearly see a trend where CDC is on the rise," he said. "Things like real-time or operational business intelligence that require rapidly sensing important changes to data and getting those changes out so they can be analyzed."

Attunity first started offering CDC tools in 2004, and while it offers leading technology, the company is struggling financially, Friedman said. The company last month reported that its $2.2 million in revenues for the first quarter of this year were down 32 percent over the same period last year. A partnership with Microsoft could boost its fortunes because SSIS falls short when it comes to handling batch-oriented data, according to Friedman.

Attunity's CDC tool will appeal to developers who need to apply that capability to Oracle data but are not skilled in that database platform, said Itamar Ankorion, the company's director of business development.

"We hide all of the complexity of working with the Oracle data and how changes are captured and we automatically generate all of the packages within SSIS," Ankorion said. Packages are created via the SSIS wizard to move data from one source to another. Developers can edit SSIS packages via Visual Studio or Business Intelligence Development Studio.

The software starts at $2,500. An average installation costs around $40,000 Ankorion said.

About the Author

Jeffrey Schwartz is editor of Redmond magazine and also covers cloud computing for Virtualization Review's Cloud Report. In addition, he writes the Channeling the Cloud column for Redmond Channel Partner. Follow him on Twitter @JeffreySchwartz.

comments powered by Disqus

Featured

  • Mastering Blazor Authentication and Authorization

    At the Visual Studio Live! @ Microsoft HQ developer conference set for August, Rockford Lhotka will explain the ins and outs of authentication across Blazor Server, WebAssembly, and .NET MAUI Hybrid apps, and show how to use identity and claims to customize application behavior through fine-grained authorization.

  • Linear Support Vector Regression from Scratch Using C# with Evolutionary Training

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the linear support vector regression (linear SVR) technique, where the goal is to predict a single numeric value. A linear SVR model uses an unusual error/loss function and cannot be trained using standard simple techniques, and so evolutionary optimization training is used.

  • Low-Code Report Says AI Will Enhance, Not Replace DIY Dev Tools

    Along with replacing software developers and possibly killing humanity, advanced AI is seen by many as a death knell for the do-it-yourself, low-code/no-code tooling industry, but a new report belies that notion.

  • Vibe Coding with Latest Visual Studio Preview

    Microsoft's latest Visual Studio preview facilitates "vibe coding," where developers mainly use GitHub Copilot AI to do all the programming in accordance with spoken or typed instructions.

  • Steve Sanderson Previews AI App Dev: Small Models, Agents and a Blazor Voice Assistant

    Blazor creator Steve Sanderson presented a keynote at the recent NDC London 2025 conference where he previewed the future of .NET application development with smaller AI models and autonomous agents, along with showcasing a new Blazor voice assistant project demonstrating cutting-edge functionality.

Subscribe on YouTube