Snowflake - Icon

Snowflake

Firebase-icon-color

Firebase

pestroutes

PestRoutes

Google BigQuery - Icon

Google BigQuery

Prometheus - Icon

Prometheus

MongoDB - Icon

MongoDB

Google Maps - Icon

Google Maps

AmazonAthena-icon-color

Amazon Athena

Databricks - Icon

Databricks

MySQL-icon-color

MySQL

InfluxDB

FreshService

Freshservice

PostgreSQL-icon-color

PostgreSQL

Oracle E-Business Suite EBS - Icon

Oracle E-Business Suite EBS

Mendeley - Icon

Mendeley

Neo4j

PagerDuty - Full

PagerDuty

Azure Synapse Analytics - Icon

Microsoft Azure Synapse Analytics

SAP Hana - Icon

SAP HANA

JDBC Client - Icon

Java Database Connectivity (JDBC)

Insert one or more rows into your Microsoft SQL database.

Insert rows

List table fields DDL

List tables DDL

List tables and views DDL

List views DDL

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

Update rows

Run SQL query

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

Count 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

Microsoft SQL Server 1 

Integrations

Low-code Microsoft SQL Server integrations

Microsoft SQL Server 2

Automation

Powerful Microsoft SQL Server automation

Microsoft SQL Server 3

Use Cases

Heavy-duty Microsoft SQL Server use cases

weekly-group-demo 2x

Tray Platform group demo every 3rd Thursday at 10am PT

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

New Relic - Full - Dark

New Relic - ANONYMOUS

Software analytics company - Customer Story Quote

White New Relic Logo

Developers

SQL-Server

Microsoft SQL Server

Database

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

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 status of the planning process.

Get planning status

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

OptimoRoute

Vertical

Salesforce-icon-color

Salesforce

Slack-icon-color

Slack

MicrosoftPowerBI-icon-color

Microsoft Power BI

Google Drive - Icon

Google Drive

HubSpot-icon-color

HubSpot

Connectors

See all connectors

AWSS3

AWS S3

Zendesk-icon-color

Zendesk

Oracle NetSuite - Icon

NetSuite

Gmail - Icon

Gmail

Google Sheets - Icon

Google Sheets

Zoom - Icon

Zoom

Facebook - Icon

Facebook

Office365

Microsoft Office 365

Shopify-icon-color

Shopify

Asana-icon-color

Asana

Jira

Marketo - Icon

Marketo

Airtable-icon-color

Airtable

Customer Stories

Featured: Gartner MQ for iPaaS

Gartner Feature

Log in

Get Started

Navbar links

See all our connectors (Tertiary)

Similar connectors to Microsoft SQL Server and OptimoRoute

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

Start your free trial

Offer Type (Trial)

Campaign ID: Trial

Work Email

Company Name (Clearbit)

First Name (Clearbit)

Last Name (Clearbit)

Phone (Optional)

Company size (Clearbit)

Tray Form Contentful ID - Trial Multistep form

Arrow Button →

You’re only minutes away from joining over 46,000+ organizations using the power of Tray

Sign up to Tray

G2 Leader Winter 2023

Trial Multistep (pt 1)

Help us customize your experience by telling us a bit about what you would like to do

Personalize your setup

Trial Multistep (pt 2)

Trial Multistep form

Trial Mulitstep Form

Select the type of demo you’d like

Get a demo

Offer Type (multiple choice)

Email

Submit (Get a demo)

Salesforce Child Campaign ID

Modal Demo Multi (1351)

Get a demo (platform - secondary)

Trials + Demo | MAIN SITEWIDE CTA

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

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

Integrate Microsoft SQL Server and OptimoRoute with any SaaS application or service using the Tray Platform’s universal connectors. Quickly configure them to connect to any API, database, webhook, and more.

Microsoft SQL Server and OptimoRoute integration + automation

Popular Microsoft SQL Server and OptimoRoute integrations

Microsoft SQL Server and OptimoRoute Connector Details

Microsoft SQL Server

OptimoRoute

Tray.io is the leader in low-code automation

Similar connectors to Microsoft SQL Server and OptimoRoute

Try Tray today and see for yourself. No strings attached.