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

Simba Technologies Inc., a provider of standards-based relational and multi-dimensional data connectivity drivers, has announced the beta release of its native Microsoft Excel 2007 connector to Oracle's 11g OLAP Option database. The solution, built using Simba's MDX 2005 Query Language technology, provides users with a high level of access and functionality that is the same as native Excel connectivity to Microsoft Analysis Services or SAP NetWeaver BW.

Posted April 16, 2009

Every data integration initiative—whether it supports better decision making, a merger/acquisition, regulatory compliance, or other business need—requires a set of processes to be completed before the data can be made available to business users. Though this set of processes is fairly well understood by industry practitioners, there are still many areas left unaddressed and, therefore, the process is time-consuming, inefficient, unpredictable, and costly.

Posted April 15, 2009

According to a recent report, Microsoft says that it wants to reduce the overall data center energy consumption by 50% to 60%, and reduce energy consumption across the rest of the company by at least 30 percent. IBM has already announced green data center capabilities with similar goals.

Posted April 14, 2009

Sybase, Inc., announced that Sybase IQ 15, combined with Sun Microsystems' Sun Fire X4540 storage server and running the Solaris 10 Operating System (OS), recorded the best price/performance result in the TPC-H benchmark at 3000 GB scale factor for all non-clustered systems. The benchmark simulates decision support systems that analyze large volumes of data, executes queries with a high degree of complexity, and gives answers to critical business questions. Sybase says that the achievement illustrates the effectiveness of Sybase IQ 15 in helping to optimize IT asset utilization and significantly reduce ownership costs.

Posted April 14, 2009

Simba Technologies Inc., a provider of standards-based relational and multi-dimensional data connectivity drivers, has announced the beta release of its native Microsoft Excel 2007 connector to Oracle's 11g OLAP Option database. The solution, built using Simba's MDX 2005 Query Language technology, provides users with a high level of access and functionality that is the same as native Excel connectivity to Microsoft Analysis Services or SAP NetWeaver BW.

Posted April 14, 2009

BEZ Systems, a provider of predictive performance management (PPM) solutions for databases, has announced the availability of a new Performance as a Service (PaaS) program. Performance as a Service combines the BEZVision predictive performance software with in-depth knowledge and advice from database and performance experts to deliver advanced database performance intelligence. This combination allows IT departments to be more proactive in providing service delivery to their organizations, reduce costs, and improve IT efficiency so they can shift their focus toward providing business solutions and away from firefighting performance crises.

Posted April 14, 2009

Microsoft has announced that SQL Server 2008 Service Pack 1 is now available via free download to current SQL Server 2008 customers. According to the company, SP1 for SQL Server 2008 is primarily a roll-up of previous cumulative updates and offers increased supportability and stability. Microsoft is encouraging enterprise customers who are currently running SQL Server 2008 to download SP1 via the SQL Server 2008 Web site to take advantage of these improvements.

Posted April 14, 2009

Embarcadero Technologies, a database tools and developer software company, has introduced new and enhanced performance optimization tools to help companies detect, fix and prevent costly software errors. The tools include DB Optimizer 1.5 for SQL profiling and tuning, Performance Center for automated 24/7 database monitoring, and J Optimizer 2009 for Java profiling and optimization.

Posted April 14, 2009

Business intelligence and analytics solutions have been available for years now, and companies have learned to employ these tools for a variety of purposes, from simple report generation and delivery to more sophisticated data integration, executive dashboards, and data mining, writes Joe McKendrick in the current e-edition of Database Trends and Applications.

Posted April 07, 2009

Panorama Software, a provider of proactive business intelligence solutions, recently previewed the first fully supported release candidate of NovaView Version 6.0, scheduled for release this June.

Posted April 07, 2009

Melissa Data, a provider of high-performance data quality, contact data verification and mail management solutions, has announced new software called the Total Data Quality Integration Toolkit (TDQ-IT). The new TDQ-IT software integrates into Microsoft's SQL Server Integration Services (SSIS 2005/2008) to deliver the full spectrum of data quality processes as defined by industry analysts including: Data Profiling, Cleansing, Parsing & Standardization, Matching and Monitoring at an affordable price within SSIS.

