Allowing Xplenty access to my Segment Redshift cluster

Xplenty can access your Segment Redshift cluster. This article discusses creating the connection in Xplenty.

By default access to Segment's Redshift cluster is publicly open, but you can and should limit access to your Segment by creating a whitelist. Send an email to friends@segment.com asking to include the Xplenty's IP addresses, on a Segment whitelist for your account.

To create a Segment connection In Xplenty
  1. Click your avatar at the top right of the window, then click Account settings.
  2. On the left menu, click Connections. Existing connections are listed.
  3. To create a connection, click new connection 
  4. Click on Segment.
  5. In the new segment connection window, name the segment and enter the segment connection information:
    • Name - name for the new Segment connection 
    • Organization Slug - name of your organization's slug
    • User name - database user name
    • Password - database user password
    • Connect using SSL - check this if SSL is required to connect to the database
  6. You can test the segment connection by clicking test connectionIf the credentials are correct, a message that the segment connection test was successful appears.
  7. Click create segment connection.
  8. The connection is created and appears in the list of segment connections.
To modify Segment connections in Xplenty:
  1. Click your avatar at the top right of the window, then click Account settings.
  2. On the left menu, click Connections. Existing connections are listed.
  3. Click a connection to modify or delete it. To exit the edit segment connection window without changes, click connections at the top of the edit segment connection window.
Note

Since the Segment user has readonly access, a Segment connection can only be used in a Redshift source component and not in a destination component.

Feedback and Knowledge Base