(888) 685-3101 ext. 2

Teradata Managed
Services

Teradata Solutions and Administration
to optimize your Teradata environment

Teradata Managed
Services

Teradata Solutions and Administration
to optimize your Teradata environment

Teradata Services & Solutions for Your Business

XTIVIA Teradata Managed Services offering combines our unmatched Teradata solutions and administration expertise, with over 15 years of database managed services experience, to give you operational advantage and cost effectiveness in your Teradata environment.

Our team members recognize and understand the benefits Teradata can bring to your organization. We incorporate an optimized model for administration and management, utilizing repeatable processes, best-in-class tools, rapid response call protocol and deep industry expertise.

Teradata Database Support

Your Teradata database is at the heart of your Teradata environment. Without the right expertise, your Teradata environment might not perform the way it could. XTIVIA has Teradata DBA experts on staff that can add value to, or augment to your existing staff, or provide off-hours support and managed services. We offer four Teradata service plans: Standard 8, Standard 12, Premium 24, & Flex, see the details here. Take a look at our Database Support plans and call us to schedule an evaluation of your environment and support needs.

What We Do

Performance & Capacity Management

w

Reporting & Communication

i

Change Management

g

Application Maintenance & Support

Data Warehouse Operations

Backup & Recovery

q

Event Alerts & Notifications

Security Administration

h

Documentation

Managed Services

XTIVIA Teradata Managed Services is a cost-effective solution for organizations seeking to optimize the availability and performance of their Teradata environment. We accomplish this through our defined service types, hours of coverage and SLAs.

Advanced Teradata data warehouse operations for every scale database
Growth analysis, Capacity forecasting and Multi-Value Compression, Commissioning and decommissioning of Teradata utilities, Scheduling of jobs/scripts, etc. Use Teradata tools such as TMSM, ViewPoint, TASM to manage workloads, monitor operations of all Teradata infrastructure from a single view. Partner with client to establish SOPs and processes related to Incident Management, Change Management. Closely monitor the SLAs and work with application teams in managing them. Collaborate with Application Teams, Database Administrators, Operating System Administrators and Teradata Support in software patching and upgrading.
Complete security administration on the Teradata database
Security administration aligned with the policies directed by the client’s security team, to manage access to Teradata Database and applications. Optionally use LDAP for authorization. Maintain access logs and conduct audits. Provide standards and best practices to application teams in providing role-based access, data masking, encryption, etc.
Performance and Capacity Management
Leverage Teradata’s performance features and use physical implementation best practices in database design and assist in performance optimization at the system level and application. These include, but not limited to, SQL Tuning, Space Management, Statistics Management, Columnar, Multi Value Compression, various Indexes, Locking Logger, DBQL, ResUsage, PDCR, DBS Control, etc. Capacity Management includes partnering with application teams and other infrastructure teams in proactively analyzing the system usage, data growth, usage growth, new applications, DBQL, ResUsage and other Teradata tools in planning the upgrades.
Events/Alerts and Notifications
Use ViewPoint alerts facility to notify the operations and application teams on SLAs, performance issues such as CPU Skew, I/O Skew, Spool Errors and failed application processes.
Change Management
Our Managed Services team acts as gatekeeper and as controller on managing any change related to Teradata infrastructure and applications, as needed. Collaborate with client teams in establishing a change control process and ensure all the changes (Application, Teradata Patches, and Teradata Upgrades) follow the process. Our team keeps application teams apprised of any outages, work with them to regression test the changes.
Service reporting related communication
We understand, communication is key in all successful delivery of any service. Our team proactively communicates with the different IT and business groups of the customer needing Teradata support. Examples include outages related to Teradata upgrades, disaster recovery, application changes, impacting a larger group of stakeholders, etc. Reporting includes daily, weekly and monthly reports related to system usage, health check reports, and production incident summary and other detailed reports.
Backup and Recovery
Use Teradata Arcmain, BAR and/or Unity to back up the required database objects or duplicate the entire database onto multiple systems to set-up disaster recovery. Restore database in the event of data loss or database crash.
Documentation of best practices, support tasks and business operations
A continuing exercise for the review and update of all documentation collateral with the learnings from different engagements.
Application Maintenance and Support
Our portfolio of Teradata Managed Services also includes Development and Maintenance of Teradata Applications including Application Architecture, Data Architecture, Physical Database Design, ETL, ELT, BI Reporting and Analytics. We use industry best practices and we leverage Teradata’s performance features in building end-to-end Data Management solutions on the Teradata platform. We build, test and deploy the code in production and provide ongoing support.