Posted April 07, 2009

Sybase has announced Sybase CEP, a complex event processing (CEP) technology for performing analytics on high speed streaming data. By integrating Sybase CEP with RAP - The Trading Edition, Sybase is providing a complete platform for trade lifecycle analytics. Sybase CEP extends the Sybase RAP platform's capability to store and analyze large amounts of real-time and historical data, by providing real-time intelligence on high speed streaming market and trade data with minimum latency.

Posted April 07, 2009

MicroStrategy Inc., a worldwide provider of business intelligence software, has announced the release of MicroStrategy 9, which it describes as its most significant software release in nearly a decade. MicroStrategy 9 was introduced in January 2009 at the company's annual user conference and is now generally available. The new release delivers new technology and features to extend the performance, scalability, and efficiency of enterprise BI, to enable the rapid deployment of departmental BI applications, and to provide a seamless consolidation path from departmental BI to enterprise BI.

Posted April 07, 2009

SPSS, Inc., a global provider of predictive analytics software and solutions, has introduced the latest versions of its data mining workbench and text analytics software products, and renamed them to fit under a unified portfolio naming umbrella. Predictive Analytics Software, PASW, is the new name for the complete portfolio of SPSS Predictive Analytics products. This new naming standard unifies the product families under consistent and descriptive nomenclatures to reflect the broad functionality and seamless integration among all SPSS products.

Posted April 07, 2009

GoldenGate Software Inc., a provider of high availability and real-time data integration solutions, and Greenplum, a provider of database software for data warehousing and analytics, today announced that GoldenGate supports integration of operational data to a Greenplum data warehouse in real-time for improved business intelligence and reporting.

Posted April 07, 2009

DataDirect Technologies, a provider of data connectivity and mainframe integration, has released a new suite of 32-bit and 64-bit ODBC drivers that offer new enhancements intended to streamline application development, boost performance and reduce application certification costs. The updated suite, DataDirect Connect for ODBC version 6.0, integrates with the DataDirect Bulk Load and DataDirect Application Failover products.

Posted March 31, 2009

Curl, Inc., the developer of the Curl Rich Internet Application (RIA) Platform, has announced the release of Curl Data Kit Data Services (CDK-DS). CDK-DS is ideal for enterprise developers who are building new applications that require a fast, scalable and reliable data connection to existing server infrastructure, according to the vendor. This includes those developers using Adobe Flex or Flash who have discovered that they need a more robust client side technology, as well as developers who are upgrading an existing Curl application and require a more powerful and scalable data connectivity solution.

Posted March 31, 2009

Embarcadero Technologies recently held DataRage, three days of online technical sessions and a virtual trade show targeted at DBAs, data architects, database developers, security experts, and other database professionals, and found that the virtual approach was the right one for the times, according Greg Keller, chief evangelist, at the company. The online event was held March 17 through March 19.

Posted March 31, 2009

Attunity, Ltd., a provider of real-time data integration and event capture software, and Talend, a provider of open source data integration software, have announced a partnership aimed at jointly selling and marketing their solutions. This new partnership allows both companies to expand their market reach with new solutions created by combining their respective data integration technologies. This partnership-combining the power of Attunity's mainframe connectivity and non-intrusive change-data-capture (CDC) software, and the versatility of Talend's open source data integration solutions-will offer customers increased options for data integration.

Posted March 31, 2009

Pentaho Corporation, the commercial open source alternative for business intelligence (BI), has announced Pentaho BI Suite Version 3, aimed at making it cost effective for businesses to deploy easy-to-use, robust BI capabilities to users throughout the organization. Pentaho BI Suite Version 3 allows business users to easily create interactive dashboards-including Adobe Flash-based visualizations-without training. Also, based on existing customer successes and growing customer demand, Pentaho is introducing a Cloud Computing Edition, packaged for deployment on the Amazon EC2 Cloud, providing companies with another way to drive down the cost of bringing BI into their organizations.

