Email not displaying correctly? View it in your browser.
New White Paper: ETL Speed
Optimizing Data Integration Performance

Enterprises facing unparalleled levels of data growth are trying to meet the challenges of preparing and franchising their data given limited timeframes and budgets. While many project architects look for the next emerging technology to address their volume-related bottlenecks, the successful ones use tools and techniques that already exist, are affordable, and can be quickly implemented.

The best approach to these large-scale data integration tasks is to leverage file utilities on structured data sets. While tried and true tools like CoSort may not get the attention that emerging technologies do, they are part of the savvy data integration practitioner's "tips & tricks" arsenal.

In a new white paper available from IRI, Athena IT Solutions founder, Rick Sherman, draws on 20+ years of data warehousing and decision support systems experience to outline and remedy the major bottlenecks in data integration. Click here to request the white paper.


Data Masking Software: Beta Ready

Free Release Version for Your Early Feedback

As interest in CoSort's field-level encryption and data masking capabilities for flat files grows, IRI is working to release a standalone product called FieldShield™. FieldShield will address the need for data-centric security in CSV, XML, LDIF, and other sequential file formats.

FieldShield will include AES-256 and de-identification functions for fields at risk, and continue to support pseudonymization, anonymization and redaction options as well -- without the cost of CoSort's parallel sorting, data transformation and reporting functionality.

If you are interested in becoming a beta site for FieldShield, please let us know. In exchange for your confidential feedback, you will be entitled to a free first release copy of the product. 


ICETOOLto CoSort Migration

Functional Overlaps with SortCL

Those familiar with IBM DF-SORT and CoSort have long known that CoSort's MVS2SCL and VSE2SCL utilities convert JCL parms for sorting, selection, and summation functions into their equivalent Sort Control Language (SortCL) job scripts. In the more advanced ICETOOL environment, however, only manual conversion of certain job streams are possible.

Functionally, ICETOOL and CoSort's SortCL program commands overlap. For example, the "SPLICE" command is analogous to SortCL's /JOIN. ICETOOL's DISPLAY translates into SortCL header reporting functions, VERIFY may equate to SortCL "iscompares", RANGE works through SortCL input /INCLUDE and output /COUNT logic, and SELECT is similar to /NODUPLICATES. ICETOOL commands like COPY, OCCUR, MODE, COUNT, SORT, STATS and UNIQUE have more straightforward SortCL equivalents.

Operationally, the tools differ in execution and logic flow. Depending on the complexity of an ICETOOL script, several SortCL jobs may need to be customized and executed separately to achieve identical output results. If you are interested in migrating from ICETOOL jobs to CoSort, please contact IRI for feasibility and project cost assessments.



IRI Expert Partner Spotlight
Scalable Systems Specializes in ETL, BI

IRI's alliances with leading platform providers and solutions experts enhance the functionality and applicability of CoSort (and its related tools) across a variety of IT disciplines and applications. One such example is the New Jersey-based consultancy Scalable Systems.

Specializing in software solutions and integration services, Scalable Systems is a premier global consulting, development, and IT outsourcing company. Scalable has proven expertise in using high quality (but affordable) software solutions and services. With concentrations in data warehousing, business intelligence, and custom application development, Scalable maximizes client return on investment by leveraging its expertise and advanced technologies like CoSort. Scalable is familiar with the role CoSort's SortCL plays, for example, in large scale data integration and staging in performance-conscious data warehousing environments.



Tech-Tip: Color-Coded Job Scripting

Try Notepad++ for SortCL, RowGen & NextForm

Modern text processors now make editing CoSort and compatible job scripts easier. Such editors provide a way to define the keywords and syntax of a language, and then display those components in color. One such editor that IRI software developers and support engineers use is Notepad++.

The open source Notepad++ program is free to download, use, and modify. Because Notepad allows custom language definitions, IRI created a custom file to add color-coded syntax editing for CoSort SortCL job scripts. As RowGen and NextForm use SortCL-compatible syntax, these users can also benefit from the same definition file. Follow the instructions below to download and install everything needed to begin job editing in color:

Download the latest Notepad++ installer for Windows from:
      http://www.download.com/Notepad-/3000-2352_4-10327521.html
Then, download the definition file for SortCL from: http://www.iri.com/public/userDefineLang.xml
and save it to the Notepad++ folder as "userDefineLang.xml".

Run the Notepad++ editor from the Start menu, and then open or create a SortCL script. Advanced users can even change the colors and other behaviors.  Just select "User Define Dialog..." from the "View" menu to make changes. 

 

 

 

Top 5 reasons to network online:

Professional online networking plays a vital role in the success of organizations in many industries because it changes the way people communicate.  Networking changes the way others interact with brands and products they find useful.  It also helps to evaluate products previously used. 

Why and how should you influence this trend?

1.  Users trust their network, not vendor advertising or marketing techniques.   

This is one of the most accepted changes created by Web 2.0.  People rarely trust a company's marketing message anymore for large purchasing decisions.  This is especially true when their company's name and reputation are on the line.  They trust their colleagues, "friends", and networking affiliates who have successfully used the products in question.   The "friends" may be other members of an online community, or they may be strangers who posted product reviews. Your reaction should be "Stop the press, and get into the conversation."

2.  Users expect others to talk. 

This is particularly true for late generation X and early generation Y, better known as Millennials.  Those climbing to higher positions on the company ladder grew up in a world where interactive, shared media is all they know.  When this crowd (who makes up 59% of the workforce) gets online, they expect to interact with each other and not be fed a webpage to read.  Since 59% of Millennials are potential decision makers, companies need to interact with them. 

3.  The crowd has the influence. 

People who have a great experience with technology speak much more readily about their bad experiences. And since news travel fast, companies have to respond by: 1) listening to the problem; 2) joining the conversation; and 3) fixing the problem. To maintain professionalism, do not get defensive or deny the problem. Rather, explain why it is that way, and/or acknowledge the feedback as helpful guidance for product improvements.

4.  User produced content has more value than you think. 

Though it may give journalists, authors, and speakers competition, user content is a good thing.  Encourage your customers to share their expertise and opinions.  This can be especially useful if: 1) they use and like your product; 2) you want to learn what consumers think of your company and its offerings; and 3) you want to learn what customers would like to see from you in the future. Remember, when current users talk, prospective users listen.

5.  Customers say what they want, so listen. 

In a Web 2.0 atmosphere, companies get to absorb a wide range of influencers expressing their opinions, needs, and wishes.  When a company proactively listens to what their audience is saying, they can innovate faster and more intelligently than their competitors.   This will not only put you and your company in the ring leader circle, but will achieve positive word of mouth. 

By way of example, this page at ITtoolbox shows how IRI shares and gains knowledge about CoSort technologies via an interactive online forum. Please CONNECT with us to join the conversation and share your thoughts!







You should be receiving this newsletter on an opt-in basis as part of your current or prospective business with Innovative Routines International (IRI), Inc., The CoSort Company. If you wish to opt-out at any time, simply unsubscribe with the link provided. Opt-in and out actions are confirmed in writing. IRI does not disclose email addresses to third parties.

Unsubscribe all@iri.com from this list.

Our mailing address is IRI, Inc. (CoSort) 2194 Highway A1A Suite 303 Melbourne, FL 32937 and our telephone number is USA 1.321.777.8889.

Copyright © 2008 IRI, Inc. All rights reserved. CoSort is a registered trademark of IRI, Inc. SortCL, RowGen, NextForm and FieldShield are trademarks of IRI, Inc. FACT is a tradmark of IDS Co./DataStreams (CoSort Korea) Ltd.

Forward this email to a friend.