# Error when accesing tables from Synapse

**URL:** <https://community.hubspot.com/t/error-when-accesing-tables-from-synapse/57673>\
**Category:** APIs & Integrations\
**Tags:** developer-tools\
**Created:** [May 25, 2022, 9:02am UTC](https://community.hubspot.com/t/error-when-accesing-tables-from-synapse/57673 "2022-05-25T09:02:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![LLiz](https://avatars.discourse-cdn.com/v4/letter/l/7c8e57/32.png) [@LLiz](https://community.hubspot.com/u/LLiz)\
**Post date:** [May 25, 2022, 9:02am UTC](https://community.hubspot.com/t/error-when-accesing-tables-from-synapse/57673/1 "2022-05-25T09:02:51Z")

</div>

Hi

We are trying to obtain the data of HubSpot from Azure Synapse without success.

We are getting the following error when accesing to the tables:

Error code 9603

Details ERROR [HY000] [Microsoft][Hubspot] (61) API Connection Failed. Bad Request. HTTP Responde code: 400

Any help?

 ![Captura3.JPG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/4/f45a42605bd81aced596be01b4bc817b6c1d02b6.jpeg)

---

<div class="post-metadata">

**Author:** ![dennisedson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dennisedson/32/28044_2.png) [@dennisedson](https://community.hubspot.com/u/dennisedson)\
**Post date:** [May 26, 2022, 1:30pm UTC](https://community.hubspot.com/t/error-when-accesing-tables-from-synapse/57673/2 "2022-05-26T13:30:56Z")

</div>

@LLiz ,

Did you follow the instructions detailed on [this page](https://docs.microsoft.com/en-us/azure/data-factory/connector-hubspot?tabs=data-factory)?

@johnelmer may have some advice, but it might be best to ask in the [Azure community](https://azure.microsoft.com/en-us/support/community/)

---

<div class="post-metadata">

**Author:** ![johnelmer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/johnelmer/32/55984_2.png) [@johnelmer](https://community.hubspot.com/u/johnelmer)\
**Post date:** [May 26, 2022, 4:41pm UTC](https://community.hubspot.com/t/error-when-accesing-tables-from-synapse/57673/3 "2022-05-26T16:41:15Z")

</div>

@LLiz it’s hard to say what the problem is, but if you are not able to solve it, we offer an app in the HubSpot App Marketplace called [MS SQL Server for HubSpot](https://ecosystem.hubspot.com/marketplace/apps/marketing/data-management/mssql-replicator) . The app pulls your HubSpot data into an Azure SQL data warehouse via prebuilt API connectors. The data warehouse in Azure is included in the cost.

Once your HubSpot data is in the data warehouse, it automatically refreshes on a scheduled basis. You can connect the SQL data warehouse to any other application that has a SQL connector.