Unity Director 14.00 and Unity Loader 14.00 are now available!  Last year Teradata announced a new query management and data synchronization product to the marketplace.  Now we've taken it to the next level.  Unity Director 14.00 provides a new user interface, new and improved routing rules and scalable configuration options.  Unity Loader 14.00 is a new offering extending beyond the basic synchronization of SQL updates and now enabling the intelligent synchronization of high volume/bulk loads. 

Leveraging Teradata's patented SQL Multicast technology, Unity Director and Unity Loader continue to change the paradigm of query management and data synchronization across multiple Teradata systems. Here are a few highlights of the 14.00 releases.  

Unity Director 14.00

Unity Director is focused on query management and SQL-based data synchronization across multiple Teradata systems.  For query management, Unity Director enables not just query failover but also intelligent query routing based on the SQL object being accessed.  Users can choose from several routing modes: Named, Preferred, or Auto Routing.  Director 14.00 now provides the ability to designate a given system for specific CREATE operations, allowing for greater control of certain workloads - great for in-database transformations or BI tools that leverage temporary tables.  Unity Director 14.00 also made some significant improvements with respect to authentication, now supporting LDAP, Kerberos and SPNEGO authentication protocols.   

Unity Director 14.00 provides greater scalability as well.  Not only does it support a greater number of database objects and concurrent sessions, but it also introduces a new Teradata Managed Server for increased recovery log space for both SQL-based and Bulk Load (Unity Loader) operations.  The new Teradata Managed Sever itself provides new levels of scalability in that customers can now configure multiple servers in a single data center based on their data synchronization and load volume requirements.  

Finally, Unity Director 14.00 introduces a brand new user interface.  To be more consistent with other applications in the Teradata Analytical Ecosystem, Unity Director has replaced its original UI with a Viewpoint portlet.  The new user interface allows for greater flexibility when configuring systems under Director control and defining specific routing  rules.  

Unity Loader 14.00

In the past, synchronizing large volumes/bulk data to two or more Teradata systems required a custom-built dual-load engagement.  With the introduction of Unity Loader 14.00, custom dual-load solutions are no longer needed.  Unity Loader is a powerful offering providing intelligent and selective routing of bulk loads to the appropriate Teradata system.

Like Director, Loader applies Teradata’s patented SQL Multicast technology - yet Unity Loader goes beyond SQL-based operations and enables the Teradata Parallel Transporter bulk load utilities.  This allows customers to direct their  Teradata Parallel Transporter load jobs at Unity Loader, and Loader will intelligently deliver the updates to one or more systems based on where the data object exist.  Specifically, Unity Loader 14.00 support the bulk load utilities of TPT Load and JDBC Fastload.  Future releases will expand the support for additional bulk load utilities.  
 
Unity Loader is tightly integrated with Unity Director to help coordinate writes and ensure appropriate sequencing of bulk load operations.  Unity Loader also shares the same Teradata Managed Server with Unity Director and does not require any addition data center footprint.
 
The combination of Unity Director and Unity Loader allows customers to seamlessly and intelligently managed queries, synchronize SQL-based and bulk loads, and provide transparency in the event of system outages.  All of this while using a common, easy-to-use interface to add additional Teradata systems to the Analytical Ecosystem with minimal effort.

Additional Resources

For more information on Unity Director 14.00 and Unity Loader 14.00, follow the links below. 

Discussion
tomn 2 comments Joined 06/11
21 May 2013

After reading you article I have the following questions:
1) Will Unity Director/Loader require a new or upgraded TMS Server if Customers are using TMS Servers with 13.10?
2) Regarding data-syncronization and TPT Bulk Loading -   If we have TD-system-A and TD-System-B and:
          - we buk load data, If TD-system-A already has the table will it perform UPSERTS and if TD-system-B does not have the table will it be created and perform INSERTS?      IF yes,  how would it handle post syncronization validations?  
 
Thanks,    Tom
          
     

ARyan 4 comments Joined 01/08
30 May 2013

Hi Jeff,
does Unity Loader support FICON (Channel) connections ? If not are there any plans to add support for this ?
Andrew Ryan
 

schemanske 12 comments Joined 02/10
31 May 2013

Andrew - Unity Loader does not support FICON channel connections today.  Our plan is to support mainframe in the futrue, yet there is no committed date for this functionality.  

schemanske 12 comments Joined 02/10
31 May 2013

