Creating Repo (Repository)

This topic explains the concept of the repository and provides detailed steps on how to create it. The repository is a server instance of your data source. It provides space or location to store metadata.

Here is the step-by-step process for creating a metadata repository.

Log in to your Impetus LeapLogic Catalog.
From the left navigation pane, select Metadata Catalog > Catalog.

Click Asset Onboarding (+) on the Metadata Catalog page.
Select Repository to create a repository (server instance). The Repository page opens, where you can create a repository to connect and catalog metadata from your data source.

In Repository Name, enter a preferred name for the repository.
In Database Type, select the required data warehouse or database.
In Type, select the required database type and provide the required connection details.

The Input column in the table below provides the input requirements based on the category type selection.

Category	Types	Input
Cloud Platform	Athena	Nil
	Aurora PostgreSQL	Host Address: Provide the host address Port Number: Provide the port number. Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required connection details. Database Name: Provide the name of the database you want to connect to. Username: Provide username. Password: Provide a password. Test Connection: Click Test Connection to verify that the connection is established successfully.
	AWS Glue	Add Data Source: Enable this option to add a new data source connection and enter the required connection details. Database Name: Enter the name of the database you want to connect to. IAM Role: Enter the IAM role that grants the required permissions to access AWS resources. Region: Specify the region where your AWS resources (bucket or data source) are located. Bucket Name: Provide the S3 bucket name where the data or files are stored. Temp Directory: Provide the temporary directory path used during data processing operations. Access Id: Enter the AWS Access ID used for authentication. Secret Key: Enter the AWS Secret Key associated with your Access ID for authentication. AWS Account Id: Specify the AWS account ID associated with the data source. AWS MFA User: Specify the AWS MFA (Multi‑Factor Authentication) username used for secure access. SCP Policy: Enable this option if a Service Control Policy (SCP) must be applied during access. Test Connection: Click Test Connection to verify that the connection is established successfully.
	Azure SQL	JDBC URL: Provide the JDBC connection URL to identify the database and to connect to it. Add Data Source: Enable this option to add a new data source connection and enter the required connection details. Database Name: Enter the name of the database you want to connect to. Username: Provide the username. Password: Enter the corresponding password. Test Connection: Click Test Connection to verify that the connection is established successfully.
	Azure Synapse
	Cloud SQL for Postgres	Public IP: Provide the public IP address. Instance Name: Provide the instance name. Authentication Key File: Provide the authentication key file (JSON file format).
	Databricks Lakehouse	Host Address: Provide host address to connect the server instance. Port Number: Provide the port number such as 443. Cluster Name: Specify the cluster name. JDBC URL: Provide the connection URL to identify the database and to connect to it, for example, jdbc:spark://<address>;<transportMode>;<httpPath>;<Authentication Mechanism>;<UID>; <Password>. Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required connection details. Unity Catalog: Enable the Unity Catalog toggle to fetch metadata details from the Databricks Unity Catalog. Database Name: Enter the name of the database you want to connect to. Catalog Name: Provide the name of the Unity Catalog in your Databricks workspace. Workspace Name: Provide the name of your Databricks workspace. Cluster ID: Enter the cluster ID. Access Token: Provide the Databricks access token associated with your workspace. Test Connection: Click Test Connection to verify that the connection is established successfully.
	Databricks
	Databricks Lakebase	Host Address: Provide host address to connect the server instance. Port Number: Provide the port number. Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required connection details. Database Name: Provide the name of the database you want to connect to. Username: Provide username. Password: Provide a password. Test Connection: Click Test Connection to verify that the connection is established successfully.
	DBT Cloud	Access Url: Provide the DBT cloud access URL. Personal Token: Provide the DBT cloud access token. Account Id: Specify the account ID. Project Id: Specify the unique identifier of the project.
	Fivetran	Provide API key and API Secret key.
	Google BigQuery	Project ID: Specify the unique identifier for a project in GCP account. Authentication Email Address: Provide a valid email id that is used for authentication. Authentication Key Files: Upload the .json file that contains the authentication credentials. Add Data Source: Enable this option to add a new data source connection and enter the required connection details. Database Name: Enter the name of the database you want to connect to. Test Connection: Click Test Connection to verify that the connection is established successfully.
	Hive	Variant: Provide the Hive variant such as EMR Hive, Azure HDInsight. Hive version: Provide Hive version such as 1.1.x, 1,2.x, 2.1.x, 3.x. Metastore URL: Provides the URL of the remote server from which metadata is obtained. For example, thrift://impetus-dsrv13.impetus.co.in:9083. JDBC URL: Provide the JDBC URL to identify the database and to connect to it. Edge Node Host: Provide edge node host address for communication with other nodes in the cluster. Edge Node Port: Provide edge node port number. Edge Node Username: Provide edge node username. Edge Node Password: Provide edge node password. Authentication: Choose the authentication method as Credential or Key Authentication: Upload the authentication key file (PEM file format). Authentication type: Choose the authentication type: Kerberos: It is a network authentication protocol. Non-Kerberos: Authentication protocol type other than Kerberos.
	Redshift	Host Address: Provide the host address. Port Number: Provide the port number. Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required connection details. Database Name: Provide the name of the database you want to connect to. Username: Provide username. Password: Provide a password. Test Connection: Click Test Connection to verify that the connection is established successfully.
	Snowflake	Host Address: Provide the host address. Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required connection details. Warehouse Name: Provide the warehouse name. Database Name: Provide the name of the database you want to connect to. Username: Provide username. Password: Provide a password. Test Connection: Click Test Connection to verify that the connection is established successfully.
	Spark	Distro Version: Specify the distro version such as CDH-7. Spark JDBC URL: Provide the Spark JDBC connection URL. Edge Node Host: Provide edge node host address for communication with other nodes in the cluster. Edge Node Port: Provide edge node port number. Edge Node Username: Provide edge node username. Edge Node Password: Provide edge node port password. Authentication Type: Choose the authentication type: Kerberos: It is a network authentication protocol. Non-Kerberos: Authentication protocol type other than Kerberos.
