JDBC Schema Ingestion
Collibra REST API authentication using Basic Authentication.
A request for ingesting a JDBC source.
The schema name
The UUID of the JdbcDriver to use to connect to a JDBC source for ingestion.
The username for the connection. If the user is not requested, specify an empty String
The password for the connection. It can be specified as array of char (more secure) or as a String
The connection string that will be used instead of the one from the JdbcDriver.
The description of the schema to be added.
The id of the user who will be assigned as the owner of the produced domain.
Specify if the credentials should be stored into the database.
The cron expression to enable the automatic refresh. If not set, it will delete the cron job if one was present.
It requires storeCredential to be set to true.
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
The cron time zone. If a cron expression is set, a time zone is mandatory.
Specify if sampleData should be extracted from the database.
Specify if profiling should be executed.
Specify if advanced data types should be detected.
The list table names that shouldn't be ingested. The names can contain * wildcards toskip multiple tables with similar names.
Specify the jobserver id where to submit the ingestion.
The Job which represents the ongoing schema ingestion
Represents a job. Job is a single atomic task that is to be performed asynchronously
The id of the represented object (entity).
The id of the user that created this resource.
4d250cc5-e583-4640-9874-b93d82c7a6cbThe timestamp (in UTC time standard) of the creation of this resource.
1475503010320The id of the user who modified this resource the last time.
a073ff90-e7bc-4b35-ba90-c4d475f642feThe timestamp (in UTC time standard) of the last modification of this resource.
1476703764163Whether this is a system resource or not.
The type of the resource, e.g. [Community, Asset, Domain, Attribute, Relation, WorkflowInstance, ...]. This property is deprecated and will be removed in the future. In order to stay backwards compatible and to enable introduction of new types of resources, where necessary, a resource discriminator property (of type String) has been added to specific subtypes of Resource, e.g. assignedResourceDiscriminator on AssignedResource, or attributeDiscriminator on Attribute. For new types of resource that didn't exist before this change, the resourceType will be BaseDataType.
The name of the resource.
Test nameThe type of the job.
IMPORTThe ID of the user that initiated this job.
The visibility of the job.
The progress percentage of the job.
50Whether this job is cancelable or not. If set to false it will not be possible to cancel the job once submitted.
The start date of the job.
1488016800The end date of the job.
1488021800The state of the job.
COMPLETEDPossible values: The result of the job.
SUCCESSPossible values: The message of the job.
Import finished in 12s.Request is not valid.
User lacks permission.
Collibra REST API authentication using Basic Authentication.
A request for ingesting a JDBC source.
The schema ID of the schema asset to be refreshed
The UUID of the JdbcDriver to use to connect to a JDBC source for ingestion.
The username for the connection. If the user is not requested, specify an empty String
The password for the connection. It can be specified as array of char (more secure) or as a String
The connection string that will be used instead of the one from the JdbcDriver.
Specify if the credentials should be stored into the database.
If true, the password will be used to connect instead of the previously saved one.
The cron expression to enable the automatic refresh. If not set, it will delete the cron job if one was present
It requires storeCredential to be set to true.
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
The cron time zone. If a cron expression is set, a time zone is mandatory.
Specify if sampleData should be extracted from the database.
Specify if profiling should be executed.
Specify if advanced data types should be detected.
The list table names that shouldn't be ingested. The names can contain * wildcards toskip multiple tables with similar names.
Specify the jobserver id where to submit the ingestion.
The Job which represents the ongoing schema refresh
Represents a job. Job is a single atomic task that is to be performed asynchronously
The id of the represented object (entity).
The id of the user that created this resource.
4d250cc5-e583-4640-9874-b93d82c7a6cbThe timestamp (in UTC time standard) of the creation of this resource.
1475503010320The id of the user who modified this resource the last time.
a073ff90-e7bc-4b35-ba90-c4d475f642feThe timestamp (in UTC time standard) of the last modification of this resource.
1476703764163Whether this is a system resource or not.
The type of the resource, e.g. [Community, Asset, Domain, Attribute, Relation, WorkflowInstance, ...]. This property is deprecated and will be removed in the future. In order to stay backwards compatible and to enable introduction of new types of resources, where necessary, a resource discriminator property (of type String) has been added to specific subtypes of Resource, e.g. assignedResourceDiscriminator on AssignedResource, or attributeDiscriminator on Attribute. For new types of resource that didn't exist before this change, the resourceType will be BaseDataType.
The name of the resource.
Test nameThe type of the job.
IMPORTThe ID of the user that initiated this job.
The visibility of the job.
The progress percentage of the job.
50Whether this job is cancelable or not. If set to false it will not be possible to cancel the job once submitted.
The start date of the job.
1488016800The end date of the job.
1488021800The state of the job.
COMPLETEDPossible values: The result of the job.
SUCCESSPossible values: The message of the job.
Import finished in 12s.Request request is not valid.
User lacks permission.
Last updated
Was this helpful?