Posted March 31, 2009

Over the past year, we have seen a number of new entrants in the data warehouse appliance market.

Posted March 24, 2009

Imperva, a leading provider of application data security, has announced a new version of its SecureSphere database activity monitoring (DAM) solution that adds analytics intelligence to automate forensic and audit investigations. SecureSphere now provides near real-time multidimensional views of audit data, collects native audit logs from new platforms, and bridges the gap between obscure SAP audit data trails and their associated business transactions.

Posted March 24, 2009

Oracle is offering a new, smaller version of the HP Oracle Database Machine, according to a post last week on the company's Data Warehouse Insider blog. This follows the initial introduction of the HP Oracle Database Machine, which was unveiled by CEO Larry Ellison at Oracle OpenWorld in September 2008. More than three years in development, Ellison called the offering "the world's fastest database machine."

Posted March 24, 2009

Greenplum, a leading provider of database software for the next generation of data warehousing and analytics, has announced new technology designed to accelerate data loading for companies dealing with exponential data growth. Greenplum's new "MPP Scatter/Gather Streaming" (SG Streaming) technology eliminates the bottlenecks associated with other approaches to data loading, enabling high-speed flows of data into the Greenplum Database for large-scale analytics and data warehousing. According to Greenplum, some of its customers are achieving production loading speeds of over four terabytes per hour with negligible impact on concurrent database operations. The SG Streaming technology is available immediately and is a standard feature of the Greenplum Database.

Posted March 24, 2009

Pervasive Software has introduced Pervasive DataMatcher, a highly accurate and high-performance data matching solution based on the Pervasive DataRush technology. DataRush is an embeddable software platform for data intensive processing applications, and is optimized for use on multi-core processors. Its massively parallel-processing engine has been combined with Pervasive's data matching capabilities to create the new DataMatcher product. DataMatcher is designed to help organizations detect fraud, money laundering, and corruption as well as enable threat detection and law enforcement applications, compliance monitoring, and master data management (MDM).

Posted March 24, 2009

Melissa Data, a developer of high-performance data quality and mail management solutions, has announced the release of Data Quality Web Service 2.0-a collection of customer data validation and enrichment services that allow users to add the power of geographic and firmographic information to their web site, CRM system or other business contact process or application. Among the services that are available are: Address Validation (domestic and international), Phone Check, Email Check, Name Check, Geocoding, IP Locator, and Business Coder.

Posted March 24, 2009

SpringSource, a leading provider of tools for the development of enterprise Java applications, has released version 2.0 of its SpringSource Tool Suite (STS), a comprehensive environment for building Spring-powered Java applications. The Spring Framework is an open source application framework that is used to implement standard application structures for the Java Platform. STS is a complete set of tools for developing Java applications within this framework that run on major application servers such as IBM WebSphere, Apache Tomcat, Oracle WebLogic, JBoss, and SpringSource dm Server. Application developers rely on STS as an Eclipse-based IDE that speeds development, dictates best practices, and assists with solving runtime problems while creating applications.

Posted March 17, 2009

Idera, a leading provider of management and administration solutions for Microsoft Windows Servers, has announced SQLsecure 2.5, a security analysis solution that helps database administrators (DBAs) identify and track SQL Server security issues in order to ensure compliance with corporate security audit requirements.

Posted March 17, 2009

Entrinsik, well known in the MultiValue arena for database reporting and analytics software and services for the UniVerse and UniData databases from IBM, will unveil the feature-complete beta release of a major new version of the company's Informer Web Reporting solution this month. The new release offers native access to multiple databases, including Oracle, SQL Server, MySQL, DB2, Informix, and Microsoft Access, in addition to UniVerse and UniData, as well as easy navigation and dynamic linking for reporting across multiple data sources.

Posted March 17, 2009

