Diving Deeply Into Databases
Altova’s 2008 products emphasis database connectivity
October 3, 2007 —
(Page 1 of 2)
If a trading partner sends another partner an XML file, the safe money is that it is not formatted to fit a particular table in that partner's database, and neither is that XML feed of calendar information that the marketing department subscribes to.
Scenarios such as these motivated Altova to broaden the database functionality of its 2008 product line, said Tim Hale, Altova’s director of global marketing.
The 2008 versions of Altova DatabaseSpy, MapForce, StyleVision and XMLSpy have new capabilities to connect to relational databases, and edit, query and view relational data and XML data stored within. The products were released in mid-September.
DatabaseSpy 2008 provides a unified interface, query and design tool for multiple databases from major vendors, including those from IBM, Microsoft and Oracle. It can now create and edit database views—stored queries of data from database tables—as well as stored procedures, with the goal of optimizing repetitive SQL statements.
Altova also added database content editing functionality to DatabaseSpy, designed to enable users to edit and retrieve content in existing database tables, add rows to insert new data or delete rows through a point-and-click paradigm. Changes are not applied against production databases until the user reviews them and commits to the change.
When a calendar RSS feed has field values that differ from a database input field, data conversion is necessary. MapForce 2008 adds a value map function that transforms field values from the source to the target, said Hale, making it possible, for example, to swap numbers for the names of the months that represent them.
MapForce is a data mapping, conversion and integration tool that maps database, EDI, flat file, Web services and XML data to generate integration applications for recurrent conversions. The new version has more options for customizing XML output generated when mapping data to an XML file, and aggregate data processing functions.
A database connection wizard and Altova’s database query window was added to Altova’s StyleVision stylesheet designer. New features also make it possible to reuse portions of existing design files when creating new designs.
Share this link: http://sdt.bz/31191
Most Read Latest News Blog Resources
Zeichick’s Take: Radio moves from analog waveforms to digital packets
Streaming radio highlights the need for streaming applications to be designed to take up as little bandwidth as possible
|
|
Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans
|
|
Appcelerator Acquires Cocoafish to Add Instant Mobile Cloud Capabilities to its Industry Leading Titanium Platform
Appcelerator Offers Messaging, Social, Location and Storage Mobile Cloud Services to All Mobile App Publishers
|
|
ComponentOne Releases a Collection of 40+ UI Widgets Powered by HTML5 and jQuery
ComponentOne has announced the 2012 release of Wijmo: a kit of UI widgets for HTML5 and jQuery development
|
Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans
|
|
Top five apps to manage your workload
Web applications offer new ways to track your “to-do” lists
|
|
Not so fast when it comes to testing in the cloud
Developers face outsourcing, virtual lab management and mobile devices as obstacles
|
|
Xceed releases UX-focused suite for Microsoft’s WPF
"Blendables" helps match user experiences to developer visions
|
Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.
|
|
Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
|
|
RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
|
|
GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
|
The Hidden Costs of Software Licensing
Moving beyond paper-based software licensing to more flexible, software-based licensing is a business decision. There is a growing trend tow...
|
|
Case Study: You May Need a Development Mechanic
As a contractor for a major financial player in Germany, SOBEGE, a German-based consultancy specializing in embedded IT and web services, wa...
|
|
Ensuring Software Quality at a Major International Bank
One of the world’s leading international banks has adopted AgitarOne technology for delivering generated unit tests for their Java software...
|
|
Load Testing Adobe Flex Applications
Adobe Flex applications may be different from applications you’ve worked with before. For classic HTML web applications, the server does all...
|