Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI

Overview This n8n workflow template enables querying Excel data stored in an Oracle Database using natural language powered by Oracle Select AI. The solution consists of two workflows: - Workflow A uploads an Excel file, creates a table in Oracle Database, inserts the data, and registers the table with Oracle Select AI. - Workflow B provides a chat interface that allows users to query the uploaded data using natural language. User questions are translated into SQL by Oracle Select AI, executed directly in the database, and returned as query results. Features - Natural language queries – Ask questions in plain English - AI-powered SQL generation – Automatically converts questions to SQL using Oracle Select AI - Real-time responses – Queries run directly on Oracle Database - Secure by design – Data never leaves Oracle Database - Chat UI support – Built-in chat interface when the workflow is public - API-ready – Can be used as a REST API endpoint Prerequisites Oracle Database - Oracle Database 23ai or later (required for Select AI) - Database user with the following privileges: - CREATE TABLE - INSERT - EXECUTE on DBMSCLOUDAI Oracle Select AI supports the following AI providers: - OCI Generative AI - OpenAI - Azure OpenAI (used in this template) - Google Gemini Azure OpenAI - Active Azure OpenAI resource - Deployed GPT model (for example: gpt-4, gpt-4o-mini) - Azure resource name and deployment name Oracle Credential for Azure OpenAI Create an Oracle credential to securely store the Azure OpenAI API key: Select AI Configuration In Workflow A, update the Select AI configuration node with your environment details: Note: The table name is generated automatically during upload and should not be modified manually. Usage Upload Excel File (Workflow A) Upload an Excel file using the webhook endpoint: Expected Response The returned tableName is used internally by Workflow B to scope chat queries to the correct dataset. Query Your Data with Select AI (Workflow B) After the Excel file is uploaded and registered, you can query the data using natural language through Workflow B. Example Select AI Queries After uploading an Excel file, you can query the data using natural language. Examples: - Show me the top 10 records by salary from EXCELUPLOADCOMPANYTABLE - EXCELAI count records grouped by city EXCELUPLOADTRAVELTABLE - What is the average salary per department from EXCELUPLOADDEPTTABLE Workflow B must be used together with Workflow A and must be configured with the same: - Oracle Database - Select AI profile name - Azure OpenAI configuration References Oracle Select AI Documentation Azure OpenAI Documentation Oracle LiveLabs – Select AI Workshop