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!
|