Welcome!

Recurring Revenue Authors: Yeshim Deniz, Liz McMillan, Elizabeth White, Zakia Bouachraoui, Pat Romanski

News Feed Item

IRI Automates Big Data Integration Jobs with Oracle Scheduler

Dependent DW and Reorg Operations Can Run without ETL Suites

MELBOURNE, Fla., Dec. 18, 2013 /PRNewswire/ -- Innovative Routines International (IRI), Inc., a leading developer of fast data management and data-centric protection software, has automated inter-dependent extraction (E), transformation (T), and loading (L) operations using Oracle's job scheduling engine, DBMS_SCHEDULER. An IRI white paper details and demonstrates the tie-in.

Data warehouse architects and DBAs use IRI FACT (Fast Extract), CoSort, and bulk database load utilities (like SQL*Loader) to perform ETL, accelerate existing ETL suites, or reorganize very large databases. According to Athena IT Solutions founder and BI/DW expert, Rick Sherman, "offloading to flat-file transforms and bulk-loading tables pre-sorted is the fastest, cheapest way to stage big data, and takes serious weight off the database."

After bringing these tasks into the popular IDE of Eclipse, "IRI went a step further and showed how Oracle users could perform ETL or set up unload/sort/reload (reorg) operations without costly ETL or scheduling packages," explained IRI Workbench developer Benjamin Burkett. Oracle-scheduled jobs can run inside the IRI Workbench GUI – which supports Oracle table connections for browsing and SQL operations – or in any database application context.

DBAs can specify not only when to initiate FACT unloads, CoSort sorts/transforms/reports, or bulk loads, but also set up dependencies between these processes. Burkett provided an example wherein a DBA "starts FACT at 2am, checks for success before running CoSort, and then confirms the table is not in use before running the pre-CoSort'ed direct path load into SQL*Loader."

About Oracle Job Scheduler
The Oracle Job Scheduler helps users manage and plan different tasks by implementing them without manual intervention. By scheduling jobs to operate at certain times, users can lower operating costs, execute jobs whenever they prefer, and minimize human errors.

About IRI, The CoSort Company
Founded in 1978, Innovative Routines International (IRI), Inc., is an independent software vendor specializing in data management and protection. Headquartered in Melbourne, Florida, IRI has licensing and support offices in more than 40 cities worldwide. IRI's product line shares a common metadata layer and Eclipse GUI supporting two back-end suites: The IRI Data Manager, featuring CoSort® (data transformation), FACT™ (fast extract), and NextForm® (data conversion); and, the IRI Data Protector which includes FieldShield® (data masking) and RowGen™ (test data).

Press inquiries only to:
Jason Koivu, Marcom Director
IRI, The CoSort Company
(321) 777-8889 ext. 210
[email protected]

SOURCE IRI, The CoSort Company

More Stories By PR Newswire

Copyright © 2007 PR Newswire. All rights reserved. Republication or redistribution of PRNewswire content is expressly prohibited without the prior written consent of PRNewswire. PRNewswire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

IoT & Smart Cities Stories
After years of investments and acquisitions, CloudBlue was created with the goal of building the world's only hyperscale digital platform with an increasingly infinite ecosystem and proven go-to-market services. The result? An unmatched platform that helps customers streamline cloud operations, save time and money, and revolutionize their businesses overnight. Today, the platform operates in more than 45 countries and powers more than 200 of the world's largest cloud marketplaces, managing mo...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
When Enterprises started adopting Hadoop-based Big Data environments over the last ten years, they were mainly on-premise deployments. Organizations would spin up and manage large Hadoop clusters, where they would funnel exabytes or petabytes of unstructured data.However, over the last few years the economics of maintaining this enormous infrastructure compared with the elastic scalability of viable cloud options has changed this equation. The growth of cloud storage, cloud-managed big data e...
Your applications have evolved, your computing needs are changing, and your servers have become more and more dense. But your data center hasn't changed so you can't get the benefits of cheaper, better, smaller, faster... until now. Colovore is Silicon Valley's premier provider of high-density colocation solutions that are a perfect fit for companies operating modern, high-performance hardware. No other Bay Area colo provider can match our density, operating efficiency, and ease of scalability.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
ScaleMP is the leader in virtualization for in-memory high-end computing, providing higher performance and lower total cost of ownership as compared with traditional shared-memory systems. The company's innovative Versatile SMP (vSMP) architecture aggregates multiple x86 systems into a single virtual x86 system, delivering an industry-standard, high-end shared-memory computer. Using software to replace custom hardware and components, ScaleMP offers a new, revolutionary computing paradigm. vSMP F...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...