Using the Redis Connection Manager

The Redis Connection Manager is an SSIS connection manager component that can be used to establish connections with Redis.

To add a Redis connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted the "Add SSIS Connection Manager" window. Select the "Redis" item to add the new Redis connection manager.

New Connection

Add SSIS Redis Connection Manager

The Redis Connection Manager contains the following two pages to connect to your Redis server.

  • Authentication
  • Advanced

Authentication Page

The Authentication page of the Redis Connection Manager allows you to specify the server addresses and credentials for authentication.

Host

The Host represents the Server address containing your Redis server.

Port

The Port to your Redis server

User

The User represents the user for your Redis Server instance.

Password

The Password for the Redis Server instance.

Advanced Page

This page contains all possible settings for a Redis connection. Clicking on a specific setting will display a description for the selected property at the bottom of The Advanced page.