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.
Confluence-Specific Features and Limitations
Skyvia has the following limitations for Confluence:
In the Data Integration product, Confluence connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Confluence in your package.
Skyvia supports DML operations for the following Confluence objects:
- INSERT: SpaceLabel.
- INSERT, DELETE: ContentLabel, Group.
- INSERT, UPDATE, DELETE: Content, ContentProperty, Space, SpaceProperty.
- DELETE: SpaceWatchers, ContentVersion.
- 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. However, please note that since this object doesn’t have the UpdatedDate field, updated records and any changes made to them will not be applied when replicating with Incremental Updates. Only new records will be replicated.
When performing the UPDATE operation against the Content object, you need to provide the value for the Version_Number field. This value must be equal to the previous value of this field plus one.
When importing data to the Content object, the new content should be assigned to one of the Body*Value fields. There are several types of body: view, editor, wiki, plain, etc. For each type, there is the value and the representation field. You need to map both of the corresponding fields. For example, you can import the content into the Body_Editor_Value field and map the Body_Editor_Representation field to the constant string “Editor”.
- When importing data to the ContentLabels and SpaceLabel objects, the Id value is not returned.
When creating a Confluence connection, you need to enter Site and log in to Confluence via OAuth 2.0. The OAuth authentication token is stored on the Skyvia server. Your Confluence account login and password are not stored on the Skyvia server.
To create a Confluence connection, perform the following steps:
- Click +NEW in the top menu.
- Click Connection in the menu on the left to open the Select Connector page.
- In the opened page, click Confluence.
In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
- Paste your Confluence domain to the Site field, which you can find in your Jira account profile.
- Click Sign In with Confluence.
In the opened window, enter your Confluence credentials and click Log in.
After that, select the site to connect to and click Accept.
When the access token is generated, use the Test Connection button to make sure that the connection is successful and then click Create Connection.
Supported Actions and Actions Specifics
Jira connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.