CircleCI
CircleCI is a cloud-based continuous integration and continuous delivery (CI/CD) platform that automates software builds, tests, and deployments triggered by changes in source repositories.
CircleCI integration replicates data using the CircleCI API v2.
Consulte la sección Esquema para ver una lista de objetos disponibles para replicación.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
To set up your CircleCI account, you need:
- A CircleCI account with read access to the projects and organizations whose data you want to replicate.
- A CircleCI Personal API Token. Project API tokens are not supported by the CircleCI v2 API and cannot be used with this connector.
- One or more project slugs in the form
vcs-type/org-name/repo-name(for example, gh/acme-org/web-app for a GitHub-hosted repository).
To create your API token:
- Log into your CircleCI account.
- Click your avatar in the lower-left corner and select User Settings.
- Select Personal API Tokens.
- Click Create New Token.
- Enter a descriptive name, for example QlikDataIntegration, and click Add API Token.
Copy and paste your API token into a secured file.
To identify your project slugs:
vcs-type—ghfor repositories hosted on GitHub, orbbfor repositories hosted on Bitbucket.org-name— the GitHub organization (or username) or Bitbucket workspace that owns the repository.repo-name— the repository name.
You can read the slug directly from a CircleCI pipeline URL. For example, the URL https://app.circleci.com/pipelines/github/acme-org/web-app/123 corresponds to the slug gh/acme-org/web-app.
To replicate from multiple projects in one connection, enter all slugs in the Project Slugs field separated by spaces, for example: gh/my-org/repo-one gh/my-org/repo-two.
Creating the connection
Para más información, vea Conectar con aplicaciones SaaS.
- Rellene las propiedades de conexión necesarias.
Proporcione un nombre para la conexión en Nombre de la conexión.
Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.
Haga clic en Crear.
| Setting | Description |
|---|---|
| Data gateway | Seleccione una Data Movement gateway si su caso de uso así lo requiere. Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna. Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Qlik Data Gateway - Data Movement. |
| Start Date | Indique la fecha, en el formato |
| Token | API token. |
| Project Slugs | Project slugs. |
Limitations and considerations
- Personal API Token only. CircleCI Project API tokens are not supported by the v2 API. The token must belong to a user who has read access to the projects and organizations being replicated. If the token owner loses access (for example, leaves the organization), syncs that depended on that access will return empty results or fail.
pipelines,workflows, andjobsare scoped to Project Slugs. Only the projects listed in the Project Slugs field are replicated for these three streams. Adding a project requires updating the field and re-saving the connection.- Organization-scoped streams replicate everything the token can see. The
collaborations,context,groups,project,pipeline_definition,schedule,trigger, anddeploystreams replicate data for every organization and project visible to the Personal API Token. To limit what these streams return, restrict the access of the underlying CircleCI user. workflowsis replicated per pipeline. The connector lists pipelines for each configured project, then issues one workflow request per pipeline. Projects with many historical pipelines produce many API calls for theworkflowsstream on the initial sync; subsequent syncs only fetch newer pipelines.jobsis replicated per workflow. Each workflow produces one or more job requests. Projects with many workflows per pipeline can produce a high API-call volume for thejobsstream.jobsuses Full Table replication even thoughpipelinesandworkflowsare incremental. A workflow's job list is fully refreshed on every sync because the CircleCI jobs API does not expose a replication key. As pipeline and workflow bookmarks advance, the set of workflows re-fetched shrinks, but each retained workflow is re-fetched in full.- Rate-limit responses (
HTTP 429) include aRetry-Afterheader; the connector waits for the specified duration before retrying, up to 6 attempts within a 60-second budget. Transient server errors (5xx) are retried with exponential backoff, up to 5 attempts. HTTP 404 Not Foundresponses for individual resources (for example, a deleted pipeline) are treated as empty responses and do not stop the sync. Authentication errors (401) and validation errors (400) are surfaced immediately and fail the sync.- Start Date is honored only on the initial sync of each stream. Once a stream has a bookmark in state, subsequent syncs resume from that bookmark; changing Start Date in the connection settings does not retroactively affect already-replicated data.
- Interrupted syncs resume per-project. The connector records a
currently_syncingmarker for the project or pipeline in progress when a sync is interrupted, so the next sync resumes from that point.
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
Depending on your destination, table and column names may not appear as they are outlined below.
collaborations
The collaborations table contains information about the organizations the Personal API Token's user belongs to.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
context
The context table contains information about contexts (shared environment variable sets) defined in the organizations visible to the token.
Replication Method | Full Table |
Primary Key | id organization_id |
| Useful links |
deploy
The deploy table contains deployment metadata for the organizations visible to the token.
Replication Method | CDC |
Primary Key | id organization_id |
Replication Key | updated_at |
| Useful links |
groups
The groups table contains information about groups defined in the organizations visible to the token.
Replication Method | Full Table |
Primary Key | id organization_id |
| Useful links |
jobs
The jobs table contains information about jobs from your CircleCI workflows. This is a child stream of workflows.
Replication Method | Full Table |
Primary Key | id _workflow_id |
| Useful links |
pipeline_definition
The pipeline_definition table contains pipeline definitions for the projects within organizations visible to the token.
Replication Method | Full Table |
Primary Key | id project_id organization_id |
| Useful links |
pipelines
The pipelines table contains information about pipelines from your CircleCI projects. The workflows and jobs streams are children of this stream.
Replication Method | CDC |
Primary Key | id |
Replication Key | updated_at |
| Useful links |
project
The project table contains project metadata for the organizations visible to the token.
Replication Method | Full Table |
Primary Key | id organization_id |
| Useful links |
schedule
The schedule table contains scheduled pipeline configurations for projects within organizations visible to the token.
Replication Method | CDC |
Primary Key | id project-slug |
Replication Key | updated-at |
| Useful links |
trigger
The trigger table contains pipeline trigger configurations for projects within organizations visible to the token.
Replication Method | Full Table |
Primary Key | id project_id pipeline_definition_id organization_id |
| Useful links |
workflows
The workflows table contains information about workflows from your CircleCI pipelines. This is a child stream of pipelines. The jobs stream is a child of this stream.
Replication Method | CDC |
Primary Key | id |
Replication Key | created_at |
| Useful links |