How to Connect to SQL Server 2019 in Precog

This guide walks you through connecting Precog to SQL Server 2019.

Preparation

Before you complete the Precog destination configuration form, make sure the following are in place:

• Database: Create a database (for example, named precog) where Precog can write data.
  
  
• User permissions: The SQL Server user you provide must have permission to:
  
  
  • Read and write data
    
    
  • Create schemas
    
    
  • Drop and truncate tables
    
    
  • Append and insert records
    
    
• Firewall access: Your firewall must allow connections from Precog’s IP addresses:
  
  
  • 44.205.118.35/32 (precog.cloud)
    
    
  • 3.73.24.30/32 (eu.precog.cloud)
    The /32 means only those exact IPs will be accepted.
    
    

Network Setup

• If you are connecting directly, your SQL Server must be accessible over the internet.
  
  
• If you plan to use SSH tunneling, first connect to SQL Server without tunneling to confirm access. Once the direct connection is established, you can add SSH tunneling for secure access to servers on private networks.
  
  
• Your organization’s firewall also needs to route traffic from Precog to your SQL Server if it resides on a private IP.
  
  

Responsibility

Precog provides the connection point, but setting up SQL Server itself is the responsibility of your team. This includes creating the database, assigning permissions, and ensuring the server is reachable.

Precog Destination Configuration Form

Server Name
The domain or IP address of your SQL Server instance. Example: mycompany.azuredbserver32.database.windows.net. Without SSH tunneling, this must be publicly accessible. With SSH tunneling (on-premises), you can use a private IP address.

Server Port
The port used to connect. Default is 1433. Enter a different port if required.

Database Name
The SQL Server database where Precog will write data, such as precog. The credentials you provide must have write permissions in this database.

Username
Your SQL Server 2019 username with the required permissions.

Password
The corresponding SQL Server 2019 password.

Optional SSH Tunneling Fields

• SSH Server Name: The domain or IP address of your SSH (Jump) Server. This must be publicly accessible and acts as the entry point for the secure tunnel.
  
  
• SSH Server Port: The port used by your SSH (Jump) Server. Default is 22.
  
  
• SSH Username: The username used to connect through SSH.
  
  
• Private Key File: The private key for SSH authentication. It must match the public key authorized on your SSH server.
  
  
• Verify Server Certificate: Specifies whether the SSL certificate is validated. For initial setup, set this to No.