Paul LaPointe's picture
Personal Website:
Day Job:
blog icon Recent Articles

Benjamin Franklin once observed " this world nothing can be said to be certain, except death and taxes". Planned down time can easily be added to that list. It's a certainty that any given IT system will require some planned down time to address security fixes, make configuration changes, or expand storage and compute capacity. Smart businesses always stay ahead of these demands, and promptly patch or upgrade their systems, but that often comes with a cost in down time.

Unity Director has a wide set of capabilities to control where users and requests are routed. Unity Director 15.00 now offers so many choices and ways to control things; they can be a little confusing. Let's talk about some of the most common uses for the available routing options (and some cool ones you might not have considered yet).

Getting from here to there – A phased rollout of Unity Director & Loader

Life often requires comprises. In a data warehouse, there's often a trade-off between providing quick response times to reporting users running complex reports, and loading tables with new up-to-date data. Adding join-indexes to a table can speed up reports, and solve redistribution problems, but do come at a cost to table updates.

One of Unity Director and Loader’s core benefits is the ability to keep multiple Teradata systems synchronized with online, transactional-consistent, changes. Unlike post-transactional replication, Unity Director’s SQL-multicast sends requests in parallel to all connected systems at the same time. It also performs consistent checking on the responses of every write statement to ensure changes both systems succeed and produce the same results.

Unity Director currently has a number of limitations regarding the use of stored procedures. These limitations are often misunderstood, and mistakenly lead to the assumption that stored procedures are not currently supported by Unity Director. This is not the case – while there are a number of considerations to be aware of, most stored procedures can be used with no issues.

Unity Director is an extremely capable product that offers a wide variety of benefits. One of it's unique benefits is the ability to easily route users and requests to specific Teradata systems. There are many potential uses of this ability; but one use, in particular, is to selectively direct users that want access to historical data to specific systems where the data resides. 

blog icon Recent Reference

Paul LaPointe hasn't created any reference articles.