Teradata Data Warehousing
XTIVIA has a long-standing partnership with Teradata and deep expertise building Teradata Data Warehousing solutions.
Teradata and XTIVIA - Your Data Warehousing Solution
Solutions Architecture & Development
- Teradata Physical Data Modeling
- Implement domain specific models
- Semantic Data Modeling
- Reporting and Analytics Implementation
- ETL/ELT design and development using Teradata Utilities, SQL, Procedures, Functions
- Application Maintenance
- Database Design
- Application Performance Tuning
- Teradata Managed Services
Our approach specific to Teradata Data Warehouse implementations is to take maximum advantage of Teradata parallel architecture and its performance features. Our experienced Teradata professionals work closely with end users and IT counterparts in understanding the current and future reporting, data storage, data movement, security and quality requirements in designing an optimal physical and semantic data model.
We closely work with clients to understand data integration requirements and SLAs in choosing appropriate Teradata load/unload utility (or appropriate Teradata Parallel Transporter operator) for the ETL / ELT. We implement ELT fully utilizing Teradata MPP architecture for relaxed data latency requirements (batch data warehouse updates) where the Data Warehouse is queried only after completely loading the data. For ADW needs, we implement an architecture that best suites the mixed workload requirements (real-time integration, adhoc, tactical queries, batch, analytics).
XTIVIA starts the design with a holistic and clean slate approach by fully understanding the pain points of the users and assessing the “data readiness”. Our architecture depends on the current state of data quality, data source location, estimated data volumes, application logic, performance, availability, data granularity, data storage, data archival and data consumption requirements. XTIVIA works with customers in coming up the success criteria and develops KPIs to validate the success during the course of implementation.
XTIVIA Accelerators and Frameworks
XDM (XTIVIA Data Warehouse Migrator)
Using our experience in the Teradata Data Warehousing and Business Intelligence industry, we have built a wizard based accelerator XDM (XTIVIA Data Warehouse Migrator) that can be used to speed up the Data Warehouse Migration to Teradata with minimal cost. Speeding up the migration process helps organizations realize the benefits of capital investment made in procuring Teradata appliance.
Please visit The XTIVIA Data Warehouse Migrator Innovation for more information.
XTIVIA Teradata DBA Tools
.NET Framework Flexibility
The flexibility of the .NET Framework makes it the platform of choice for many XTIVIA clients.
It allows for rapid development of robust applications that run on the desktop, web and enterprise level. XTIVIA’s team of .NET experts have the knowledge and experience to address any design, programming, and maintenance challenge with .NET applications.
.NET Framework 2.0 to 4.5, WPF, WCF, ASP.NET, MVC, VB.NET, C#
Over the past 15 years, XTIVIA has worked with a wide variety of ERP, CRM, business automation, production management, accounting and financial and legacy systems. We are experts in streamlining, integrating and modernizing systems. We offer solutions that not only enhance, update and replace existing systems—but also provide synergy within the enterprise to ensure a quick return on your investment.
XTIVIA has successfully developed and maintained a variety of solutions for our clients using .NET technology. Here are some highlights which demonstrate our industry knowledge, flexibility and solution offerings:
Introduction to some new features (Teradata v 15.0, v 15.10)
Teradata JSON Support (v 15.0): Teradata added JSON support from v15.0 allowing the storage and processing of JSON objects in Teradata database. This allows schemaless reading and processing of semi-structured data. We can also publish the results of SQL queries in JSON format.
Teradata Directory Manager (v 15.0): Teradata provides a GUI tool TDM (Teradata Directory Manager) allowing easy mapping of Teradata objects to LDAP directory users. To use TDM, one needs to have a dedicated directory exclusively to be used by Teradata database. This reduces the impact on enterprise LDAP. TDM is available for free and supports all Teradata versions that can use Teradata 14 JDBC drivers.
Auto Provisioning (v 15.10): Effective v15.10, a database user is automatically created for external users (directory users not mapped to Teradata database user) upon their first login. In previous releases, a generic Teradata pseudo-user EXTUSER was used to identify external users which means individual user activity could not be logged and tracked. EXTUSER could not own database objects. With the Auto Provisioning feature, authentic LDAP users get quick database logon without Administrator’s intervention. This feature is turned off by default and it can be turned on by setting the DBSControl AutoProvision field to true.
Intelligent Memory Improvements (v 15.10): Teradata Intelligent Memory (optional feature) was introduced from v 14.10 and it helps automatically keep the hottest data in memory (VERYHOT cache) for faster data processing improving Operational Intelligence and tactical query workloads. This requires enough RAM on the node to support very large FSG cache. Changes to VERYHOT cache required tpareset but from v 15.10, DBA can adjust the FSG dedicated to VERYHOT cache without needing tpareset.
Partition-Level Locking (v 15.10): In earlier versions when DML operations were run on multiple rows within partitions of row-partitioned table, the lock is escalated to table level though the rows are being processed from fewer partitions. But now, Teradata locks only required partitions reducing the lock contention and improving concurrency.
Teradata Secure Zones (v 15.10): This optional feature allows organizations to create “zones” or partitions for separate (and may be unrelated) divisions on a single Teradata database. Users needing to access database objects within a particular “secure zone” need to have required access and privileges. Typical use cases include multi-tenant database services, regulatory compliance, large conglomerates needing access and control on multiple databases owned by unrelated subsidiaries.
New PI on Access Rights Table (v 15.10): Earlier versions of Teradata used to place table-level write lock on DBC.AccessRights table causing blocks and deadlocks when dropping and deleting objects. From v 15.10, Teradata has changed index (row partitioning) on the DBC.AccessRights table to reduce lock contention by placing partition-level or row-key level locks leading to improved performance on dropping and deleting objects.
No obligation, no pressure. We're easy to talk with and you might be surprised at how much you can learn about your project by speaking with our experts.
XTIVIA CORPORATE OFFICE
304 South 8th Street, Suite 201
Colorado Springs, CO 80905 USA
Additional offices in New York, New Jersey,
Missouri, Texas, and Hyderabad, India.
USA toll free: 888-685-3101, ext. 2
International: +1 719-685-3100, ext. 2
Fax: +1 719-685-3400
Complete the form to hear from us.