(647) 725-9460
Teradata Migration to BigQuery
For most of us, on-premise Teradata environments are not keeping up with our requirements, which is a big part of why cloud-hosted migration is on the rise. StackPros is happily tasked with moving large amounts of data and workloads from Teradata into cloud storage platforms, particularly Google Cloud.
When we ask our clients about why they are bravely looking at stepping out of their on-premise comfort zone, they tell us:
• Their hardware scaling is falling short
• It takes monumental energy to manage database servers, parameters, and software
• System consumption and load times cause continuous anxiety
• The mountain of money required to keep the lights on could be better used elsewhere.
Ultimately, the needs and expectations of organizations who operate Teradata environments have evolved much more quickly than the technology, and this gap is continuing to widen. To resolve the full set of issues identified above, performing a migration from Teradata to BigQuery has proven to be an extremely effective solution.
Ready to migrate? We'll show you how.
Why Google BigQuery:
• Serverless, highly scalable and low-cost
• Reduced environment management time, Google-unique features and capabilities
• Supports standard ANSI:2011 compliant SQL dialect, including free ODBC and JDBC drivers
• Data ingestion patterns can be simplified
• Built-in Machine Learning features executed directly through queries
• Streaming APIs enable Low Latency data access and Real-Time Analytics
• Flat-rate contracts available for customers migrating from Teradata
Why StackPros?
Recognized by Google as a SI partner for Data Analytics migrations, StackPros places significant focus on Big Data / Advanced Analytics / ML migrations from legacy computing environments, into Google Cloud specifically. We engage as flexible as Google Cloud, offering a number of engagement and support models to choose from. Our team is there to help you along every step of the way towards reaching your goal. Let us help you migrate with confidence.
Thinking about migrating? Let's discuss.
Our Approach
Guided Deployment
We will be right next to you to guide you through all aspects of the migration, from initial considerations to step-by-step instructions that cover the pre-migration, migration and post-migration process.
Skills & Knowledge Transfer
We will be right next to you to guide you through all aspects of the migration, from initial considerations and architecture through fully migrated workloads, taking a low-risk gradual/phased approach.
On-Going Support
We maintain the option of clients accessing support desk services for any duration following in-scope migration activities, to ensure extended operational excellence.
| Consideration | Teradata | BigQuery |
|---|---|---|
| Cost | Multi-year Subscription & Licence Fees | No licencing fees |
| Hardware Purchasing & Maintenance | On-Demand: Pay based on records queried | |
| Database Admins | Option for flat-rate pricing | |
| Data center costs | ||
| Storage | Dependent upon physical disk space, requires continuous hardware purchasing | Highly scalable up and down |
| Per-second billing based on storage used | ||
| Compute | Subject to job volume | Highly scalable, per-second billing |
| Hardware difficult to keep modern/fast | Mix of managed and unmanaged options | |
| Patching / Updating / Maintenance | Continuous time burden | Typically not necessary |
| Downtime and interruptions | ||
| Query Speed | Long query times | Serverless, not impacted by concurrent queries |
| Query failures | Very fast | |
| Misc. capacity limitations | ||
| Real-time Analytics | System slowness and batching does not support Real-time Analytics | BigQuery Streaming APIs enable Real-time Analytics with Structured Data |
| Employee Capabilities Required | SQL and Teradata SQL | Standard / Simple SQL |
| Teradata Database, database management systems | ||
| Teradata utilities that load and retrieve data |