See llms.txt for all machine-readable content.

Oracle Database and Ritekit integration

Save yourself the work of writing custom integrations for Oracle Database and Ritekit and use n8n instead. Build adaptable and scalable workflows that work with your technology stack. All within a building experience you will love.

How to connect Oracle Database and Ritekit

Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Oracle Database and Ritekit integration: Create a new workflow and add the first step

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 DBMS_CLOUD_AI 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: BEGIN DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'AZURE_OPENAI_CRED', username => 'azure_openai', password => 'YOUR_AZURE_OPENAI_API_KEY' ); END; / Select AI Configuration In Workflow A, update the Select AI configuration node with your environment details: { "profile_name": "EXCEL_AI", "provider": "azure", "azure_resource_name": "YOUR_RESOURCE_NAME", "azure_deployment_name": "YOUR_MODEL_DEPLOYMENT", "credential_name": "AZURE_OPENAI_CRED", "table_name": "AUTO_GENERATED" } 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: curl -X POST \ -F "[email protected]" \ https://your-n8n-instance.com/webhook/upload-excel Expected Response { "success": true, "tableName": "UPLOAD_EXCEL_20260209123456789", "columns": ["ID", "NAME", "AGE", "CITY", "SALARY"], "rowCount": 150, "selectAIProfile": "EXCEL_AI", "message": "Excel file successfully ingested and registered with Oracle Select AI", "nextSteps": [ "Query your data using: SELECT AI EXCEL_AI <your question>", "Example: SELECT AI EXCEL_AI show me the top 10 records by salary" ] } 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 EXCEL_UPLOAD_COMPANY_TABLE EXCEL_AI count records grouped by city EXCEL_UPLOAD_TRAVEL_TABLE What is the average salary per department from EXCEL_UPLOAD_DEPT_TABLE n8n Query Examples 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 https://docs.oracle.com/en-us/iaas/autonomous-database-serverless/doc/select-ai-examples.html Azure OpenAI Documentation https://learn.microsoft.com/azure/ai-services/openai/ Oracle LiveLabs – Select AI Workshop https://livelabs.oracle.com/ords/r/dbpm/livelabs/run-workshop?p210_wid=3831

Build your own Oracle Database and Ritekit integration

Create custom Oracle Database and Ritekit workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Oracle Database supported actions

Supported methods for Ritekit

Delete
Get
Head
Options
Patch
Post
Put

To set up Ritekit integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Ritekit to query the data you need using the API endpoint URLs you provide.

See the example here

Requires additional credentials set up

Use n8n's HTTP Request node with a predefined or generic credential type to make custom API calls.

Oracle Database and Ritekit integration details

Ritekit

Ritekit

RiteKit is a social media optimization tool that offers various features like hashtag suggestions, image optimization, text analysis, and post scheduling, helping users to enhance the reach and engagement of their social media posts.

FAQ about Oracle Database integrations

Looking to integrate Slack and VirusTotal in your company?

Three colleagues talking around laptops at a shared desk

Trusted by teams building smarter workflows.

Why

Why use n8n to integrate Oracle Database with Ritekit

Handle branching, merging and iteration easily. Pause your workflow to wait for external events.

Re-run single steps to test changes in no time. And pin your data to avoid generating trigger events every time you execute.

Your data is displayed alongside your settings, making edge cases easy to track down.

Use 1000+ workflow templates available from our core team and our community.

Copy and paste, easily import and export workflows.

Simple enough to 
understand + sophisticated 
enough to ship

Man in a brown jacket working at his desk by a window