Connecting to Slack

Slack is a cloud team collaboration service with a number of tools for online calls, file sharing, etc.

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

Backup: Skyvia Backup supports Slack backup.

Query: Skyvia Query supports Slack.

Slack-Specific Features and Limitations

Skyvia has the following limitations for Slack:

  • Skyvia does not support incremental updates when replicating Slack data.

  • Skyvia backup does not support restoring data to a number of Slack objects and comparing these objects between different backups. Only the following objects support restoring data, and not all operations are available for them:

    • Channels, Groups support the insert operation (restoring deleted records)
    • ChannelsPurposes, ChannelsTopics, GroupsTopics, GroupsPurposes support the update operation (restoring modified channel/group topics)
    • Files object supports only delete operation (deleting added files)
    • Comments object supports all operations.
  • Skyvia allows only creating new channels and groups via Channels and Groups object. It allows changing their topic and purpose, but it is done via separate objects: ChannelsPurposes, ChannelsTopics, GroupsTopics, GroupsPurposes.
  • Skyvia currently does not support the *_Replies objects. You still can get replies via the corresponding *History tables by analyzing the ThreadId field.
  • The ReactionsMessages_* objects (ReactionsMessages_Channels, ReactionsMessages_DirectMessages, ReactionsMessages_Groups, ReactionsMessages_MultipartyDirectMessages) don’t support replication with creating foreign keys. To replicate these objects to a database or data warehouse, clear the Create Foreign Keys check box in a replication package.
  • Not all objects support all the DML operations for data import:
    • Only the Comments object supports the upsert operation (as well as any other).
    • ChannelsHistory, GroupsHistory, DirectMessagesHistory, and MultipartyDirectMessagesHistory objects support insert, update, and delete operations, but don’t support upsert.
    • ReactionsMessages_Channels, ReactionsMessages_DirectMessages, ReactionsMessages_Groups, ReactionsMessages_MultipartyDirectMessages, ReactionsFiles, and ReactionsComments objects support insert and delete operations.
    • Channels and Groups objects support only the insert operation.
    • ChannelsPurposes, ChannelsTopics, GroupsTopics, GroupsPurposes objects support only the update operation.
    • Files object supports only the delete operation.

Slack Connections

When creating a Slack connection you simply log in with Slack. The OAuth authentication token is stored on the Skyvia server. Your Slack account login and password are not stored on the Skyvia server.

To create a Slack connection, perform the following steps:

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened pane, click Slack.
  4. In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.

    Connection Editor window

  5. Click Log In with Slack.
  6. In the opened window, enter your Slack workspace name and click the Continue button.

    Sign In window

  7. Enter your Slack credentials and click Sign in.

    Sign In window 2

  8. Skyvia will request permission to access Slack workspace. Click Allow to give permission.

    Allow Access window

  9. Wait until the necessary data are transmitted and then click Create Connection.