Teradata Vantage Cloud
DLH.io documentation for Teradata Vantage Cloud
Teradata Vantage Cloud is the extensible Cloud Native solution for Cloud Data Warehousing with a focus on data, machine learning, and analytics capabilities for the moder era of data enablement. Vantage Cloud supports many cloud native integration capbilities and its database technology is capable of handling massive transactional and analytical workloads.
Setup Instructions
Follow the setup steps guide for configuring your Teradata Vantage Cloud connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.
Teradata Vantage Cloud Target User Permissions
As a DLH.io will perform loading of data into your Teradata Vantage Cloud instance, write permissions will be requiered to land data into the database in question. These are generic steps to create a user with write permissions to a database in said instance.
-
Create a User for DLH.io on Teradata Vantage Cloud
-
Connect to the Teradata Vantage Cloud database in question with your admin user in order to create a new user specific to replicating/loading your data
CREATE USER <new_username> AS PASSWORD = "tmp!password", PERM=1000000;
-
-
Create a New raw data landing zone Database
- An initial database must be specified in the connector setup to designate where the replicated data will land in your targeted instance.
- Using this or similar best practices logic your Vantage Cloud admin can use the admin user to create a database with generous disk space to support the source data that will be replicated to it, an example would be:
CREATE DATABASE DATALAKEHOUSE_RAW FROM "demo_user" AS PERMANENT=2000000000;
-
Grant the User Access to the Source Database
-
Note: The DLH.io user will need access to create multiple databases for temporary raw data replication. The user should be allowed this access to create new databases as needed.
-
Using a direct user GRANT or by creating a role, or other means, provide the new user created above with permissions to read from the source database, for example:
GRANT ALL ON <existing_source_database> TO <new_username>;
-
Issue Handling
If any issues occur with the authorization simply return to the sources page in DLH.io, edit the source details and click the Save & Test or Authorize Your Account or Re-Authorize Account button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.