Data Definition	Greenplum	DDL files: Upload the DDL files. Schema name: Provide the required schema name otherwise the default schema name is used. By default, all the tables are created in the ‘Default schema’.
	Netezza
	Oracle
	Redshift
	SQL Server
	Snowflake
	Teradata
	Vertica
EDW	Greenplum	Host Address: Provide the host address Port Number: Provide the port number. Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required connection details. Database Name: Provide the name of the database you want to connect to. Username: Provide username. Password: Provide a password. Test Connection: Click Test Connection to verify that the connection is established successfully.
	Netezza
	Oracle
	PostgreSQL
	Teradata
	Vertica
	SQL Server	Host Address: Provide the host address Port Number: Provide the port number. JDBC URL: Provide the connection URL to identify the database and to connect to it. Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required connection details. Database Name: Provide the name of the database you want to connect to. Username: Provide username. Password: Provide a password. Test Connection: Click Test Connection to verify that the connection is established successfully.
	SAP HANA	Host Address: Provide the host address. Port Number: Provide the port number.
	Others
ETL	ADF	Azure Subscription ID: Provide the ID of your Azure subscription. Client ID: Provide the client application ID used to authenticate access to Azure. Client Secret: Provide the client secret key for the application. Tenant ID: Provide the ID of your Azure Active Directory tenant.
ETL	AWS Glue ETL	Nil
File System	Amazon S3	Add Data Source: Enable the Add Data Source toggle to add a database connection and enter the required details. Access ID: Enter the Amazon S3 Access ID for authentication. Secret Key: Enter the Amazon S3 Secret Key associated with the Access ID. Region: Specify the region where the Amazon S3 bucket or data source is located. Test Connection: Click Test Connection to verify the connection.
	Azure Data Lake Storage	Version: Choose the required Azure Data Lake Storage version. Add Data Source: Enable the Add Data Source toggle to add a connection and enter the required details. Account Name: Enter the name of the Azure storage account. SAS Token: Enter the SAS token used to access the storage account. Storage Account Access Key: Enter the storage account access key. Connection Info: Specify the connection details required to access the data source.
	DBFS	API Version: Provide the API version such as 2.0. Instance Name: Prove the instance name.
	File Transfer Protocol	Host Address: Provide the host address. Port Number: Provide the port number.
	Secured File Transfer Protocol
	Unix File System	Host Address: Specify the Host Address as "localhost" if the files reside on the local machine, else, provide the IP address. Port Number: Provide the port number.
	Google Cloud Storage	Authentication Key File: Provide the Google Cloud service account key file used for authentication. Add Data Source: Enable the Add Data Source toggle to add database connection and enter the required details. HMAC Access ID: Enter the HMAC Access ID for authentication. HMAC Secret Key: Enter the HMAC Secret Key associated with the HMAC Access ID. Test Connection: Click Test Connection to verify that the connection is established successfully.
	HDFS	URI: Provide the URI of the data source. Auth Type: Choose the authentication type: Kerberos: Select if Kerberos authentication is required. Non-Kerberos: Select if Kerberos authentication is not used.
Business Intelligence	Power BI	Nil
	Amazon QuickSight
	Looker
Version Control System	Github	Nil
Version Control System	Gitlab	Nil

If the selected Type is Teradata, in Host Address enter the host address of the Teradata server instance you want to connect to.
In Port Number, enter the port number of the Teradata server instance.
Enable the Add Data Source option to add a database connection and enter the required connection details

In Database Name, enter the name of the database you want to connect to.
In Username, provide the username used to authenticate with the Teradata server.
In Password, enter the corresponding password for the Teradata username.
Click Test Connection to verify that the connection is established successfully.
In Architecture Type, enable Is Medallion to generate the Medallion architecture, and enable Is Datamesh to generate the Datamesh architecture.
In Industry, select the required domain (for example, Banking, Finance, Sales, etc).
Enable Sync Scheduling to configure automated synchronization schedules to keep metadata and data assets continuously up to date.
In Schedule Type, select the required schedule type such as Basic or Cron Expression.
If the selected Schedule Type is Basic, follow these steps:

In Frequency, select how often to synchronize the metadata and data assets (for example, Daily, Weekly, Monthly, or Custom).
In Start Date, specify the start date for synchronization.
In Start Time, specify the synchronization start time.
In End Date, specify the end date for synchronization.
In Timezone, select the appropriate time zone.

If the selected Schedule Type is Cron Expression, in the Cron Expression field, enter the cron expression. The format is Seconds Minutes Hours Day-of-month Month Day-of-Week Year, all separated by a space.

In Repository Context, provide repository-specific context to help AI understand lineage, classify assets, and interpret transformation logic. For example: This repository supports claims and customer analytics. Business-critical entities include Customer, Policy, Claim, Provider, and Payment. Use claim_id, policy_id, and customer_id as primary relationship keys. Prioritize lineage resolution across curated, reporting, and ML feature datasets.

In Tags, enter a tag with at least three characters and press Enter to add it (optional).

In Email , provide your e-mail address to receive system-generated repository updates such as editing tags, deleting the repository, changing the repository name, etc.

Click Save (top-right corner) on the Repository page to create a repository. After the Repository is created successfully, a snackbar pop-up appears.

Click Yes to add or associate a data source with the repository.
Click No to skip this step.

To add data source to the created repository, visit Creating Data Source.