Confluence Cloud

Confluence is Atlassian’s corporate knowledge management collaboration software (wiki), written in Java. Skyvia supports the cloud version of Confluence.

Data integration: Skyvia supports importing data to and from Confluence, exporting data from Confluence to CSV files, and replicating data from Confluence to relational databases.

Backup: Skyvia Backup does not support Confluence.

Query: Skyvia Query supports Confluence.

Establishing Connection

To create a connection, specify the site URL and log in with a Confluence account. Skyvia stores only the OAuth authentication token. Skyvia does not store your credentials.

Creating Connection

To connect to Confluence, perform the following steps:

Connection Editor window

  1. Enter your Confluence site URL in the Site box, which you can find in your Jira account profile.
  2. Click Sign In with Confluence.

  3. Enter your Confluence credentials and click Log in.

    Signing in to Confluence

  4. Select the site to connect and click Accept.

    Signing in to Confluence

  5. Save the connection

Connector Specifics

Object Peculiarities

Content

When updating records in the Content object, you must map the Version_Number field. The updated Version_Number value must be increased by one from the previous value. For example, when updating the current Version_Number = 3, the new Version_Number value must be 4.

There are several content body types: editor, view, wiki, plain, etc. To import text content to the Content object, you must map two fields for specific content type - -Value and -Representation. For example, you import the text of the “Editor” body type. In this case, you must map the text itself to the Body_Editor_Value column, and you map the content type value to the Body_Editor_Representation field.

ContentLabels and SpaceLabel

When importing data to the ContentLabels and SpaceLabel objects, the Id value is not displayed in the integration log.

ContentProperty and SpaceProperty

When performing the UPDATE operation against these objects, you need to map the value for the Version_Number field. This value must be equal to the current value of this field plus 1. For example, when updating the current Version_Number = 3, you must map the Version_Number field to 4.

Incremental Replication and Synchronization

Skyvia does not support Synchronization for Confluence since none of the objects has the UpdatedDate field. Skyvia supports Replication with Incremental Updates only for the Content object. Skyvia tracks only new records and doesn’t track the updated records since this object doesn’t have the UpdatedDate field.

DML Operations

Skyvia supports the following DML operations for the Confluence objects:

Operation Object
INSERT SpaceLabel
INSERT, DELETE ContentLabel, Group
INSERT, UPDATE, DELETE Content, ContentProperty, Space, SpaceProperty
DELETE SpaceWatchers, ContentVersion

Supported Actions

Skyvia supports all the common actions for Confluence Cloud.

On This Page