Undraleu FAQ

Undraleu - Datastage FAQ

What kind of Infosphere Datastage Objects are supported by Undraleu?

Undraleu can perform reviews of most Infosphere Datastage code/configuration objects including Projects, Folders, Jobs, Stages, Parameters, Job/Stage Configuration and much more. The best practices are a result of a careful analysis of industry standards and our expertise. We strive to engage very closely with our customers from where we enrich our library of best practices constantly.

Will my rules/best practices stop working when we migrate to a new version of Infosphere Datastage?

No. The rules/best practices are version independent. However, we provide communication to all our clients on any possible hurdles well in advance and provide road-maps to migrations. In a highly unlikely scenario where our customers require migrating ahead of our having certified the rules against the new release of Infosphere Datastage, we will discuss this with the customer to provide them a least disruptive course of action.

Undraleu - Informatica FAQ

Will my rules/best practices stop working when we migrate to a new version of Informatica PowerCenter?

No. The rules/best practices are version independent. However, we provide communication to all our clients on any possible hurdles well in advance and provide roadmaps to migrations. We hope to work very closely with Informatica and develop and test the best practices as soon as Informatica announces new releases. In a highly unlikely scenario where our customers require migrating ahead of our having certified the rules against the new release of Informatica PowerCenter, we will discuss this with the customer to provide them a least disruptive course of action.

Does Undraleu support Velocity standards?

Yes and a lot more, Undraleu has rich library of rules/checks and best practices, a small subset of which are Velocity standards.

Does your Undraleu run against the repository directly or MX views?

For the range of rules/checks Undraleu comes with, MX views are very limited. We access the repository tables directly in a read-only manner to perform the conformance checks.

We use Deployment Groups to Deploy the code. Can Undraleu review our deployment groups before they are deployed?

Yes, Undraleu can review deployment groups and also labels if you use them. Many of our customers are using Undraleu to review their deployment groups before taking a decision of go or no-go for the deployment. This capability has been helping Informatica Administrators in assessing code to ensure it meets standards.

We use Team Based Development. Does Undraleu Support it?

Undraleu supports both versioned and non-versioned repositories.

Can we review multiple objects simultaneously?

Yes. You can select one or more Projects which may have one or more Repositories or All Folders or all Objects or select individual objects for the review.

Undraleu - Oracle Data Integrator(ODI) FAQ

Can we review multiple objects same time?

Yes. You can select one or more repositories or one of more Projects or All Folders/Sub Folders or all Objects or select individual objects for the review.

What kind of Oracle Data Integrator (ODI) Objects are supported by Undraleu?

Undraleu can perform reviews of most Oracle Data Integrator code/configuration objects including Projects, Folders, Interfaces, Knowledge Modules (KMs), Packages, Procedures, Models, Load Plans, Scenarios, Sequences, User Functions, Variables and Sessions. The best practices are a result of a careful analysis of industry standards, our expertise and recommendations from Oracle. We strive to engage very closely with our customers from where we enrich our library of best practices constantly.

Will my rules/best practices stop working when we migrate to a new version of ODI?

No. The rules/best practices are version independent. However, we provide communication to all our clients on any possible hurdles well in advance and provide road-map to migration/upgrade. Our key objective is to develop and test the best practices(new and old) as soon as Oracle announces new release. In a highly unlikely scenario where our customers require migrating ahead of our having certified the rules against the new release of Oracle Data Integrator (ODI), we will discuss this with the customer to provide them a least disruptive course of action.

Undraleu Functionality

What kind of Rules/Checks Undraleu Covers?

There are various rules that Undraleu provides. These are a result of constant collaboration between our customers and our research and interaction with the ETL Development community. We typically classify the rules into categories (for Qualitative Impact) and criticality (for Severity Impact). Undraleu rules address a range of categories and criticalities including data loss, error handling, performance, maintenance, documentation and show stoppers, critical, major etc.

We have completed our evaluation of Undraleu and would like to preserve our customization and move to a Production License. Is it possible?

Yes, this is a common requirement for all our customers who have done an evaluation and moved to a production version. We provide two paths to production installation of Undraleu:
1. Fresh Install (First time install)
2. Upgrade from Evaluation Version.
We can help you follow the path #2 and preserve your evaluation environment and migrate your evaluation environment to a production environment very easily, at no additional cost.

How do Undraleu upgrades affect customized rules?

The upgrades are independent of the customization done by the users hence will not affect any of the existing rules and their customization.

Can we customize the rules/checks?

Yes. There are some rules that can be customized e.g. naming convention. There are other rules that are looking for a selected option e.g. “Aggregator Sorted Input Enabled”. We appreciate that each organization may have adopted different standards and also within each organization different code sets/projects may adopt different standards. Undraleu allows you to customize as per your projects' requirement. Let us go over an example to illustrate the naming standards for mappings. We provide a default prefix of "m_" for a mapping name. You may want to adopt a "MP_" across your organization. You can override our value to apply instead "MP_" as your standard. Yet, there may be some legacy projects that may have used a naming convention of "MAP_" for mappings. You can allow a further override at the legacy project level to accept "MAP_" as the standard and still allow the rest of the organization to conform to "MP_". This allows you to embrace your own standards seamlessly yet allow enough flexibility in a controlled manner.

Undraleu General

Why does CoeurData recommend an Undraleu license for the production environment?

