Newsletters




Data Integration

Traditional approaches to the process of combining disparate data types into a cohesive, unified, organized view involve manual coding and scripting. The need for Real-Time Business Intelligence and the ability to leverage a wider variety of data sources is driving companies to embrace new ways to achieve Data Integration, including Data Virtualization, Master Data Management, and Integration Automation.



Data Integration Articles

Infobright, an open source data warehousing company, has announced Infobright Enterprise Edition (IEE) 3.4, which provides performance improvements for analytics involving large volumes of data. The release includes query performance improvements of up to 500%, delete performance improvement of over 1600%, the ability to run queries while data is loading, more efficient workload management, and support for multi-language data. "Our focus is on providing the best query performance possible, but always balancing that with low cost and ease of use," Susan Davis, vice president of marketing, Infobright, tells 5 Minute Briefing.

Posted June 29, 2010

InterSystems Corporation has announced that CareGroup Healthcare System, a Boston-based integrated delivery network (IDN) comprised of four hospitals, has selected the InterSystems Ensemble rapid integration and development platform to replace its legacy eGate platform for strategic integration throughout the organization. In addition to determining that Ensemble could support all current file and application interfaces, CareGroup found that configuration was fairly straightforward-an important consideration in an organization where Ensemble will eventually handle more than 200 system and information interfaces. "Ensemble will be used to support data integration throughout the IDN," states Steve Herzog, senior director, Financial Systems at CareGroup "Our strategy is to deploy Ensemble at Beth Israel Deaconess Medical Center first and then to the community hospitals that are included in the CareGroup network."

Posted June 29, 2010

Netezza Corporation, a provider of data warehouse, analytic and monitoring appliances, and Composite Software, Inc., a data virtualization middleware provider, have announced the Netezza Data Virtualizer to simplify, accelerate and optimize the integration of data stored across multiple Netezza appliances. Powered by Composite Software, the Netezza Data Virtualizer creates an integrated view of data that is physically distributed across multiple Netezza appliances and delivers query results to reporting and analytic applications while Netezza appliances continue to manage their data.

Posted June 29, 2010

Sybase has announced the availability of its SQL Anywhere 12 database and synchronization solution. A core component of the Sybase Mobility Platform, SQL Anywhere is optimized for mission-critical database applications running outside traditional data center environments requiring little or no onsite IT support. According to Chris Kleisath, senior director of engineering, SQL Anywhere 12 represents a major platform release, providing many key new enhancements for performance and scalability such as support for storage and synchronization of spatial data, support for iPhone devices, and new self-management features.

Posted June 29, 2010

EnterpriseDB, a supplier of PostgreSQL-based solutions, and Netezza Corporation, a provider of data warehouse and analytic appliances, announced a new partnership intended to ease database migration projects. Under the agreement, Netezza will resell EnterpriseDB's Postgres Plus Advanced Server, which includes its Oracle Compatibility Layer, as Netezza Migrator. Migrator will be compatible with the Netezza TwinFin appliance.

Posted June 28, 2010

VMware and Novell have expanded their strategic partnership with an original equipment manufacturer agreement through which VMware will distribute and support the SUSE Linux Enterprise Server operating system. Under the agreement, VMware also intends to standardize its virtual appliance-based product offerings on SUSE Linux Enterprise Server.

Posted June 23, 2010

Maxwell Systems, a provider of complete construction business management software solutions, and Entrinsik, a provider of operational reporting and analysis solutions, are partnering to offer Maxwell Systems' clients Informer Web Reporting, a powerful web-based reporting and analysis solution that provides technical, business, and front-line users with real-time access to information from multiple systems, platforms, or locations.

Posted June 23, 2010

ONware is now offering the ability to use PostgreSQL as a database system for applications developed for U2, D3, MVON and other MultiValue and PICK database environments. The new support for PostgreSQL has been added based on feedback from prospective customers in the MultiValue world, Jack Roth, director of operations, ONgroup, tells 5 Minute Briefing. Roth notes that he has come across a number of companies that have other development in their organizations in Postgres. "They like Postgres and if they can support one database as opposed to two very dissimilar databases, that is an advantage for them," he explains.

Posted June 23, 2010

Quest Software, Inc. plans to launch a beta program tomorrow for Toad for Cloud Databases, a new data access and management tool for non-relational data stored in cloud databases, also known as NoSQL databases. Toad for Cloud Databases is intended to help users unlock data stored in the cloud by using the familiar SQL language or Toad's popular visual query and data access capabilities. Users can query and report on non-relational data, migrate data in both cloud and relational databases from one to the other, and create queries that combine the two.

