Spotlight provides the following pre-packaged services:
  • StartUp -   putting in place the initial environment and providing a starter analytics/reporting environment
  • SetUp -   ensuring best-practices are in place for your data management environment
  • SizeUp -   inspecting your data management environment
  • CheckUp -   monitoring your data warehouse environment for proper operation
  • TuneUp -   tuning your queries and overall data management environment
  • CleanUp -   providing database administrator services and clean up of the data management environment
  • MoveUp -   analyzing database and migration requirements when a different database technology is needed
  • MatchUp -   analyzing the various options for end-of-life platforms
  • StackUp -   providing a hardware/software alternative to end-of-life platforms
  • BuildUp -   developing native applications for a Teradata environment
  • LockUp -   providing column-based security and encryption
  • BackUp -   providing backup automation and alerting






 






Spotlight Technology offers a no-code "application builder/generator" that produces native applications for the Teradata environment - applications that take advantage of the power of Teradata.

The application builder uses multi-variate decision tables to express the logic of the application and the actions to be taken when certain business conditions are detected.

Once an application is defined and validated, the product produces code that runs on Teradata. The code can be executed once or scheduled to run on a recurring timetable.

Spotlight offers accompanying services to discern the business rules for an application and assist in its construction.

Download our brochure.

  BuildUp
Contact us to learn more.







 






Many businesses embark on a journey to build a data management program that allows their business to use its data to generate better outcomes.

Once systems and processes are in place, it's hard to take the time to step back from the collection of technologies to understand the overall health of the environment.

Too often, what started as an orderly approach and collection of systems decomposes as more tools, more data, more rules, more processes ... are added as business conditions change.

That's where Spotlight's SizeUp service can help. Spotlight consultants will perform a "health check" of your systems to determine whether improvements can be made and where.

Download our brochure.

  SizeUp
Contact us to learn more.







 






Often customers new to Teradata's unique capabilities need assistance to implement the Teradata database and its Business Intelligence/Analytic architecture.

The new options for Teradata on-and-off premise, software and hardware choices and new cloud implementations on AWS, Azure and Google give customers additional choices.

But, new customers may also need help with initial acquisition and setting up the Teradata ecosystem atop the massively-parallel database environment.

To the BI/Analytic user, and even the Database Administrator, Teradata looks to be a SQL platform similar to other database systems but able to process massive volumes of data much more quickly.

However, to achieve these capabilities there are several best-practices that, when implemented correctly, ensure Teradata's optimum operation and maintainability.

Spotlight Technology's StartUp Service is designed to get customers up and running...and up-to-speed quickly on Teradata's unique capabilities and optimum performance

Download our brochure.

  StartUp
Contact us to learn more.







 






Often customers new to Teradata's unique capabilities need assistance to implement the Teradata database and its Business Intelligence/Analytic architecture.

Having full-time database administrators (DBAs) on-staff can be an expensive proposition. Furthermore, many DBAs are not properly trained on the nuances of Teradata’s unique capabilities and how to take advantage of all its powerful features.

Spotlight SetUp services provide added DBA support for small-to-medium businesses who need extra DBA support and experience.

Download our brochure.

  SetUp
Contact us to learn more.







 






Understanding the behavior of your Teradata Data Warehouse can be a daunting task.
There are low-level tools like ResUsage and DBQL (Database Query log) and very high-level tools like Viewpoint but each of these capabilities has pro’s and con’s.

In the past, a range of home-grown approaches have been developed including: Excel-based reports and special queries shared by DBAs. Now, there’s a better answer!

Spotlight’s CheckUp™ product provides a user-friendly set of Tableau workbooks that provide in-depth analysis and insights of what’s going on inside your Teradata system.

Download our brochure.

  CheckUp
Contact us to learn more.







 






The Spotlight TuneUp service is a suite of products and services that are used to "refresh" an account.

Refreshing an account includes examining the current data warehouse infrastructure, performance, queries, and more. These elements are compared against best-practices to see if clean-up and corrections are needed.

After all, it’s important to use a proven approach to set-up the environment properly, understand best-practices, and derive value from the data warehouse/BI system.

The TuneUp Kit includes the following capabilities:
  • Phase 1 - evaluate the database environment and connections
  • Phase 2 - evaluate the data warehouse / BI environment
  • Phase 3 - evaluate the data loads and queries of your data
  • Phase 4 - investigate opportunities for more advanced analytics and visualizations
Download our brochure.

  TuneUp
Contact us to learn more.







 






Data Security is on everyone’s mind these days. Businesses of all sizes have experienced massive data breaches of their customer’s sensitive information, resulting in major legal issues and loss of customer trust…and business.

Most of the data breaches are from bad actors “hacking” the customer’s database to obtain the sensitive information stored inside.

Most data security systems today are very expensive and require multiple servers, networks and endpoints. Often, mid-tier business merely want to protect a modest number of data elements (e.g. Credit Cards) from unauthorized use.

Spotlight’s LockUp product and service provides an additional level of physical data encryption for columns of sensitive information – limiting access to designated users.

Download our brochure.

  LockUp
Contact us to learn more.







 






Spotlight provides auxiliary database administrator (DBA) services for businesses that need extra help tackling the myriad tasks of a DBA.

The tasks covered by the CleanUp™ service include:
  • database design and modeling
  • specific skills for a database (e.g., Microsoft SQL Server, Teradata , RedShift or Snowflake
  • managing storage usage
  • managing roles, privacy, permissions, and security
  • writing SQL statements (DDL, DML, DCL/DQL)
  • tuning and optimizing queries
  • maintaining the database, including backup/recovery
  • advising business users and developers on data-related topics
Download our brochure.

  CleanUp
Contact us to learn more.







 






Business conditions change rapidly and sometimes the database technology chosen as the foundation for data warehousing and analytics needs to change as well

Spotlight Technology provides a database analysis and migration service called MoveUp™ to help a business determine the best database technology.

The MoveUp™ service analyzes all aspects of the business' analytical infrastructure (as it pertains to the data warehouse) including ETL, ELT, analytics, queries, database features, performance, and visualization.

Download our brochure.

  MoveUp
Contact us to learn more.







 






Customers using Teradata Vantage on AWS can turn on backups but might not be regularly checking them for success. This can be an expensive mistake when backups are needed, only to find out that they have not been running (or continuously running and failing).

At times, customers do methodically review the progress of backups only to repeatedly discover errors that really aren't errors but still take time to diagnose. Spotlight BackUp™ addresses both possibilities with configurable automation.

Vantage includes an integrated backup capability, DSA (Data Streaming Architecture). It can perform full and incremental backups of the Vantage Advanced SQL Engine (the product previously referred to as Teradata Database). DSA on AWS requires a separate instance (called a virtual machine on Azure) and this instance performs the backups. Customers control DSA with a portlet in Viewpoint, the web-based management interface. Viewpoint has the ability to send alerts, but when it comes to backup jobs, customers are limited to the status of a job: completed or failed. However, if the job never runs, then there might not be any alert at all. Conversely, some errors are acceptable-such as a loading table that needs no backup-and can be safely ignored. And some errors aren't necessarily errors, like when a backup job runs long, but can cause a ripple effect with dependent schedules.

Download our brochure.

  BackUp
Contact us to learn more.