<div>
You can install SQL server management studio (free tool) on your system and connect the AMS360's database, You can run sql queries in ssms.
</div>


You can install SQL server management studio (free tool) on your system and connect the AMS360's database, You can run sql queries in ssms.

<div>
How exactly would I connect to the database if it is hosted in the cloud? Do you have any experience with AMS360 or how to actually connect it?
</div>


How exactly would I connect to the database if it is hosted in the cloud? Do you have any experience with AMS360 or how to actually connect it?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I will be working for an Insurance Agency that uses the popular AMS360 product made by Vertafore. Does anyone have any experience with the software, and know the method in which I can execute SQL Queries to return data? I would love to be able to be able to use Crystal Reports or Excel like I have with QuickBooks in the past (used a Connection String and QODBC for Excel). However, I can use whatever gets the job done.
</div>
</div>


Hello,

I will be working for an Insurance Agency that uses the popular AMS360 product made by Vertafore. Does anyone have any experience with the software, and know the method in which I can execute SQL Queries to return data? I would love to be able to be able to use Crystal Reports or Excel like I have with QuickBooks in the past (used a Connection String and QODBC for Excel). However, I can use whatever gets the job done.

Vertafore AMS360 (Cloud) and SQL Queries

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.