Posted June 22, 2010

Attunity Ltd., a provider of real-time data integration and event capture software, has introduced the new Attunity PowerPivot Connector for Oracle, a dedicated and optimized solution for making Oracle data available in Microsoft PowerPivot. Attunity also announced the availability of additional certified connectors that enable PowerPivot users to access data from many heterogeneous sources.

Posted June 16, 2010

IBM today announced a definitive agreement to acquire Coremetrics, a leader in web analytics software. IBM says that the acquisition of Coremetrics, a privately held company based in San Mateo, Calif., will expand its business analytics capabilities by enabling organizations to use a cloud-based delivery model to gain real-time insight into consumer interactions internally and through social media networks to develop faster, more targeted marketing campaigns. Financial terms were not disclosed.

Posted June 15, 2010

Oracle yesterday announced Oracle Business Process Management Suite 11g. A component of Oracle Fusion Middleware 11g, Oracle Business Process Management Suite 11g supports all types of processes with a new unified process foundation, targeted user-centric design and new social BPM capabilities, and includes a native implementation of BPMN 2.0. Historically, when choosing BPM solutions organizations have had to make a choice between a business user-friendly solution or one that provides rich support for the IT and integration capabilities, David Shaffer, vice president, product management, Oracle Fusion Middleware, tells 5 Minute Briefing. "What's really unique here is that we are offering a single product that is complete and unified," Shaffer emphasizes.

Posted June 15, 2010

Panorama Software has unveiled NovaView 6.2, the newest release of its flagship suite of web-enabled BI applications. NovaView 6.2 offers native connectivity with and extends Microsoft's new in-memory engine, PowerPivot, and provides tight integration with Office 2010 and SharePoint 2010. The new release also adds Oracle to the available data sources, making Oracle relational database data instantly available for interactive, multidimensional analysis with the entire NovaView product stack.

Posted June 15, 2010

Composite Software, Inc. has introduced the newest version of the Composite Information Server Data Virtualization Platform to address the increasing demand by global enterprises with complex and disparate information systems for more agile, cost-effective data integration solutions. With capabilities ranging from upfront data discovery and modeling to ongoing operations monitoring, Composite's platform provides a comprehensive data virtualization offering.

Posted June 08, 2010

Yesterday, at the Microsoft Business Intelligence Conference 2010 in New Orleans Attunity Ltd., a provider of real-time data integration and event capture software, introduced the new Attunity PowerPivot Connector for Oracle, a dedicated and optimized solution for making Oracle data available in Microsoft PowerPivot. Attunity also announced the availability of additional certified connectors that enable PowerPivot users to access data from many heterogeneous sources.

Posted June 08, 2010

The newest version of the Vertica Analytic Database is now commercially available worldwide. New features support new types of analytics, improve the way queries are executed in terms of better utilization of computing resources, and internationalize the release. "When you look at these things in combination, it really broadens the addressable market that is available to Vertica," David Menninger vice president of marketing, Vertica, tells 5 Minute Briefing. Vertica 4.0 is already delivering business benefits to some of the world's biggest financial services, communications, internet, healthcare and retail companies, according to the vendor. For example, customers who are tight on available computing resources are reporting Vertica 4.0 is helping them "do more with less" with a new workload manager that lets them manage complex mixed query workloads to best meet business priorities. Others who had no prior experience working with columnar databases are taking advantage of Vertica's new "load-and-query" data designer, which automatically generates optimized storage structures greatly simplifying development and tuning.

Posted June 08, 2010

Oracle today announced the availability of Oracle Enterprise Content Management Suite 11g, a comprehensive, integrated and high-performance content management solution, aimed at helping organizations increase efficiency, reduce costs and improve content security.

Posted June 08, 2010

Customer service is always important but never more critical than during difficult economic times, when wasting time is just not acceptable and customer satisfaction is an imperative. Atlantic Detroit Diesel-Allison sells and services a full line of Detroit Diesel, Mercedes-Benz, and MTU engines, and the automatic transmissions offered by the Allison Transmission Division of General Motors Corporation. Atlantic DDA had initiated a plan to improve its service department by improving order processing, thus driving more revenue, with additional goals of gaining operational efficiency and heightening customer satisfaction. In order to achieve these objectives, Atlantic DDA needed to make real-time information available to its teams of service representatives.

Posted June 07, 2010

The Rocket U2 team has announced a call for beta participants for its new product, U2 DataVu. Based on Rocket Shuttle, U2 DataVu will provide U2 developers with powerful and flexible ad hoc query, reporting and dashboard capabilities. With native access to UniData and UniVerse U2, developers can use U2 DataVu's graphical drag and drop capabilities to build visual reports and dashboards with zero programming.

