Snowflake - Icon

Snowflake

Google Maps - Icon

Google Maps

SQL-Server

Microsoft SQL Server

Google BigQuery - Icon

Google BigQuery

Firebase - Icon

Firebase

Amazon Athena - Icon

Amazon Athena

Databricks - Icon

Databricks

MongoDB - Icon

MongoDB

PostgreSQL-icon-color

PostgreSQL

MySQL - Icon

MySQL

FreshService

Freshservice

IBMDB2-icon-color

IBM DB2

PagerDuty - Full

PagerDuty

Veeva

ServiceTitan - Icon

ServiceTitan

Azure Blob Storage - Icon

Microsoft Azure Blob Storage

Samsara - Icon

Samsara

Google Cloud Storage - Icon

Google Cloud Storage

Reltio - Icon

Reltio

Mode - Icon

Mode

Retrieves mobile events such as success, on duty, failed, … for the currently active plan (i.e. the last plan that was sent to drivers). Each request returns up to 500 events which occurred after the specified tag. The result will contain a new tag which you can use in the next request to skip already received events.

List mobile events

Retrieves the status of the planning process.

Get planning status

Creates a new order in the system or updates an existing order.

Create order

Creates update or replace one or more orders in the system. Note that geocoding addresses is not available in this call. The locations for orders must either exist in the system, or be specified via latitude and longitude coordinates. Geocoding is available in Create Order.

Create/Update orders

Delete order

Retrieves the routes for a specific date.

List routes

Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.

Raw HTTP Request (Advanced)

Starts the planning process for the specified date.

Start planning

Updates driver parameters for a particular date and driver start and end location. Any existing routes for the specified date/driver will be unscheduled.

Update driver parameters

marketing tools by tray.io

How Automation is Changing the Face of Business

hot-topics-blog-header-3@2x

Streamline strategic sales with an automated deal desk

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

Vox Media is on the Tray platform

Vox Media connects and automates pre- and post-sales to streamline workflow

business-automation blog post cover image

business-automation

GDPR compliance for US companies: What you need to know

Connector Department - All - Cards

New Relic - Full - Dark

New Relic - Anonymous

OptimoRoute

Vertical

Counts the number of rows that meet a given set of conditions.

Count rows

Updates rows in your database based on criteria of your choosing.

Update rows

Insert one or more rows into your Redshift database.

Insert new rows

Deletes rows in your database based on criteria of your choosing.

Delete rows

Find rows in your database based on criteria of your choosing.

Find rows

List table fields DDL

List tables DDL

Execute raw specified SQL code on the chosen database

Run SQL query

MongoDB-Logo

How to integrate MongoDB

postgresql-logo

How to integrate PostgresSQL

aws redshift

How to integrate Amazon Redshift

flow-data-between-csv-and-your-stack-with-csv-processor blog post cover image

flow-data-between-csv-and-your-stack-with-csv-processor

Learn How to Automate Your CSV and Flat File Management

Connector Department - Developers - Cards

Developers

Redshift - Icon

Redshift

Database

Watch the demo CTA Item - Used in main nav

Navigation CTA - Get Started

Product - Experiences

Product - Capabilities

Product - Platform Features

See Pricing / see packages

TUAC Platform Menu Packaging CTA - Option B

Enabling your entire organization to deliver on the promise of automation

Universal Automation Cloud

logo - ibm

IBM gets 95% boost in data delivery and reporting using the Tray.io Universal Automation Cloud

Customer Spotlight

UAC Solutions - By Team

UAC Solutions - By Use Case

TUAC Solutions - by application column - view all connectors CTA

UAC Solutions - By Application

A strategic platform with solutions for mission critical use cases

Solutions

Tuac Solutions Customer Spotlight: mixpanel cta item

Tuac Solutions Customer Spotlight: mixpanel cta

Mixpanel - White - Full

Mixpanel accelerates mission-critical order-to-cash process by 25%

Resources - Learn & Evaluate

Resources - Success

Resources - Company

Your journey to automation excellence starts here

Resources

TUAC Resources Spotlight - Eventbrite

TUAC Resources Customer Spotlight

Eventbrite - White - Full

Eventbrite accelerates high-quality integration delivery at scale and lifts customer satisfaction

See all our connectors (Tertiary)

Similar connectors to OptimoRoute and Redshift

Connector Awards

Tray.io is the leader in low-code automation

DigitalOcean - Full - Dark

David Dorman of Digital Ocean works with Tray.io

David Dorman - DigitalOcean

DigitalOcean - David Dorman

Details - Single & Double

"Request 1:1 demo" -> Demo LP [Primary style] | MAIN SITEWIDE CTA

MAIN SITEWIDE CTA | Demo Landing Page

OptimoRoute and Redshift integrations couldn’t be easier with the Tray Platform’s robust OptimoRoute and Redshift connector, which connects any services without the need for separate integration tools.

OptimoRoute and Redshift integrations couldn’t be easier with the Tray Platform’s robust OptimoRoute and Redshift connectors, which can connect to any service without the need for separate integration tools.

Integrate OptimoRoute and Redshift with any SaaS application or service using the Tray Platform’s generic connectivity options, such as the HTTP Client, Webhook Trigger, and our Connector Builder. Configure them to connect to OptimoRoute and Redshift and any other API, database, webhook, and more.

OptimoRoute and Redshift integration + automation

OptimoRoute and Redshift Connector Details

Popular OptimoRoute and Redshift integrations

OptimoRoute and Redshift templates