Welcome to trocco!

Welcome to trocco!

trocco is an all-in-one managed data platform with a range of features essential for helping build your data analytics infrastructure.

This page details the process of completing a data transfer for first-time trocco users.

Three Steps to Data Transfer

Follow the three steps below to set up a data transfer.

1. Create a Connection Configuration

• Create a Connection Configuration for trocco to connect to your data source and destination connectors.
• Please refer to the pages under Connection Configurations, for the setup information on each connector.

2. Create an ETL Configuration

• Create an ETL Configuration to specify how trocco will transfer your data.
• Please refer to the pages under Data Sources and Data Destinations, for detailed information on each connector.

3. Execute an ETL Job

• Once the ETL Configuration has been created, execute the job.

Troubleshooting

If you have any problems while using trocco, please refer to the following pages.

Understanding Error Messages.

Please refer to our documentation on error messages.
This documentation details the causes and solutions for common error messages in trocco.

Understanding Feature Specifications and Other FAQ in trocco.

Please refer to the pages under Other General FAQ .
Here you can find details on troccos feature specifications and other frequently asked questions.

Steps After Transfer

In trocco you can do more than just transfer your data.
In addition, we offer multiple features required for running your data analytics infrastructure.
Here are some of the most commonly used features.

Data Mart

With the Data Mart feature you can transform and aggregate data by executing SQL queries on the data stored in your target data warehouse.
See Creating a Data Mart Configuration for information on how to set up a Data Mart Configuration.

Workflow

Using the Workflow feature, you can set dependencies (order of execution) between ETL Jobs and Data Mart Jobs, in the form of a DAG (directed acyclic graph).
When executing the Workflow, each job will be run in an intended sequence.
See Creating a Workflow for information on how to set up a Workflow.

Schedules

trocco comes with a scheduling feature that allows you to set the execution timing for ETL, Data Mart, and Workflow configurations.
With scheduling, jobs can be automatically executed at a predetermined time.
See Schedules for information on how to set up a schedule.