# Differences with Talend Cloud Data Preparation

Talend Data Preparation in hybrid mode does not give you access to all cloud features.

The following table lists the behavior difference.

| Features | Cloud version | Hybrid mode |
| --- | --- | --- |
| Connections | The Connections tab lets you create<br>connections that you can reuse to create new datasets. | There is no Connections tab.<br><br>When you<br>create a remote dataset, stored in Salesforce or Amazon S3 for<br>example, you must enter your connection information each<br>time. |
| Excel files with multiple worksheets | The Auto-detect feature allows to pre-fill<br>the Format config. | There is no Auto-detect feature. |
| Preparation creation | You can create a preparation based on one of your existing datasets.<br><br>You can also create a preparation from your list of datasets using the<br>Talend Cloud Data Preparation button ![Data Preparation](https://help.qlik.com/talend/en-US/hybrid-installation-guide-linux/Resources/images/tdp-icon.png). | You can add a preparation based on a dataset imported on the fly. |
| Profile preferences | Editing the profile preferences from Talend Cloud takes effect immediately. | After you edited the profile preferences from Talend Cloud, reconnect to Talend Data Preparation for the change to take effect. |
| Row as header | You can define a row as header in the dataset properties when you<br>import the dataset. | You can define a row as header from the functions panel using the<br>Make as header function from the<br>Row tab. |

The following table lists the cloud features unavailable in hybrid mode.

| Features unavailable in hybrid mode | Details |
| --- | --- |
| Dataset provenance and destination | The Talend Cloud Data Preparation button ![Data Preparation](https://help.qlik.com/talend/en-US/hybrid-installation-guide-linux/Resources/images/tdp-icon.png) is displayed when you hover over a dataset and it is a shortcut to:<br><br><ul> <li>Create preparations.</li> <li>See all the preparations that have been created from the dataset, along                           with their creator. It gives you more insight on how your data is                           used.</li> </ul> |
| Direct import for local files | In the Datasets page, the Drop a<br>file or browse button lets you import local files. You<br>can drag and drop your file on the datasets page, or browse using the<br>explorer. |
| Extended native connectivity | A range of connection types is available natively in the<br>application. Create preparations on datasets from databases, file<br>systems, distributed systems, platforms, and more. |
| German | The interface of Talend Cloud Data Preparation is available in German. |
| Indicators in the dataset list | When you open your list of datasets, you have the following columns<br>and indicators:<br><br><ul> <li>The quality bar detailing the repartition of empty, valid, and                                    invalid records across the dataset. Hover over each color to                                    access the exact percentage and records number.</li> <li>The rating score on the dataset based on its quality and other                                    personal criteria. The rating score that you see in the dataset                                    list is an average of the scores applied by all the users who                                    have access to the dataset.</li> <li>The <span>Talend Trust Score™</span>, represented by the <img src="https://help.qlik.com/talend/en-US/hybrid-installation-guide-linux/Resources/images/tts-icon.png" alt="Shield"> icon, gives you an overall score of the quality and completeness                           of your dataset. It aggregates several indicators such as the quality, or                           the presence of a rating score or certification.</li> </ul> |
| Sharing | The sharing dialog lets you assign a role to other users when<br>sharing connections, datasets, or preparation folders with other users.<br>The Viewer, Editor, or Owner roles all come with different levels of<br>permissions on the actions that can be performed on shared<br>objects.<br><br>The role you have assigned someone can be updated<br>anytime. You can also remove yourself from the list of contributors<br>on a specific shared object. |

As you are installing on-premises versions of the applications, refer to the [Talend Data Preparation User Guide](https://help.qlik.com/talend/r/en-US/8.0/data-preparation-user-guide) to learn more about the capabilities.