XTIVIA's UNIQUE APPROACH

We build solutions, plain and simple. We identify problems and solve them—for others—for you.
To understand your business needs, we have to understand your technology challenges.
At XTIVIA, the relationship is step one.

XTIVIA's UNIQUE APPROACH

We build solutions, plain and simple. We identify problems and solve them-for others-for you. To understand your business needs, we have to understand your technology challenges. At XTIVIA, the relationship is step one.

Data Warehousing Blog

Reporting Queries Best Practices and Mistakes to Avoid

Performance issues are one of the primary reason and organizations are unsatisfied with their existing reports. One of the primary reason of this performance issue could be caused by report queries. Here are some of the most important thing to consider when writing...

Efficient ETL Development via Biml and BimlScript

It’s been estimated that up to 60% of the effort in building a data warehouse can be spent in developing the ETL processes that are needed to copy data from source systems and transform it before loading it in to the data warehouse. Many of the ETL processes,...

Backup Strategies For Sql Server Data Warehouses

This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...

A Road Map Is Required for a Successful BI Program

What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data, and that data was clearly defined and understood by those who managed and used it.   Imagine business teams would...

Keep it in Memory, Don’t Forget

20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don't remember the HDD capacity – I believe it was around 120MB or so) from my infrastructure guy, I felt like I’m hero on the street advertising to everyone the great piece of...

Profiling Data with SSIS

SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the analysis in an XML file, which you can view using the Data Profile Viewer. Before we review how to use the Profile Task,...

SQL Server – How to Setup a Data Source in SSRS to MS Access, MS Excel, and CSV Files

Not all data will come from a SQL Server database when you are creating reports in SSRS. There will be times you will need to create a data source to .CSV files, Excel spreadsheets, and MS Access databases. Recently, I had a customer request setting up sample data...

Rerunning Jobs in Talend Open Studio

When running jobs which are dependent on external sources (dropping of a file in an ftp folder), it may be necessary to run a multiple times till the file is found and the job run for that day. One way to do this is to insert a row into a log table which will hold the...

SQL Server Reporting Service Memory Settings

While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running...

Oracle Looping Chain of Synonyms. ORA-01775

So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a minute to demonstrate how it works. ORA-01775: looping chain of synonyms - Basically means that you created a synonym...

Top 10 Things to Know Before Starting Statistical Analysis

1. There are two primary techniques used in today’s statistical world a. Descriptive techniques describe and summarize data b. Inferential techniques allow us to estimate and draw conclusions about populations from samples 2. Data can be formally categorized in three...

Versioning for Talend Open Studio

Talend Open Studio does (TOS) not have versioning like the Talend Integration Suite (TIS). In order to set up versioning for TOS we decided to use Tortoise SVN as the client & Slik SVN as the server. After installing Tortoise SVN & Slik SVN, close TOS if you have it...

Data Warehousing Blog

Jasper Reports Design Best Practice

Jasper Reports is a reporting application that is simple to use, install, manage, and deploy. Its versatility gives us an option to deploy it to a...

Reporting Queries Best Practices and Mistakes to Avoid

Performance issues are one of the primary reason and organizations are unsatisfied with their existing reports. One of the primary reason of this...

Efficient ETL Development via Biml and BimlScript

It’s been estimated that up to 60% of the effort in building a data warehouse can be spent in developing the ETL processes that are needed to copy...

Backup Strategies For Sql Server Data Warehouses

This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data...

A Road Map Is Required for a Successful BI Program

What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data,...

Keep it in Memory, Don’t Forget

20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don't remember the HDD capacity – I believe it was around 120MB...

Profiling Data with SSIS

SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the...

SQL Server – How to Setup a Data Source in SSRS to MS Access, MS Excel, and CSV Files

Not all data will come from a SQL Server database when you are creating reports in SSRS. There will be times you will need to create a data source...

Rerunning Jobs in Talend Open Studio

When running jobs which are dependent on external sources (dropping of a file in an ftp folder), it may be necessary to run a multiple times till...

SQL Server Reporting Service Memory Settings

While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration...

Oracle Looping Chain of Synonyms. ORA-01775

So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a...

Top 10 Things to Know Before Starting Statistical Analysis

1. There are two primary techniques used in today’s statistical world a. Descriptive techniques describe and summarize data b. Inferential...

Let's Talk Today!

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, Virginia, 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.
Share This