At a joint press conference in New York last week, SAP AG and Sybase announced a partnership to deliver the new SAP Business Suite software to iPhone, Windows Mobile, BlackBerry and other devices by integrating it with Sybase's mobile enterprise application platform. SAP unveiled SAP Business Suite 7 software on Feb. 4.

Posted March 17, 2009

Way back in 2003, Walmart announced that it would require Radio Frequency ID (RFID) tags—so-called "electronic barcodes"—to be attached to virtually all merchandise. Walmart pioneered the use of the printed bar code back in the 1970s, and many—myself included—became convinced that the company's directive would be the tipping point leading to universal adoption of RFID tabs in consumer goods and elsewhere.

Posted March 15, 2009

BlueFinity International, a member of the Mpower1 Group of Companies, has added a new product to its range of Microsoft development tools for MultiValue users. BlueFinity's mv.SSIS allows MultiValue users to extract data from any major MultiValue database (in both bulk and filtered export mode) into MS SQL Server using Microsoft's SQL Server Integration Services (SSIS) product.

Posted March 15, 2009

Entrinsik, well known in the MultiValue arena for database reporting and analytics software and services for the UniVerse and UniData databases from IBM, is announcing the feature-complete beta release of a major new version of the company's Informer Web Reporting solution this month. The new release offers native access to multiple databases, including Oracle, SQL Server, MySQL, DB2, Informix, and Microsoft Access, in addition to UniVerse and UniData, as well as easy navigation and dynamic linking for reporting across multiple data sources.

Posted March 15, 2009

Varonis Systems, Inc., a leader in unstructured data governance, has announced the availability of version 4.0 of its DatAdvantage and DataPrivilege products, including complete synchronization and interoperability between the two applications to increase an organization's unstructured data protection. Version 4.0 includes many new innovations for unstructured data management that help to reduce errors, guide decision-making processes, improve accountability, and limit risk of data loss.

Posted March 10, 2009

In a new report in the Financial Times, Microsoft research chief Rick Rashid is quoted as saying that up to 20% of all the servers sold around the world each year are now being bought by a small handful of cloud companies—such as Microsoft, Google, Yahoo and Amazon.

Posted March 10, 2009

Information Builders, a leader in operational business intelligence solutions, and PBS&J, a multidisciplinary engineering firm with expertise in the design and implementation of information solutions, have announced an agreement to offer Information Builders' WebFOCUS BI platform as part of PBS&J's implementation and consulting services. PBS&J's Applied Technologies Group uses customized reporting and dashboard tools for many of its clients' solutions. With WebFOCUS, a proven and robust reporting solution, PBS&J will be able to speed up project timeframes, reduce certain implementation risks, and increase ease of maintenance.

Posted March 10, 2009

Infobright, the open source data warehousing company, has announced Infobright Community Edition (ICE) for Windows. In response to requests from the Infobright open source user community, the company now offers native support for its popular ICE open source data warehouse on the Microsoft Windows platform.

Posted March 10, 2009

IBM has released new Informix database software to help companies make decisions more intelligently and maximize sales opportunities while reducing expenses. With the new software, known as the Informix Warehouse Feature, global companies can both warehouse their data and conduct fast online transactions with a simplified software platform. The combination of the two capabilities in one offering can help deliver new results and insights to grow businesses and lower costs by making it easier to use existing Informix infrastructures to help clients work more efficiently.

Posted March 10, 2009

With more pressure on technology vendors to sell into a tougher market, this may represent a great opportunity for IT managers and executives to negotiate better deals. In

Posted March 03, 2009

Attunity, Ltd., a provider of real-time data integration and event capture software, has announced the availability of the public beta release of Attunity Oracle-CDC for SSIS. The beta product is "a bespoke solution" for the SQL Server and SSIS community that aims to make replication and real-time integration of Oracle data using SQL Server Integration Services (SSIS) robust and easy to deploy.

Posted March 03, 2009