Posted June 07, 2010

In only a few years' time, the world of data management has been altered dramatically, and this is a change that is still running its course. No longer are databases run in back rooms by administrators worrying about rows and columns. Now, actionable information is sought by decision makers at all levels of the enterprise, and the custodians of this data need to work closely with the business.That's because, in the wake of the recent financial crisis and economic downturn, there's a push from both high-level corporate management and regulators to achieve greater understanding and greater transparency across the enterprise, Jeanne Harris, executive research fellow and a senior executive at the Accenture Institute for High Performance, and co-author, along with Tom Davenport, of Competing on Analytics and Analytics at Work, tells DBTA. "In many ways, I think the ultimate result of the financial crisis is that executives realized they cannot delegate analytics to subordinates; they can't view it as technology or math that doesn't really affect them."

Posted June 07, 2010

In the midst of turbulent times, many successful businesses learned an important lesson: The closer IT works with the business, the better an organization can weather the storms that blow in. Thus, many savvy companies understand that the managers and professionals who oversee information technology and applications need to be well incentivized to stay on. At the same time, these professionals understand the need to develop expertise in business management and communications. Many companies are looking to information technology to provide an additional competitive edge, and see their Oracle enterprise systems as the cornerstone of this strategy. As a result, a survey finds that Oracle enterprise application managers and professionals appear to have weathered the economic storm. The survey, conducted among 334 members of the Oracle Applications Users Group (OAUG) by Unisphere Research, and sponsored by Motion International, finds an increase in the number of Oracle technology professionals who are near or surpassing the $100,000 mark in their base salaries.

Posted June 07, 2010

Panorama Software, a provider of proactive business intelligence (BI) solutions, today announced the release of NovaView 6.2, the newest version of its flagship suite of web-enabled BI applications. Oracle connectivity is a key addition to the available data sources, making Oracle relational database data instantly available for interactive, multi-dimensional analysis with the entire NovaView product stack.

Posted June 02, 2010

Embarcadero Technologies, a provider of database design, development and management tools for all major database platforms, has unveiled a new line of XE branded database products that incorporate three distinguishing features - deep, native support across all major databases with a consistent user interface, centralized license management and on-demand tool access via Embarcadero ToolCloud, and an easy upgrade path to Embarcadero All-Access XE.

Posted June 02, 2010

Embarcadero Technologies, a provider of database design, development and management tools for all major database platforms, has unveiled a new line of XE branded database products that incorporate three distinguishing features - deep, native support across all major databases with a consistent user interface, centralized license management and on-demand tool access via Embarcadero ToolCloud, and an easy upgrade path to Embarcadero All-Access XE.

Posted June 01, 2010

The European Space Agency (ESA) has selected the InterSystems CACHÉ high-performance object database to support the scientific processing of the Gaia mission. This mission's aim is to map the Milky Way with precision. The Gaia mission will launch in mid-2012 to conduct a census of all the billion stars in our galaxy. Gaia will observe all celestial objects down to their lowest magnitude. Each object will be observed an average of 70 times during a 5-year period, charting their positions, distances, movements and changes in brightness. Gaia is expected to discover hundreds of thousands of new objects, such as extra-solar planets and failed stars known as brown dwarfs. Within our own solar system, Gaia will be able to identify hundreds of thousands of asteroids.

Posted June 01, 2010

IBM has announced a new DB2 feature that allows clients to more easily move their applications written for Sybase ASE to DB2, adding to the support for Oracle Database applications introduced last year. "With this new feature, we are adding the compatibility capabilities for applications that are written for Sybase ASE to run with little and in many cases no changes to the application," Bernie Spang, director of database strategy and marketing at IBM, tells 5 Minute Briefing.

Posted June 01, 2010

IBM and AT&T announced they have entered into a definitive agreement for IBM to acquire Sterling Commerce from AT&T for approximately $1.4 billion in cash. The acquisition of the Dublin, OH-based company will expand IBM's ability to help organizations create more intelligent and dynamic business networks by simplifying and automating the way they connect and communicate with customers, partners and suppliers both on-premise or through cloud computing delivery models.

Posted June 01, 2010

At its Information On Demand conference in Rome, IBM unveiled new software to place the power of predictive analytics into the hands of business users for faster, more insightful decision making. According to the company, with three clicks, business users can now build a predictive model within a configurable Web browser interface, and run simulations and "what-if" scenarios that compare and test the best business outcomes before the model is ever deployed into an operational system. Business users now have full control over the analytic process, enabling them to make accurate decisions in real-time, based on changes in strategy, customer buying patterns and behaviors, or fluctuating market conditions.

