---
title: "Create a JDBC schema ingestion"
method: POST
path: "/schemas/jdbc"
tags: ["JDBC Schema Ingestion"]
deprecated: true
---

# Create a JDBC schema ingestion

`POST /schemas/jdbc`

> **Deprecated.**

Create a schema from a JDBC data source. <br />This operation is deprecated and it will be removed the next major release

## Request body

- AddSchemaFromJdbcRequest — A request for ingesting a JDBC source.
  - `schemaName` string, required — The schema name
  - `jdbcDriverId` string, uuid, required — The UUID of the JdbcDriver to use to connect to a JDBC source for ingestion.
  - `properties` object, required — The properties that will be passed to the JDBC driver to connect to the source.
  - `user` string, required — The username for the connection. If the user is not requested, specify an empty String
  - `password` string[] — The password for the connection. It can be specified as array of char (more secure) or as a String
  - `jdbcConnectionString` string — The connection string that will be used instead of the one from the JdbcDriver.
  - `description` string — The description of the schema to be added.
  - `ownerId` string, uuid, required — The id of the user who will be assigned as the owner of the produced domain.
  - `storeCredentials` boolean — Specify if the credentials should be stored into the database.
  - `cronExpression` string — The cron expression to enable the automatic refresh. If not set, it will delete the cron job if one was present.<br />It requires storeCredential to be set to true.<br />The system supports both Unix Crontab format and Quartz cron format. However, Quartz crons are eventually transformed into Unix crons, during which any fields representing seconds or years are quietly discarded
  - `cronTimeZone` string — The cron time zone. If a cron expression is set, a time zone is mandatory.
  - `extractDataSample` boolean — Specify if sampleData should be extracted from the database.
  - `executeProfiling` boolean — Specify if profiling should be executed.
  - `detectAdvancedDataTypes` boolean — Specify if advanced data types should be detected.
  - `tablesToSkip` string[] — The list table names that shouldn't be ingested. The names can contain * wildcards toskip multiple tables with similar names.
  - `jobServer` string — Specify the jobserver id where to submit the ingestion.

## Response `200`

The Job which represents the ongoing schema ingestion

- Job
  - `id` string, uuid, required
  - `createdBy` string, uuid, required
  - `createdOn` string, date-time, required
  - `startDate` string, date-time, required
  - `endDate` string, date-time
  - `status` 'Waiting' | 'Running' | 'Completed' | 'Failed', required
  - `report` object

## Other responses

- `400` — Request is not valid.
- `401` — User lacks permission.

---

[API](https://skmtc.net/collibra/apis/collibra-data-governance-center-core-api.md) · [All operations](https://skmtc.net/collibra/apis/collibra-data-governance-center-core-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/collibra/collibra-data-governance-center-core-api/revisions/6d091bc86a33/schema)