Most organizations have been using Informatica since a long time and have a lot of legacy code that undergo maintenance along with more recent code. From our experience, we realize that most companies have challenges in production environment. One quick win in having Undraleu run on production environment is to identify and learn from the findings and not repeat those mistakes in new deployments. This will ensure stemming any new issues from cropping up in production environment.

We don’t believe that a tool can manage our code reviews better than our current and traditional reviews which are very thorough. Why should we consider Undraleu?

While there are development shops which are very well structured and conduct code reviews thoroughly, in all possibility it is a manual review. Such shops which pride themselves in their personnel and code reviews can benefit even further by automating their code reviews and spare themselves with at least a few hours of the time they spend in performing the code reviews and deliver more projects and improve their overall value from their stake holders’ perspective. In short, using Undraleu, you can develop more of the good code you have been developing without Undraleu.

Who do you think are target users for Undraleu

Anybody or everybody who has an interest in the quality of the code being developed, maintained or supported. Some of the roles' of folks who are currently using Undraleu are:
  • Developers
  • Technical Leads
  • Administrators
  • Project Managers
  • Application Managers
  • Quality Assurance
  • Deployment Managers
  • Operations/Platform Managers
  • Architects
  • CTO’s

Most of our ETL work is done offshore, how can Undraleu assist?

Off-shoring has been embarked by various organizations for multiple reasons. Some reasons have been questioned and some proven. One pain-point we see in off-shoring, outsourcing, near-shoring, right-shoring or whatever the arrangement is, there is no transparent definition and monitoring of quality. Undraleu was built to bring in code quality monitoring in a self-service manner. This allows everybody and anybody to monitor the code quality. Through Undraleu, you can now make it mandatory for your offshore service providers to enforce quantified, measurable and consistent code governance. The standards can be decided by your team and communicated to the offshore team. The offshore team can scan the code against the agreed standards to ensure they are in conformance to them before they deliver the code. The client can double check to ensure what has been delivered meets the standards agreed. In a multi-vendor arrangement Undraleu can be also used to evaluate the quality of the different vendors and take a decision to continue or discontinue a vendor’s services using facts.

I think we would benefit a lot from having Undraleu but need help in quantifying the benefits of Undraleu for creating a business case, can you assist?

There are some clear benefits from using Undraleu® that include all the benefits you expect by following set best practices. However, there are some hard to measure benefits that we can’t quantify examples include reduction in support, maintenance and on-call costs. Please contact us and we can help quantify the benefits and help build a business case for you.

Is Undraleu easy to learn?

While building Undraleu, we kept simplicity as the core objective. We can’t dispute the findings of Heisenberg’s Uncertainty principle but in our goal to make ETL in general and Informatica Development in particular more productive, this tool does cause one extra step (i.e. login and select the code to review) but the outcome of the review should improve the long term code quality, supportability, maintainability and other key aspects of code quality.

Our Development Team has built a similar tool? Why should we consider Undraleu?

We are twins! We are always looking for opportunities to improve Undraleu further. Also, taking a look at Undraleu may also provide some pointers to improve your tool. However, here are some benefits of not doing it on your own:
1. Unless your company's business is developing such a tool, you are not directly working for its strategic goals.
2. It needs a lot of maintenance and unless you have an entire team working on it you will perhaps be not enhancing it much.
3. It is also possible that some key folks are just managing the software and not developing systems that your business needs.
4. Industry collaboration - Undraleu's customers have been critical for its features and enhancements. From couple of hundred rules to now more than 500 rules we wouldn't have been able to do it alone. We benefit from more than 1500 users across our customers and their feedback to make Undraleu constantly evolve and provide value to our customers.
5. It provides better ROI.
6. You don’t have to worry about upgrades etc.

Undraleu Terminology

Rules
A rule is a single best practice. You can pick the rule or group of rules you want your code to be checked against and create a rulelist.
RuleLists
A rulelist is a group of rules or checks that you would like to use to measure your code against. A rulelist can have one or more rules. This is a good way to group rules that perform a particular set of checks. For example a rulelist can be created for Development activities of a project. Another rulelist can be created for Production checks or for performance etc. This enables checking different aspects of code for more insight into specific anomalies. Rulelists can be managed at site, project or user level. Site level rulelists are also referred to as Shared Rulelists. Shared rulelists are available to all projects and all users.
Category
Each rule or best practice has a reason or area that it will impact if not followed. Undraleu refers to them as Category. Examples of Categories are: Maintainability, Readability, Supportability, Complexity etc. Each rule or best practice may belong to one or more Category. For example not following naming conventions may make the code not easy to maintain and not easy to read.
Criticality
Criticality is a way of assessing the impact of violating a best practice. Undraleu allows managing the Criticality level of each rule (it can be user defined). Examples of Criticality are: Show-Stopper, Severe, Major, and Minor. By marking a best practice to one level of criticality allows a quick assessment of the code to be of a certain level of quality.
Criticality levels can drive whether the quality of the software is meeting expected standards and whether the code should promoted to production or refactored.

Undraleu Technical Requirement

Can we have an evaluation copy of Undraleu?

Yes, we recommend it and are happy to provide it. Please contact us and we can work towards it

What are the architectural requirements for Undraleu?

Undraleu is developed using very simple and mature technology stack. It needs a JRE, a small database to manage itself, a webserver and finally read only access to Informatica Repository objects. While Undraleu can be installed on the same server as other Informatica components, it is not a pre-requisite. Undraleu can be installed on a separate server with connectivity to the Informatica Repository database. Undraleu supports most Operating Systems including Windows, Linux and Unix (most variants).