Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Cloud
    • Database

    Embarcadero Clusterizes Its ETL Tool

    By
    Lisa Vaas
    -
    November 7, 2005
    Share
    Facebook
    Twitter
    Linkedin

      Embarcadero is answering the clustering craze, putting out an update to DT/Studio—its ETL technology—thats been re-architected in its design piece, its engine and its management console.

      The company on Tuesday will announce DT/Studio 3.0, an update that features new, advanced data modeling capabilities, improved performance and scalability, and extended task management and monitoring.

      With clustering worked in throughout the product, customers will be able to crank up the amounts of data they churn through the extraction, transformation and loading tool, according to Glen Hawkins, product manager of data integration solutions.

      “We have customers dealing with hundreds of gigabytes of data,” he said. “Before, they would have separate engines running separately but not in clustered mode.”

      DT/Studio 3.0 combats that scenario with clustering and parallel processing capabilities in order to meet large data load demands, improve server efficiency and ensure future scalability, he said.

      In addition, its new ability to do dimensional modeling provides an organized, flexible way to capture de-normalized metadata, allowing for the capture and representation of all aspects of dimensional models in order to shed light on data sources and to ease communication.

      Also, import/export metadata allows users to leverage standard formats such as CWM and XML in order to ensure consistency and compatibility when collaborating and exchanging metadata between tools and applications.

      /zimages/3/28571.gifClick here to read about upgrades to EnterpriseDBs open-source database.

      The focus on dimensional modeling is a reflection of how Embarcadero Technologies Inc. is zeroing in on data warehousing and the data mart world, Hawkins said.

      Whereas normalized models represent regular databases, dimensional databases have a different metadata associated with them.

      Regular modeling is used to represent a regular, operational database, whereas dimensional modeling is used to generate the reports that have become so popular with all the new dashboards and business intelligence functionality entering the market.

      The new version also adds extended database connectivity, leveraging native bulk facilities in the latest version of Teradata for improved performance, but also supporting ODBC and JDBC options.

      The product also supports Oracle 10g. Native support for SQL Server 2005 will come in the next point release, probably due around January, Hawkins said.

      Another feature of DT/Studio 3.0 is the ability to automatically restart if a target database goes down, with the tool picking up where it left off in the case of moving a group of records, for example.

      /zimages/3/28571.gifNew security risks hit Oracle. Read more here.

      And, giving a sneak peek at where Embarcadero is going with the tool, another new function allows users to understand not just their data structures, as is the case in the update, but also the quality of data, Hawkins said.

      Thus in the update users can determine if there are duplicated records or if Social Security numbers are valid, for example, and they can then use business rules to remove Social Security numbers or whatever else they want to do, Hawkins said.

      DT/Studio is available now.

      /zimages/3/28571.gifCheck out eWEEK.coms for the latest database news, reviews and analysis.

      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

      MOST POPULAR ARTICLES

      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Applications

      Cisco’s Thimaya Subaiya on Customer Experience in...

      James Maguire - May 10, 2022 0
      I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×