Posted June 01, 2010

SAP and Sybase, Inc. have announced that SAP's subsidiary, SAP America, Inc., has signed a definitive merger agreement to acquire Sybase, in a transaction that will bring them together to enable companies to become better-run "unwired enterprises." The planned transaction is expected to close in July 2010, and, according to the companies, Sybase, based in Dublin, Calif., will be run as a standalone company under the name "Sybase an SAP company."

Posted May 26, 2010

Kore Technologies, a provider of enterprise integration and e-commerce web solutions for MultiValue and Microsoft SQL Server databases, is now a resale partner for Rocket Software's CorVu business intelligence (BI) and analytics products.

Posted May 26, 2010

IBM has opened a Center of Innovation for Linux and Open Standards in the capital city of the Republic of Kazakhstan, with the goal of driving the development and adoption of open standards and open source technologies among the businesses and government organizations of Kazakhstan. Opened under a comprehensive Memorandum of Understanding, signed by IBM and the Kazakhstan Ministry of Information & Communications, the agreement covers several areas of cooperation. The IBM Center of Innovation for Linux and Open Standards will help local software developers increase their Linux and open standards expertise and better connect them to the worldwide Linux community. As part of this process, IBM will develop new ways to apply information technologies to improve business life in Kazakhstan.

Posted May 26, 2010

IBM announced on Monday that it has entered into a definitive agreement to acquire Sterling Commerce from AT&T for approximately $1.4 billion in cash. The acquisition of the Dublin, Ohio-based company will expand IBM's ability to help organizations create more intelligent and dynamic business networks by simplifying and automating the way they connect and communicate with customers, partners and suppliers both on-premise or through cloud computing delivery models. IBM and AT&T expect the transaction to close in the second half of 2010, subject to regulatory approvals and other customary closing conditions.

Posted May 25, 2010

DataFlux, a provider of data management solutions, and Teradata, a provider of data warehousing and enterprise analytics, today announced a partnership agreement intended to help add data quality technology to Teradata's data warehousing and master data management (MDM) environments.

Posted May 25, 2010

Sybase has announced the upcoming general availability of Sybase IQ 15.2, the latest version of the analytics server. With full text search, query federation and web-enabled analytics, IQ 15.2 delivers faster and consistently more accurate business answers and reporting by turning raw data into actionable information through analytics.

Posted May 25, 2010

HiT Software, a provider of provider of data integration and change data capture software products, has been acquired by BackOffice Associates, a provider of data migration, data governance and master data management solutions for Oracle, SAP and other ERP vendors.

Posted May 20, 2010

Altova recently announced the availability of Version 2010 Release 3 (v2010r3) of the Altova MissionKit, an integrated suite of XML, database, and UML tools. This latest release provides a range of usability and performance enhancements as well as integration with Visual Studio 2010 and support for industry standards such as iXBRL and National Information Exchange Model (NIEM).

Posted May 20, 2010

Simba Technologies Inc., a provider of standards-based data access products, solutions and services for both relational and multi-dimensional data sources, has announced that Oracle's Technology Network has released an Oracle By Example (OBE) tutorial covering how to use Microsoft Excel 2007 with Oracle 11g OLAP data for easy and powerful ad hoc query, analysis and reporting. The direct Excel to Oracle connectivity is made possible by Simba's MDX Provider for Oracle OLAP data connectivity product.

Posted May 20, 2010

Microsoft last week announced that volume licensing downloads for SQL Server 2008 R2 are available in all languages, including the public availability of PowerPivot functionality. Customers can now download the trial version of Office 2010 and SharePoint 2010 and the web downloads of PowerPivot for Excel and SharePoint.

Posted May 18, 2010

SAP and Sybase, Inc. announced Wednesday afternoon that SAP's subsidiary, SAP America, Inc., has signed a definitive merger agreement to acquire Sybase for approximately $5.8 billion, in a transaction that will bring the companies together to enable customers to become better-run "unwired enterprises." The transaction is expected to close in July 2010, and Sybase will be run as a standalone company. "This is a strategic moment for SAP, for Sybase, our customers, and the IT industry," said Bill McDermott, co-CEO of SAP and a member of the SAP executive board, in a conference call for analyst and the press. "This acquisition is about accelerating growth for both businesses. This transaction is fully aligned with our strategic objectives to significantly expand our addressable market, opening up new opportunities in mobility, in-memory computing, and analytics."

Posted May 13, 2010

