Using SQL Cloud Connector

A Datastore can connect to SQL in the cloud using the correct connection string and by allowing communication outwards to Eightwire cloud services.

Datastore Connection Settings

‍

Where is your Data?  —  In the Cloud

Type  —  SQL Server

Agent  —  Not required

Protocol  —  SQL Native Client

‍

Connection String  —  

Data Source=________________;Initial Catalog=_______;User ID=_____________;Password=____________

or

Data Source=________________;Initial Catalog=_____________;Trusted_Connection=true

‍

image

‍

IP Addresses to allow (Agent Controller and Processing Servers)

‍

agentcontroller.eight-wire.com                   40.127.77.7

proc-nz005.eight-wire.com                         220.247.134.82

proc-nz006.eight-wire.com                         103.253.51.48

proc-us001.eight-wire.com                          104.42.122.217

https://proc-au001.eight-wire.com             40.127.74.196