--- sourceDocument: Brazil Workflow Data Fabric sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications Release : - brazil ft:locale : - en-US ft:publication_title : - Brazil Workflow Data Fabric ft:clusterId : - crint bundleId : - crint workflow : - Creator --- # Create a Teradata metadata collector # Create a Teradata metadata collector {#ariaid-title1} Release version: Brazil Updated June 18, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 4 minutes to read Create a collector to import metadata from Teradata. ## Before you begin * All prerequisite tasks are complete. For more information, see [Prepare to run the Teradata Collector](https://www.servicenow.com/docs/vM68tROOb4QI_ucso3DAlg "Create a dedicated Teradata user with the permissions required for the metadata collector to harvest metadata from a target database."). * If you plan to run the collector on-premise, a MID Server is setup for the collector. For more information, see [MID Server for metadata collectors](https://www.servicenow.com/docs/2l_oawHD8jDgqUJN6Gaorw "When your source is behind a firewall or requires on-premises handling, deploy metadata collectors on a MID Server you host to harvest metadata from on-premises and privately networked data sources."). {#create-teradata-metadata-collector__ul_pvj_mz5_bjc} Role required: connection-admin or admin. ## Procedure 1. Navigate to AllWorkflow Data FabricWorkflow Data Fabric Home. 2. Select the Connect Hub ![Connect Hub icon]() icon in the left sidebar. 3. Select CreateMetadata collector. 4. From the System list, select Teradata. 5. From the Connection type list, select one of the following: 1. Select New connection to configure a new connection. 2. Select Existing connection to reuse an existing connection and select an existing connection from the Connections list. The configuration form is filled with details from the existing connection. The name is appended with the word Copy and sensitive details like password aren't copied. {#create-teradata-metadata-collector__substeps_lgh_q4y_jjc} 6. Complete the form. {#create-teradata-metadata-collector__table_gkm_wgs_qhc__entry__2} | Field | Description | |-|-| | Connection name | Unique identifier for the connection. This field can't be modified once the connection is established. | | Short description | Purpose and details of the connection. | [Table 1. Teradata metadata collector form] {#create-teradata-metadata-collector__table_gkm_wgs_qhc} 7. Configure the connection properties. {#create-teradata-metadata-collector__table_rx2_2zm_rjc__entry__2} | Field | Description | |-|-| | Server | Hostname of the database server to connect to. | | Server port | Port of the database server, if not the default. | | Use MID server | Option to connect to the source system through a MID Server. When selected, the MID selection options appear. | | MID selection | MID Server routing option for the collector job. This field appears only when Use MID server is selected. * Auto-Select MID Server --- The system selects an available MID Server at job execution time. Default selection. * Specific MID Server --- The collector job runs on the selected MID Server. If the MID Server is offline at job execution time, the job fails with an error identifying the MID Server by name. * Specific MID Cluster --- The collector job runs on any available MID Server within the selected cluster. | | MID Server | MID Server to use for the collector job. This field appears only when Specific MID Server is selected. The selected MID Server is saved on the collector record and used for all subsequent collection runs until changed. | | MID Cluster | MID cluster to use for the collector job. This field appears only when Specific MID Cluster is selected. The selected cluster is saved on the collector record; any available MID Server within the cluster may serve the job. | | Capabilities | One or more capability labels that restrict auto-selection to MID Servers advertising those capabilities. This field appears only when Auto-Select MID Server is selected. | | MID application | MID Server application to use for the collector job. This field appears only when Auto-Select MID Server is selected. | [Table 2. Connection options] {#create-teradata-metadata-collector__table_rx2_2zm_rjc} 8. Configure the authentication options. {#create-teradata-metadata-collector__table_x4t_1vt_rjc__entry__2} | | | |-|-| | User name | Username for authenticating with the database server. | | Password | Password for authenticating with the database server. | [Table 3. Authentication options] {#create-teradata-metadata-collector__table_x4t_1vt_rjc} 9. Configure the database options. {#create-teradata-metadata-collector__table_bwq_bvt_rjc__entry__2} | | | |-|-| | Include databases | Name of the database to connect to. To add multiple databases, select Add. Note: If this property is not specified, the collector harvests metadata from all databases. Use the optional Excluded databases parameter to exclude specific databases. | | Excluded databases | Regular expressions indicating databases not to catalog. Use when the Include databases parameter is not set --- the collector then harvests metadata from all databases, and this parameter excludes specific ones. Note: This parameter is ignored if the Include databases parameter is specified. To use Excluded databases, do not set the Database parameter. | [Table 4. Configuration options] {#create-teradata-metadata-collector__table_bwq_bvt_rjc} 10. Configure the advanced options. {#create-teradata-metadata-collector__table_lsp_cvt_rjc__entry__2} | | | |-|-| | Enable column statistics collection | Whether to enable harvesting of column statistics, that is, data profiling. Note: Enabling this feature may extend the running time of the collector because the collector requires access to table data to gather profiling metadata. | | Target sample size for column statistics | Target number of rows to sample from tables. | | Disable lineage collection | Whether to skip harvesting of intra-database lineage metadata. | | Disable extended metadata collection | Whether to skip harvesting of extended metadata for resource types such as database, schema, table, columns, functions, stored procedures, user-defined types, and synonyms. Basic metadata for these resource types is still harvested. | | Exclude system functions | Whether to exclude system functions. | | Server environment | Friendly name for the environment in which the database server runs. Use this field when the server name is localhost to differentiate it from other environments. | | Database ID | Unique identifier for this database, used to generate the ID for the database. Provide this value only if the database name used for the connection does not uniquely identify the database. | | JDBC properties | JDBC driver properties to pass to the driver connection, in `name=value` format. | | SQL parsing timeout | Timeout in seconds for SQL parsing during lineage collection. The default is 60. | [Table 5. Advanced options] {#create-teradata-metadata-collector__table_lsp_cvt_rjc} 11. Select Save. {#create-teradata-metadata-collector__steps_dvl_51n_rjc} ## Result The metadata collector is created and appears on the Connectors page with a Configured status. The collector is ready to connect to the source system and harvest metadata. ## What to do next After the collector is created, perform any of the following tasks: * Enable vault classification for columns harvested by the collector. This option is available only from the connection details of a saved collector. See [Enable Vault classification for a metadata collector](https://www.servicenow.com/docs/Bk1AMyugUG5eqdeiYkDM_Q "Enable a metadata collector to classify harvested columns using ServiceNow Vault."). * Run the collector manually to harvest metadata immediately. See [Run metadata collectors manually](https://www.servicenow.com/docs/aQKuJd5j3lCXk75ya17e~A "Execute a metadata collector on-demand to import metadata immediately."). * Automate metadata collection by scheduling regular collector runs. See [Schedule metadata collector runs](https://www.servicenow.com/docs/asZ0rH6fgXYHaoh9wK~UWw "Schedule a metadata collector to run automatically at a specified frequency."). * Monitor execution status and troubleshoot issues by viewing the runtime logs. See [View runtime logs for collector runs](https://www.servicenow.com/docs/k1TsyTx6kPU1XTWQB9VJdA "Access execution logs and download detailed log files for metadata collector runs."). * Discover and evaluate the harvested data assets in the Data Catalog. See [Governing the Data Catalog](https://www.servicenow.com/docs/0K_ULy_QruQwo4Xz2_VT8w "Data stewards add business context to catalog assets, making them more discoverable for catalog consumers. Governance tools include glossary terms, tags, domains, and direct asset updates."). {#create-teradata-metadata-collector__ul_fn2_jym_rjc} *[\>]: and then