How to load data from MySQL to Teradata

Begin by exporting the data from your MySQL database to a CSV file. Use the `SELECT INTO OUTFILE` command for this purpose. For example:
```sql
SELECT * FROM your_table
INTO OUTFILE '/path/to/your_file.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';
```
This command saves your MySQL table data into a CSV file with comma-separated values.

Transfer the CSV file from your MySQL server to the Teradata server. This can be done using secure copy protocols like SCP or SFTP. For example:
```bash
scp /path/to/your_file.csv user@teradata-server:/path/to/destination/
```
Ensure you have the necessary access rights to perform this operation.

Before importing the data, create a table in Teradata that matches the structure of your MySQL data. Use the `CREATE TABLE` statement:
```sql
CREATE TABLE your_teradata_table (
column1 DATA_TYPE,
column2 DATA_TYPE,
...
);
```
Ensure that data types are compatible between MySQL and Teradata.

Prepare the Teradata environment by setting any session parameters that might be necessary for the import process, like date formats or character sets, using:
```sql
SET SESSION DATEFORM=...
```
Adjust these settings based on your data's specific needs.

Use Teradata’s Basic Teradata Query (BTEQ) tool to import the CSV data. Write a BTEQ script to read the CSV file and insert it into the target table:
```sql
.IMPORT INFILE '/path/to/destination/your_file.csv'
.SET RECORDMODE OFF
.SET FORMAT FASTLOAD
.LOGON your_teradata_server/username,password
.BEGIN IMPORT MLOAD TABLES your_teradata_table
.LAYOUT mylayout
.FIELD column1 * VARCHAR(100)
.FIELD column2 * INTEGER
...
;
.DML LABEL insert_label
INSERT INTO your_teradata_table VALUES (:column1, :column2, ...);
.END MLOAD;
.LOGOFF;
```
Run this script in the BTEQ environment to execute the data import.

Once the import process is complete, verify that the data in Teradata matches the original data in MySQL. Perform checks by running SELECT queries on both databases and comparing row counts and sample data.

After verification, clean up any temporary files or scripts used during the transfer. Optimize the Teradata table by collecting statistics using:
```sql
COLLECT STATISTICS ON your_teradata_table;
```
This step ensures efficient query performance on the newly imported data.
By following these steps, you can successfully transfer data from MySQL to Teradata without the need for third-party connectors or integrations.