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.
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.
To connect to Confluence, perform the following steps:
- Enter your Confluence site URL in the Site box, which you can find in your Jira account profile.
- Click Sign In with Confluence.
Enter your Confluence credentials and click Log in.
Select the site to connect and click Accept.
- Save the connection
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.
Skyvia supports the following DML operations for the Confluence objects:
|INSERT, DELETE||ContentLabel, Group|
|INSERT, UPDATE, DELETE||Content, ContentProperty, Space, SpaceProperty|
Skyvia supports all the common actions for Confluence Cloud.