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:
oChannels, Groups - support the insert operation (restoring deleted records)
oChannelsPurposes, ChannelsTopics, GroupsTopics, GroupsPurposes - support the update operation (restoring modified channel/group topics)
oFiles - supports only delete operation (deleting added files)
oComments - support all operations.
Skyvia allows only creating new channels and groups via Channels and Groups object. It allows changing their topic and purpose, but this 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:
oOnly the Comments object supports the upsert operation (as well as any other).
oChannelsHistory, GroupsHistory, DirectMessagesHistory, and MultipartyDirectMessagesHistory objects support insert, update, and delete operations, but don't support upsert.
oReactionsMessages_Channels, ReactionsMessages_DirectMessages, ReactionsMessages_Groups, ReactionsMessages_MultipartyDirectMessages, ReactionsFiles, and ReactionsComments objects support insert and delete operations.
oChannels and Groups objects support only the insert operation.
oChannelsPurposes, ChannelsTopics, GroupsTopics, GroupsPurposes objects support only the update operation.
oFiles object support only the delete operation.

 

Slack Connections

When creating a Slack connection you simply log in with Slack, and 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.Open the Connections page by clicking Connections in the menu on the left side of the page.
2.Сlick the New button.
3.In the opened pane click Slack.
4.In the opened New Connection dialog box, specify a connection Name that will be used to identify the connection.
 
slack-connection-new
5.Click Log In with Slack.
6.In the opened window enter your Slack workspace name and click the Continue button.
 
slack-connection-login1_
7.Enter your Slack credentials and click Sign in.
 
slack-connection-login2
8.Slack will display the list of privileges, required for Skyvia. Scroll the page to the bottom and click Authorize.
9.Wait until the necessary data are transmitted, and then Save the connection.
 
slack-connection-filled