Docs
  • LogicLoop Documentation
  • LogicLoop Quickstart
  • Data Sources
    • Connect your data source
      • Deployment options
    • Supported data sources
      • API data (JSON)
      • AWS CloudWatch
      • BigQuery
      • Databricks
      • Google Analytics
      • Google Sheets
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Snowflake
      • Combine Results
      • LogicLoop Data Source
  • Queries
    • Write a rule
      • More rule options
      • A/B testing rules
      • Version history
      • Query Snippets
    • Visualizations & dashboards
      • Visualizations
      • Dashboards
  • Actions
    • Set up an action
    • Action destinations
      • Email
      • Slack
      • Webhooks & APIs
      • Microsoft Teams
      • Salesforce
      • Zapier
      • PagerDuty
      • Write to Database
      • Chain Rules
      • Google Sheets
      • Bento
    • Templating
  • Case Management
    • Case Management
      • Ticket Generation
      • Case Triage
      • Custom Fields and Attachments
  • AI
    • AI Query Helper
    • Ask AI
  • Teams & Settings
    • Integrations
      • Slack
      • Google Sheets
    • Invite your teammate
    • Groups & Permissions
  • Changelog
  • FAQs
  • Troubleshooting
  • Templates
    • Templates Home
    • Risk & Fraud Rules
    • AML Transaction Monitoring Rules
    • Logistics & Marketplace Ops
    • Customer Success & Growth
    • Systems Observability
    • Data Quality Monitoring
    • Healthcare
    • HTML Email Templates
      • Annual Review
      • Weekly Performance Table
      • Invoice Recap
  • BETA
    • AI SQL API
    • Approving rules
    • Render Data as JSON
    • Case Analytics
    • Python
  • Security & Legal
    • Security
    • AI Security
    • Terms of use
    • Privacy policy
    • Services description
Powered by GitBook
On this page
  • Option 1: Connecting your data directly
  • Option 2: Set up an SSH tunnel via bastion host
  • Option 3: On-Premises deployment

Was this helpful?

  1. Data Sources
  2. Connect your data source

Deployment options

PreviousConnect your data sourceNextSupported data sources

Last updated 1 year ago

Was this helpful?

LogicLoop is and handles your data with the most stringent levels of care.

We don't store the all data from the sources that you connect directly on our servers. Instead, we make a connection request to your database and only retrieve the information that is needed. Results retrieved are temporarily stored in our encrypted AWS RDS instance and deleted after 30 days. We don’t share/sell your data to any third parties.

Depending on your company's security policies, you may wish to explore one or more of our following deployment options:

Option 1: Connecting your data directly

The fastest option to get started is signing up for our SaaS product and simply to integrate directly with LogicLoop. Some strategies for doing this for security-sensitive companies:

  • If your database has a firewall such that it can only connect to a pre-defined set of IP addresses, you will need to whitelist our IP addresses. Email hi@getlogicloop.com for a list of our static IP addresses.

  • Connect LogicLoop to your secondary database instead of your primary

  • Connect LogicLoop to your data warehouse instead of your production database

  • Create a specific user with read-only permissions, or permissions to only read from specific tables.

Option 2: Set up an SSH tunnel via bastion host

SSH tunnel

Some companies may have stricter firewall policies. Instead of LogicLoop connecting to your database directly, we can set up an SSH tunnel to connect to your database behind a bastion host.

To enable this option, we assume you have a database that lies behind a firewall, protected by a bastion host that has access to the database. You will want to create a LogicLoop specific user in your bastion host with our public key so we can SSH into the bastion host to connect to the database. Please email us at hi@getlogicloop.com if you would like to get this set up.

Reverse SSH tunnel

A reverse SSH tunnel is similar to a regular SSH tunnel, except instead of LogicLoop SSH-ing into your bastion host, your bastion host SSHs into LogicLoop's application and creates a connection between your database port and LogicLoop's port to establish the connection.

To enable this option, we assume you have a database that lies behind a firewall, protected by a bastion host that has access to the database. Next, we will share with you credentials for SSH-ing into your LogicLoop instance. Within your bastion host, you can then set up an autossh connection to forward connections from your database port to LogicLoop's port. Please email us at hi@getlogicloop.com if you would like to get this set up.

Option 3: On-Premises deployment

The most conservative security option is to host your LogicLoop application completely on your own company's infrastructure. LogicLoop's software is cleanly packed up into Docker containers so we can give you access to our application's underlying source code and you can run the entire application in your own local cloud network. LogicLoop never accesses or touches any of your internal data.

Our application is packaged in Docker containers for ease of deployment in any cloud environment. We also provide AWS AMIs for ease of spin-up for those in the AWS environment. Email us at hi@getlogicloop.com to get started.

Reverse SSH tunneling is available for customers

Enterprise
SOC2 Type II Compliant
entering your database credentials