Tom - 
Sorry for the delay in response.  
1) Unity Director/Loader 14.00 will only require a new managed server if Unity Loader is purchased.  If you are only using Unity Director 14.00, no new mananged server is need, the Director 13.10 server is sufficient.  Since Loader manages the bulk load operations, a much more powerful managed server is needed with additional disc capacity.  Summary:  when purchaseing Loader 14.00, a new managed server is required.
2) The SQL Multicast function of Director/Loader works slightly differently than you described.  When doing a TPT Load through Director/Loader, we will apply the load to where ever the affected SQL Object exists.  So if the table only exists on System A, we will apply the load only to system A.  The Director Data Dictionary keeps track of what tables exist in each system.  If desired, you could  use Unity Data Mover (different product) to perform a one-time table copy to system B, put that table on system B under Director control, and then Director would apply any future INSERTS to that table to both systems.  
Hope this helps. 

geethareddy 93 comments Joined 10/11
11 Jul 2013

hi Jeff,

I heard about Unity Director, Unity Loader products in Ecosystem. But is there any element known as Unity Data Mover(DM). I know Data Mover and its functionality. We are implementing the HA solution over here, i heard the word Unity Data Mover. I am not sure whether there is a seperate product knwn as Unity DM or it is same as DM.
Appreciate your comments on this.

Thanks,
Geeta

Thanks,
Geeta

schemanske 12 comments Joined 02/10
11 Jul 2013

Geeta - "Unity Data Mover" is the new name for what was formerly known as "Teradata Data Mover".  (same product, new name) This was part of a rebranding effort to group certain products under the Teradata Unity Portfolio of products.

geethareddy 93 comments Joined 10/11
11 Dec 2013

Jeff,
I think TD did not publish any manual on Teradata Unity Loader User Guide or Configuration guide. Am i correct?

 

Thanks,
Geeta

schemanske 12 comments Joined 02/10
11 Dec 2013

Unity Loader requires Unity Director.  For this reason, all Unity Loader documentation is in the Unity Director User Guide.  Here is the link: 
http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=Director-Loader14.00&rdsort=Title&srtord=Asc&nm=Unity+Director+14.00

geethareddy 93 comments Joined 10/11
11 Dec 2013

Thanks for confirming.

Thanks,
Geeta

geethareddy 93 comments Joined 10/11
12 Dec 2013

Jeff,
Need your help again on couple of more questions..
Q1) Regarding Recovery Log File, when it is set to TRUE, i does not result in sparse file. What exactly sparse file means?

Q2)Our HA status is "In Peer" with one sequencer being in "Active" and another sequencer is in "Standby Synchronized". But what is the exact difference between below 3 different status details. I found the description is almost same for those 3.
a) Not in Peer: Indicates the Unity Director servers are paired, but the Sequencer process cannot fail over. Administrator intervention is required to resolve the issue.
b) Establishing Peer: Indicates the Unity Director servers are paired, but the Sequencer process cannot fail over. Administrator intervention is required to resolve the issue.
c) Split Brain: Indicates the Unity Director servers are paired, but the Sequencer process cannot fail over. Administrator intervention is required to resolve the issue.
Q3) For the "Performance Metrics" is there any option to "export" the graph details (something like metric graph in viewpoint where we can export the details and analyze in xl graph too).

Q4) I heard that, Unity Director does not currently integrate with TASM rules, and can encounter issues when some TASM rules are in use. Is this limitation lifted in upcoming versions?
And for ex: Assume on a prodcution box, there is a TPT utility throttle rule on utility sessions which allows only 20 sessions at a time and delays the 21st one for the batch jobs. In this case, assume there are almost 19 utility sessions are in use for the batch loads, only 1 is left over. And at the same time, if there is a Unity synchronization going on via TPTLOAD opertor (which need may be 2 or 3 tptload utility sessoins) to sync some data, in that case do we experiecne an impact on Database sessoins side for the batch job OR unity will wait and do not process (sync) any data until those 19 utility sessions are freed up?

And from Paul Lapointe's article i read that "During recovery, Unity Director will also attempt to open as many sessions as possible on a Teradata system. This may result in the number of TASM sessions being exceeded during recovery."
Can you please clarify what does that mean by recovery, is that Unity recovery? and why it happens. I want to unerstand this becuase we should be prepare to tweak the TASM rules temporarily to faciliate the recovery.
Thank you in advance,
Geeta.

Thanks,
Geeta

schemanske 12 comments Joined 02/10
13 Dec 2013

Geeta - Please work with your local Solution Architect or PS consultant to get these questions answered.  They will be happy to work with you directly to get any questions/concerns addressed.  You Soultion Architect will be able to engage the correct resources to support the discussion.  Thanks.  

geethareddy 93 comments Joined 10/11
13 Dec 2013

I posted these before we had him available. Thank you Jeff.
 

Thanks,
Geeta

You must sign in to leave a comment.