Python
JavaScript
Webhook
S3
Postgres
BigQuery
SnowflakeAdventCalendar-DIM_ADVENT_CALENDAR
Order Product ID, Order ID, Advent Product Id, Product Name, DFG Portfolio, DFG Occasion, DFG Range, DFG Line, DFG Packagi...
Microsoft SQL Connector for your product
Support a bidirectional integration with Microsoft SQL without the engineering lift.
Bi-Directional
OtherYour Product
Microsoft SQLBi-directional
OtherHotglue sits between your product and Microsoft SQL
Two ways to ship a Microsoft SQL integration: pick the setup that fits how much engineering lift you want to take on.
Least engineering lift
Add your product as a connector
If you have a public API, you can ship a Microsoft SQL integration without costing valuable engineering time.
- 1Add a connector for your APIOur team can build it for you, or you can use our connector builder and SDKs.
- 2Enable the Microsoft SQL connector
- 3Hotglue manages the mappingHotglue's built-in transformation layer will handle mapping data from Microsoft SQL to your product.
Flexible wiring
Plug Hotglue into your stack
Don't have a public API? You can still use Hotglue for the heavy lifting.
WIDGET AND MAGIC LINK
Seamless, White–Labeled Connection Experience
Enable users to securely link their integrations: leverage our magic link experience, or embed the Hotglue widget into your product.
SUPPORTED DATA
Microsoft SQL data
Hotglue's connector supports all objects and fields the Microsoft SQL API makes available.
Don't see what you're looking for? Let us know.AdventCalendar-DIM_BYO_PRODUCTS
Order Product ID, Order ID, BYO Product ID, BYO Product Name, Dram ID, Dram Name, Product Type, Product Type Style, Liquid...
AdventCalendar-DIM_DRAM_PRODUCT
Product Primary Key, Advent Product Id, Parent Product Id, Dram Product Id, Dram Product Name, Product Type, Product Type ...
AdventCalendar-DIM_PARENT_PRODUCT
Parent Product Id, Product Name, Release Year, Product Type, Product Type Style, Parent Geography, Geography, Liquid Volum...
AdventHistory-DIM_ADVENT_HISTORY
ATOMOrderItemID, OrderDate, AccountingOrderDate, ProductID, ProductName, Portfolio, Occasion, Range, Line, PackagingConfig...
Allocations-DIM_ALLOCATIONS_4000
ORDER_ID, PUB_ORDER_NUMBER, ACCOUNTING_PERIOD_INTERNAL_ID, ACCOUNT_NUMBER, AMOUNT
Allocations-DIM_ALLOCATIONS_4001
ACCOUNTING_PERIOD_INTERNAL_ID, TRAN_DATE, ORDER_ID, PUB_ORDER_NUMBER, TRAN_ID, AMOUNT
Allocations-DIM_ALLOCATIONS_4003
ACCOUNTING_PERIOD_INTERNAL_ID, TRAN_DATE, ORDER_ID, PUB_ORDER_NUMBER, TRAN_ID, AMOUNT
Allocations-DIM_ALLOCATIONS_5001
ACCOUNTING_PERIOD_INTERNAL_ID, ACCOUNT_TYPE, TRAN_ID, AMOUNT, ORDER_ID
Allocations-DIM_ALLOCATIONS_5003
ACCOUNTING_PERIOD_INTERNAL_ID, ACCOUNT_TYPE, TRAN_ID, AMOUNT, ORDER_ID
Allocations-DIM_ALLOCATIONS_DATE
INTERNAL_ID, PERIOD_NAME, YEAR_MONTH, YEAR, MONTH
Allocations-DIM_ALLOCATIONS_DELIVERY_CHARGE
ORDER_ID, YEAR_MONTH, YEAR, MONTH, ACCOUNTING_PERIOD, BUSINESS_UNIT_V2, DELIVERY_CHARGE
EXPLORE MORE
Popular connectors
Related integrations your customers may also want to connect.
SECURITY & COMPLIANCE
Enterprise level security out of the box
Hotglue is SOC 2 Type II and GDPR compliant by design. Unlike traditional integration platforms, Hotglue never stores your customer data—we process it securely and deliver it directly to you.
Ready to build your next integration?
Build native integrations with the platforms your customers use 10x faster.