# Data Management in DataHub - [Overview of Data In Toucan](/data-management-in-datahub/overview-of-data-in-toucan.md) - [New Data Execution System](/data-management-in-datahub/new-data-execution-system.md): This page explains how the new Data Execution system works - [Management of datasets stored under the new system](/data-management-in-datahub/new-data-execution-system/management-of-datasets-stored-under-the-new-system.md): How the new Data Execution System handles stored datasets - [Caching Architecture](/data-management-in-datahub/new-data-execution-system/caching-architecture.md) - [Datasources in Toucan](/data-management-in-datahub/datasources-in-toucan.md) - [Managing Connectors](/data-management-in-datahub/datasources-in-toucan/managing-connectors.md) - [Add a connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector.md) - [Generic Connectors](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/generic-connectors.md): How to configure REST API connectors and ODBC connectors in Toucan - [Setting up an HTTP API connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/generic-connectors/setting-up-an-http-api-connector.md) - [Setting up an ODBC Connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/generic-connectors/setting-up-an-odbc-connector.md) - [Database and data warehouse Connectors](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors.md): How to configure database and data warehouses in Toucan - [Add a PostgreSQL connection](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-postgresql-connector.md): How to configure a postgreSQL connection in Toucan. - [Add a Google Big Query connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-google-big-query-connector.md) - [Add a MySQL connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-mysql-connector.md) - [Add a Snowflake connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-snowflake-connector.md) - [Add a Microsoft SQL (MSSQL) Server connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-microsoft-sql-server-connector.md) - [Add an Azure SQL connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-an-azure-sql-connector.md): How to connect to an Azure SQL database. - [Add an AWS Athena connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-an-aws-athena-connector.md): How to connect to an AWS Athena account in Toucan - [Add a MongoDB connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-mongodb-connector.md): How to connect a MongoDB cluster in Toucan - [Add an AWS Redshift connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-an-aws-redshift-connector.md): How to connect an AWS Redshift in Toucan - [Add a Databricks connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-a-databricks-connector.md): How to connect a databricks cluster in Toucan - [Add a ElasticSearch connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-elasticsearch-connector.md): How to connect an elasticsearch cluster in Toucan - [Add a ClickHouse connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/database-and-data-warehouse-connectors/setting-up-a-clickhouse-connector.md) - [Online services connectors](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/online-services-connectors.md) - [Setting up a Sharepoint connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/online-services-connectors/setting-up-a-sharepoint-connector.md) - [Setting up a Google Sheets connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/online-services-connectors/setting-up-a-google-sheets-connector.md) - [Setting up an AWS S3 connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/online-services-connectors/setting-up-an-aws-s3-connector.md) - [Setting up a Salesforce connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/online-services-connectors/setting-up-a-salesforce-connector.md) - [Setting up a Hubspot connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/online-services-connectors/setting-up-a-hubspot-connector.md) - [Create a dataset from a connector](/data-management-in-datahub/datasources-in-toucan/managing-connectors/create-a-dataset-from-a-connector.md) - [Native SQL: SQL / Code mode and simple mode](/data-management-in-datahub/datasources-in-toucan/managing-connectors/create-a-dataset-from-a-connector/code-mode-and-single-mode.md): Only for connectors which support nativeSQL - [Managing file storages](/data-management-in-datahub/datasources-in-toucan/managing-remote-file-storages.md) - [Add a file storage](/data-management-in-datahub/datasources-in-toucan/managing-remote-file-storages/setting-up-a-file-storage.md) - [SFTP](/data-management-in-datahub/datasources-in-toucan/managing-remote-file-storages/setting-up-a-file-storage/sftp.md) - [Import a file from a storage](/data-management-in-datahub/datasources-in-toucan/managing-remote-file-storages/create-a-dataset-from-a-file.md) - [Managing Files](/data-management-in-datahub/datasources-in-toucan/managing-files.md) - [Adding, editing and deleting local files](/data-management-in-datahub/datasources-in-toucan/managing-files/adding-editing-and-deleting-local-files.md) - [Advanced file settings](/data-management-in-datahub/datasources-in-toucan/managing-files/using-advanced-file-settings.md) - [Adding and combining remote files in Toucan](/data-management-in-datahub/datasources-in-toucan/managing-files/using-advanced-file-settings/adding-and-combining-remote-files-in-toucan.md) - [Datasets in Toucan](/data-management-in-datahub/datasets-in-toucan.md) - [Stored and Live Datasets](/data-management-in-datahub/datasets-in-toucan/stored-and-live-datasets.md) - [Transform data with YouPrep](/data-management-in-datahub/datasets-in-toucan/preparing-data.md) - [Overview of YouPrep™](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm.md) - [Column header](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/column-header.md) - [Rename column](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/column-header/rename-column.md) - [Duplicate column](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/column-header/duplicate-column.md) - [Fill null values](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/column-header/fill-null-values.md) - [Replace values](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/column-header/replace-values.md) - [Sort values](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/column-header/sort-values.md) - [Convert columns data types](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/column-header/convert-columns-data-types.md) - [Add](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/add.md) - [Add text column](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/add/add-text-column.md) - [Add formula column](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/add/add-formula-column.md) - [Add conditional column](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/add/add-conditional-column.md) - [Filter](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/filter.md) - [Delete columns](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/filter/delete-columns.md) - [Keep columns](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/filter/keep-columns.md) - [Filter rows](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/filter/filter-rows.md) - [Top N rows](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/filter/top-n-rows.md) - [ArgMax](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/filter/argmax.md) - [ArgMin](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/filter/argmin.md) - [Aggregate](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/aggregate.md) - [Group by](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/aggregate/group-by.md) - [Add total rows](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/aggregate/add-total-rows.md) - [Hierarchical rollup](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/aggregate/hierarchical-rollup.md) - [Get unique groups/values](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/aggregate/get-unique-groups-values.md) - [Compute](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute.md) - [Compute evolution](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/compute-evolution.md) - [Cumulated sum](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/cumulated-sum.md) - [Percentage of total](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/percentage-of-total.md) - [Rank](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/rank.md) - [Moving average](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/moving-average.md) - [Compute statistics](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/compute-statistics.md) - [Absolute value](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/absolute-value.md) - [Text](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text.md) - [Concatenate](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/concatenate.md) - [Split column](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/split-column.md) - [Extract substring](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/extract-substring.md) - [To lowercase](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/to-lowercase.md) - [To uppercase](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/to-uppercase.md) - [Compare text columns](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/compare-text-columns.md) - [Trim spaces](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/trim-spaces.md) - [Replace text](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/text/replace-text.md) - [Date](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/date.md) - [Convert text to date](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/date/convert-text-to-date.md) - [Convert date to text](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/date/convert-date-to-text.md) - [Extract date information](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/date/extract-date-information.md) - [Add missing dates](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/date/add-missing-dates.md) - [Compute duration](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/date/compute-duration.md) - [Normalize date granularity](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/date/normalize-date-granularity.md) - [Reshape](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/reshape.md) - [Pivot](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/reshape/pivot.md): The Pivot step - [Unpivot](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/reshape/unpivot.md) - [Waterfall](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/reshape/waterfall.md) - [Combine](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/combine.md) - [Append datasets](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/combine/append-datasets.md) - [Join datasets](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/combine/join-datasets.md) - [Geo](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/geo.md): When you are building your dataset to create a dashboard, these step descriptions allow you to perform geographical data transformations and hierarchical structuring. These operations are particularly - [Geographic dissolve](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/geo/geographic-dissolve.md) - [Geographic hierarchy](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/geo/geographic-hierarchy.md) - [Geographic simplify](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/geo/geographic-simplify.md) - [Prepare geo data (with basemap)](/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/geo/prepare-geo-data-with-basemap.md) - [YouPrep™ Native SQL](/data-management-in-datahub/datasets-in-toucan/preparing-data/youprep-tm-native-sql.md) - [Hybrid pipeline](/data-management-in-datahub/datasets-in-toucan/preparing-data/hybrid-pipeline.md) - [Managing datasets](/data-management-in-datahub/datasets-in-toucan/managing-datasets.md) - [Create a new dataset from a dataset](/data-management-in-datahub/datasets-in-toucan/managing-datasets/creating-datasets.md) - [Edit, delete a dataset](/data-management-in-datahub/datasets-in-toucan/managing-datasets/editing-duplicating-and-deleting-a-dataset.md) - [Stored datasets](/data-management-in-datahub/datasets-in-toucan/managing-datasets/stored-datasets.md) - [Refresh stored datasets](/data-management-in-datahub/datasets-in-toucan/managing-datasets/stored-datasets/refreshing-and-publishing-datasets.md) - [Adding indexes to stored datasets](/data-management-in-datahub/datasets-in-toucan/managing-datasets/stored-datasets/adding-indexes-to-stored-datasets.md) - [Setting permissions on dataset](/data-management-in-datahub/datasets-in-toucan/setting-permissions-on-dataset.md) - [Maintaining Data](/data-management-in-datahub/datasets-in-toucan/maintaining-data.md) - [Tagging datasets](/data-management-in-datahub/datasets-in-toucan/maintaining-data/tagging-datasets.md) - [Identifying datasets dependencies](/data-management-in-datahub/datasets-in-toucan/maintaining-data/identifying-datasets-dependencies.md) - [Set validation rules](/data-management-in-datahub/datasets-in-toucan/maintaining-data/set-validation-rules.md) - [Data Lineage in Toucan](/data-management-in-datahub/data-lineage-in-toucan.md) - [Managing variables in Toucan](/data-management-in-datahub/managing-variables-in-toucan.md) - [Variables hub](/data-management-in-datahub/managing-variables-in-toucan/variables-hub.md): Learn how to manage variable in Toucan - [Use variables in YouPrep™](/data-management-in-datahub/managing-variables-in-toucan/use-variables-in-youprep-tm.md) - [Easy reference to variables](/data-management-in-datahub/managing-variables-in-toucan/easy-reference-to-variables.md) - [Using advanced data concepts](/data-management-in-datahub/using-advanced-data-concepts.md) - [Data personnalisation with user attributes](/data-management-in-datahub/using-advanced-data-concepts/data-personnalisation-with-user-attributes.md) - [Connector setup with a user attribute](/data-management-in-datahub/using-advanced-data-concepts/data-personnalisation-with-user-attributes/connector-setup-with-a-user-attribute.md) - [Database selection with a user attribute](/data-management-in-datahub/using-advanced-data-concepts/data-personnalisation-with-user-attributes/database-selection-with-a-user-attribute.md) - [YouPrep data filtering with a user attribute](/data-management-in-datahub/using-advanced-data-concepts/data-personnalisation-with-user-attributes/youprep-data-filtering-with-a-user-attribute.md) - [Filter data in SQL with a user attribute](/data-management-in-datahub/using-advanced-data-concepts/data-personnalisation-with-user-attributes/filter-data-in-sql-with-a-user-attribute.md) - [Advanced syntax for variables](/data-management-in-datahub/using-advanced-data-concepts/advanced-syntax-for-variables.md) - [Data cache](/data-management-in-datahub/using-advanced-data-concepts/data-cache.md)