Azure Voice Bot with SQL Integration

I need an end-to-end voice bot running on Azure AI cloud. The solution must answer customer inquiries and order-status questions by pulling live information from either a SQL database or pre-formatted Excel sheets. When a caller wants to place an order, the bot should capture the details, write them back into the same database, and then trigger a simple workflow I can extend later (for example, sending a confirmation email or creating a ticket).

Key points I care about
• Azure is the only hosting environment—please rely on native services such as Cognitive Speech, Bot Service, and, if helpful, Communication Services for the voice channel.
• Data layer: connect securely to Azure SQL; however, I also keep some reference tables in Excel stored on OneDrive, so the bot must query those files as read-only sources.
• Dialog logic: conversational, able to handle follow-ups and fallback gracefully.
• Functions required: respond to queries, collect orders, record them to the database, and kick off a small workflow (Logic Apps or comparable).
• Supported query topics: customer inquiries and order-status checks.
• I answered “Azure cloud” for the channel question, so everything should be accessible inside the Azure ecosystem—no third-party hosting.

Deliverables
1. Deployable Azure resources (ARM/Bicep or Terraform) with documentation.
2. Bot source code with clear instructions for local testing.
3. SQL scripts to create the required tables and sample Excel files.
4. A short demo video (screen-capture is fine) proving: a) query response, b) order capture and DB write, c) workflow trigger.

Acceptance criteria
• Voice interaction works through Azure and the bot answers at least 90 % of a provided test set correctly.
• New orders appear in the SQL table within five seconds of completion.
• Workflow fires automatically after each successful order.

If something here needs clarification, let me know—otherwise I’m ready to get this rolling.