IBM Offers Linux Webcasts On-Demand Did you miss a webcast covering important information about technologies you need to learn more about? IBM offers replays on-demand of webcasts presented by IBM experts and partners.For a replay of "Discover the Benefits of Running Your WebSphere Workloads on Linux and System z" go here.For a replay of "Cloud Computing Made Easy with IBM and Linux," go here. For a replay on "System z and Linux: The Winning Combination," go here. For a replay on "Leveraging Linux with the IBM Client for Smart Work," go here.For a replay on "IBM Smart Business Development and Test with Linux on the Cloud," go here.

Posted May 12, 2010

To broaden the delivery of cloud computing services for clients, IBM has acquired Cast Iron Systems, a privately held company, founded in 2001, that provides cloud integration software, appliances and services. Cast Iron Systems' clients include Allianz, NEC, Peet's Coffee & Tea, Dow Jones, Schumacher Group, ShoreTel, Sports Authority, Time Warner, and Westmont University. The acquisition will expand IBM's process and integration software portfolio, which grew more than 20% in the first quarter of 2010.

Posted May 12, 2010

Ingres Corporation, an open source database management company, has entered into a strategic agreement with Bendigo Partners, LLC to promote the use of Ingres VectorWise within the financial services industry. Bendigo Partners focuses on investment and operating partner opportunities in global, technology-driven financial services. It supports product expansion, global expansion, acquisitions, or technology and operational efficiencies with both capital and expertise.

Posted May 11, 2010

Altova recently announced the availability of Version 2010 Release 3 (v2010r3) of the Altova MissionKit, an integrated suite of XML, database, and UML tools. This latest release provides a range of usability and performance enhancements as well as integration with Visual Studio 2010 and support for industry standards such as iXBRL and National Information Exchange Model (NIEM).

Posted May 11, 2010

HiT Software, a provider of provider of data integration and change data capture software products, was acquired last week by BackOffice Associates, a provider of data migration, data governance and master data management solutions for Oracle, SAP and other ERP vendors.

Posted May 11, 2010

In today's economic climate, application modernization has an even greater significance and return on investment potential for global organizations than has been seen over the past few decades. While most business drivers for application modernization are well known and change little from year to year, some newer drivers are emerging, and certain older drivers are growing in urgency - all increasing the impetus for change.

Posted May 10, 2010

You're probably familiar with the old saying that "it's not what you know, it's who you know." That may have been true back in the days when conversations about competitive advantage concerned memberships at prestigious golf clubs and lavish expense accounts; in the days when data was regarded as mere records of transactions, production and inventory levels. Today's conversations about competitive advantage may still include talk of personal relationships. More frequently, though, these conversations reflect the relatively recent appreciation of the intrinsic value of enterprise data - a value seen not just by senior executives, but also by employees in virtually every department. There is broad consensus in most organizations that enterprise data, and perhaps more importantly, the ability to analyze large volumes or smaller subsets of data at will, in real time, are crucial business differentiators.

Posted May 10, 2010

Mergers and acquisitions often come quickly and when they do, it is critical to have tools and utilities capable of scaling to meet new challenges so operations continue seamlessly, customer service standards are upheld, and costs are contained. This was the case for UGI Utilities, a large natural gas and electric service provider in the eastern U.S. In 2006, UGI acquired the natural gas utility assets of PG Energy from Southern Union Company. A longtime customer of BMC, UGI found it was aligned with the right software company to provide implementation of mainframe service management solutions as well as first class support to get the job done and successfully integrate the newly acquired company's data into its environment, saving time and money.

Posted May 10, 2010

Have you heard about stream computing? Basically, it involves the ingestion of data - structured or unstructured - from arbitrary sources and the processing of it without necessarily persisting it. Any digitized data is fair game for stream computing. As the data streams it is analyzed and processed in a problem-specific manner. The "sweet spot" applications for stream computing are situations in which devices produce large amounts of instrumentation data on a regular basis. The data is difficult for humans to interpret easily and is likely to be too voluminous to be stored in a database somewhere. Examples of types of data that are well-suited for stream computing include healthcare, weather, telephony, stock trades, and so on.

Posted May 10, 2010

Oracle president Charles Phillips unveiled Oracle Enterprise Manager 11g during a presentation in the Guggenheim Museum's Peter B. Lewis Theater filled with customers, analysts and the press. "Now that we can instrument the entire stack, because it is our stack, we can do things we couldn't do before," Phillips told the audience. There is value in being able to get a handle on management costs and gain more predictable environments so downtime is not a threat, and integration is not a struggle, he stressed.

Posted May 05, 2010

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165

Sponsors