Begin by exporting your desired data from TPLCentral. This can typically be done by accessing the export functionality through its user interface. Choose a standard format like CSV or JSON for the export, ensuring you select all necessary data fields and records.

Once you have the export file, examine the data to ensure it’s structured correctly. Clean the data by removing any unnecessary fields or records and check for consistency in data types. This is crucial for seamless importing into Firebolt later on.

Set up a secure method for transferring your data file to your environment where Firebolt can access it. This could involve using secure file transfer protocols like SFTP or SCP to move the file to a server that your Firebolt instance can access.

Log into your Firebolt account and access the Firebolt console. Ensure you have the necessary permissions to create tables and upload data. Familiarize yourself with Firebolt's SQL syntax and data ingestion capabilities.

Using the Firebolt console, create a new table that matches the structure of your data file. Define the appropriate schema, including column names and data types, to reflect the data you exported from TPLCentral. This ensures that data is imported correctly without errors.

Use Firebolt’s data ingestion SQL commands to load your data file into the new table. You might use commands such as `COPY` to specify the data file location and define the format (e.g., CSV). Ensure you handle any exceptions or errors during this process to ensure data integrity.

After the data is loaded into Firebolt, perform a series of checks to verify data integrity and consistency. Run queries to ensure all records are present and that the data matches the original dataset from TPLCentral. Address any discrepancies promptly to maintain data accuracy.

By following these steps, you can successfully move data from TPLCentral to Firebolt without relying on third-party connectors or integrations, ensuring a secure and efficient transfer process.