ParAccel, Inc., provider of the ParAccel Analytic Database, a high-speed, low-effort, columnar database management system, has introduced the ParAccel Management Console (PMC), an integrated, easy-to-use system administration and configuration environment that includes a customizable system management report library built on Jaspersoft's JasperServer 3.0.

Posted March 03, 2009

Netezza Corporation, a global leader in data warehouse and analytic appliances, has announced that it has completed the acquisition of privately held Tizor Systems, a Massachusetts-based provider of advanced enterprise data auditing and protection solutions for the data center. This acquisition will allow Netezza's enterprise customers to track, store and perform forensic analysis against years of data access history and more easily meet regulatory compliance requirements.

Posted March 03, 2009

Microsoft Corporation has announced SQL Server Fast Track Data Warehouse, a new set of reference architectures for data warehousing that will help eliminate many of the barriers companies traditionally face while creating data warehouses. Priced on a per terabyte basis, SQL Server Fast Track Data Warehouse gives customers immediate access to pretested, preconfigured industry-standard hardware from partners Bull, Dell and HP that makes it easier and more affordable for companies to deploy enterprise-class data warehousing projects.

Posted March 03, 2009

Quest Software made a joint announcement with Microsoft at the recent VSLive! Conference in San Francisco, indicating that it will offer an Oracle Database Schema Provider for the upcoming release of Microsoft Visual Studio Team System (VSTS) 2010. Quest's new tool provides Oracle support for VSTS, enabling Oracle developers to fully participate with other VSTS team members throughout the entire application lifecycle. Previous to this, Oracle professionals could not benefit from the improvements in communication and workflow that VSTS offers. Oracle development in VSTS was limited, involved time-consuming manual processes, and did not support the system's new offline database development and design paradigm. With Quest's new tool, VSTS can now support both Oracle and SQL Server databases.

Posted March 03, 2009

Embarcadero Technologies plans to hold DataRage, three full days of online technical sessions and a virtual trade show targeted at DBAs, data architects, database developers, security experts, and other database professionals, from March 17 through March 19. "We needed a conference tuned to the massive user base that we have—and beyond," Greg Keller, chief evangelist at Embarcadero, tells 5 Minute Briefing.

Posted March 03, 2009

BlueFinity International, a member of the Mpower1 Group of Companies, has added a new product to its range of Microsoft development tools for MultiValue users. BlueFinity's mv.SSIS allows MultiValue users to extract data from any major MultiValue database (in both bulk and filtered export mode) into MS SQL Server using Microsoft's SQL Server Integration Services (SSIS) product.

Posted February 25, 2009

iWay Software, an Information Builders division and an innovator of enterprise integration solutions, has announced the immediate availability of a new iWay Enterprise Information Management (EIM) Suite. Designed to provide complete business visibility with speed and accuracy, the suite lowers the total cost of information management by addressing enterprise information needs in a single platform with reusable services.

Posted February 24, 2009

TIBCO Software Inc. has announced two new products, TIBCO Spotfire Miner 8.1 and TIBCO Spotfire S+ Server 8.1, that allow enterprises to incorporate and deploy predictive analytics on very large data sets in a wide range of business applications. The two products encourage better, more informed business decisions across the enterprise by utilizing the TIBCO Spotfire Enterprise Analytics Platform to deploy business applications that utilize powerful data mining, statistics and predictive modeling to discover hidden patterns, anticipate opportunities in a volatile environment, and optimize investment in limited resources.

Posted February 24, 2009

The Oracle Applications Users Group (OAUG), the world's largest user knowledgebase for Oracle Applications users, announced the 2009 list of associate member organizations participating in the OAUG Star Partner Program.

Posted February 24, 2009

Sybase has unveiled Sybase IQ 15, the next generation of its column-based analytics server. The new release is focused at "filling a critical need for enterprises, especially in this economy, that need to do more sophisticated real time analytics to drive decision making" and that "need to do that on large volumes of data, but without sacrificing their profit margins," Lisa Hopkins, director, product marketing, Sybase, tells 5 Minute Briefing.

Posted February 24, 2009

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

Sponsors