AI2sql Docs
Go to AppContact
  • 1. Introduction
    • 1.1. What is AI2SQL?
    • 1.2. Key features of AI2SQL
    • 1.3. How to get started with AI2SQL
    • 1.4. What Users Can Ask AI2SQL
  • 2. AI2SQL Dashboard
    • 2.1. Accessing the dashboard
    • 2.2. Generating SQL based on predefined datasets
    • 2.3. Exploring sample queries and use cases
  • 3. Managing Tables
    • 3.1. Importing tables using DDL
    • 3.2. Manually adding tables
    • 3.3. Editing, Updating, and Deleting Table Information
    • 3.4. Importing Database Schema via CSV
  • 4. AI2SQL Workspace
    • 4.1. Navigating the workspace
    • 4.2. Generating SQL for specific database engines
    • 4.3. Selecting tables for SQL generation
    • 4.4. Saving and organizing queries in the workspace
  • 5. Formatting SQL
    • 5.1. Accessing the SQL formatter
    • 5.2. Customizing formatting options
    • 5.3. Applying formatting to your SQL queries
  • 6. SQL Fixer
    • 6.1. Identifying SQL errors with SQL Fixer
    • 6.2. Understanding common SQL error messages
    • 6.3. Resolving SQL errors using AI2SQL's suggestions
    • 6.4. Handling Long SQL Queries
  • 7. Formula Generator
    • 7.1. Overview of Formula Generator
    • 7.2. Excel, Google Sheets, and regex formula translation
    • 7.3. Power BI DAX formula translation
    • 7.4. Airtable formula translation
    • 7.5. Using Formula Generator to enhance SQL queries
  • 8. CSV Analyzer
  • 9. Database Connectors
    • 9.1. Supported database connectors
    • 9.2. Setting up database connections (MySQL, SQL Server, or PostgreSQL)
    • 9.2.1. AI2sql Oracle Cloud Connector
    • 9.3. Setting up MongoDB Connectors
    • 9.4. Google BigQuery Setup and Service Account Key Creation
    • 9.5. Generating SQL queries for connected databases
    • 9.6. Setting up Snowflake Connectors
    • 9.7. Troubleshooting AI2sql Connector Issues: A Comprehensive Checklist
    • 9.8. Requesting new database connectors
    • 9.9. System Security Overview
  • 10. Dataset Questions Generation
  • 11. AI2SQL ChatGPT Plugin User Guide
    • 11.1. Introduction
    • 11.2. Getting Started
    • 11.3. Obtaining Your Token
    • 11.4. Using Your Token
    • 11.5. Connecting Your MSSQL (SQL Server) Database
    • 11.6. Connecting Your MySQL Database
    • 11.7. Connecting Your PostgreSQL Database
    • 11.8. Generating SQL Queries
    • 11.9. Troubleshooting
  • 12. Troubleshooting and Support
    • 9.1. Common issues and solutions
    • 12.2. Chat Support
    • 12.3. Contacting AI2SQL support
    • 12.4. Community resources and forums
  • 13. Templates
    • 13.1. Custom Template Creation
    • 13.2. Save the Template
    • 13.3. Generate SQL Using Template
  • 14. AI2sql: SQL Generation from Database ER Diagrams
    • 14.1. Introduction
    • 14.2. SQL Generation Process
    • 14.3. Troubleshooting & FAQs
  • 15. AI2sql API Integration
  • 16. AI2SQL Dictionary Template
  • 17. AI2sql GPTs
    • 17.1. Getting Started
    • 17.2. Obtaining Your Token
    • 17.3. Connecting Your MySQL Database
  • 18. Connecting Your Local Database
  • 19. SQL File Uploader
    • 19.1 Generating SQL queries
Powered by GitBook
On this page
  1. 9. Database Connectors

9.2.1. AI2sql Oracle Cloud Connector

Welcome to 'AI2sql Oracle Cloud Connector:

Previous9.2. Setting up database connections (MySQL, SQL Server, or PostgreSQL)Next9.3. Setting up MongoDB Connectors

Last updated 9 months ago

A Comprehensive Setup Guide'. This guide provides straightforward instructions for integrating AI2sql with Oracle Cloud. It covers installation, configuration, firewall setup, and troubleshooting to ensure a smooth and secure connection between AI2sql and your Oracle Cloud database.

  • Select Oracle Cloud Connector: In AI2sql, locate and select the option for connecting to an Oracle Cloud database.

  • Connection Details:

    • Enter the Connection Name: A unique identifier for this connection.

    • Specify the DSN (Data Source Name): The DSN corresponding to your Oracle Cloud database.

    • Provide the Owner Name: The owner's name of the Oracle Cloud database.

    • Input User: The username for accessing the Oracle Cloud database.

    • Set the Password: The password associated with your database user.

  • Test Connection: After entering all details, use the test feature in AI2sql to ensure that the connection is correctly set up and functioning.

  • Save and Use: Once the connection is successfully tested, save the settings and start using the connector for your data operations.

  • Configure Firewall for AI2sql Access:

    • Access Firewall Settings: Open the firewall settings on the system or network that hosts the Oracle Cloud database.

    • Add Rules/Exceptions: Create rules or exceptions to allow traffic from AI2sql to Oracle Cloud. This typically involves specifying the IP addresses or domain names used by AI2sql, and opening the relevant ports used for database communication.

  • Finalize and Test:

    • After configuring the firewall, retest the connection in AI2sql to ensure that the Oracle Cloud database is accessible with the new firewall settings in place.

For the most specific and detailed instructions, please consult the official documentation of AI2sql, as the actual process might have unique steps or additional requirements based on the software version and specific Oracle Cloud configurations.