AskData NL2SQL Engine

Introduction

Oracle AskData is a conversational AI platform powered by Oracle Generative AI. With AskData, you can ask natural language questions like "Give me all past due invoices" or "Show me sales for last week over $100,000" and get instant, accurate results.

The solution empowers both non-technical users and SQL experts by simplifying complex queries and freeing up time for deeper analysis and decision-making.

Getting Started

Please see the Introduction & Architecture

For policies see Defining Policies

Prerequisites

The CIS Landing Zone is optional but helps with providing a sandbox environment with best practices

• Deploy CIS LZ

This solution assumes you have access to an OCI tenancy with the admin ability to provision the following resources:

• IDCS/IAM Confidential App
  • Deploy IAM App
• Vault
  • Deploy Vault
• Business (Client) ADB database
  • Deploy Database
• Trust ADB database
  • Deploy Database
• OCI Cache
  • Deploy OCI Cache Cluster
• VCN
  • Private Subnet
  • Public Subnet
  • Deploy a VCN
• Two VMs
  • Engine
    • Deploy Engine Documentation
  • Bastion/jump host
    • To access engine in private subnet
• API Gateway
  • Deploy API Gateway
  • (Optional) If deploying API Gateway privately, see ADW API Gateway Private Access
• VBCS
  • Deploy VBCS
• ODA
  • Deploy ODA

Deployment Steps

1. Configure Business DB
2. Configure Trust DB
3. Configure IDCS App
4. Configure OCI Cache
5. Configure Engine
6. Configure API Gateway
7. Configure ODA Skills
8. Configure VB Apps

Validation

Validation Testing

Notes/Issues

See Troubleshooting

URLs

• Nothing at this time

Contributing

This project welcomes contributions from the community. Before submitting a pull request, please review our contribution guide.

Security

Please consult the security guide for our responsible security vulnerability disclosure process.

License

Copyright (c) 2024 Oracle and/or its affiliates.

Licensed under the Universal Permissive License (UPL), Version 1.0.

See LICENSE for more details.

ORACLE AND ITS AFFILIATES DO NOT PROVIDE ANY WARRANTY WHATSOEVER, EXPRESS OR IMPLIED, FOR ANY SOFTWARE, MATERIAL OR CONTENT OF ANY KIND CONTAINED OR PRODUCED WITHIN THIS REPOSITORY, AND IN PARTICULAR SPECIFICALLY DISCLAIM ANY AND ALL IMPLIED WARRANTIES OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY, AND FITNESS FOR A PARTICULAR PURPOSE. FURTHERMORE, ORACLE AND ITS AFFILIATES DO NOT REPRESENT THAT ANY CUSTOMARY SECURITY REVIEW HAS BEEN PERFORMED WITH RESPECT TO ANY SOFTWARE, MATERIAL OR CONTENT CONTAINED OR PRODUCED WITHIN THIS REPOSITORY. IN ADDITION, AND WITHOUT LIMITING THE FOREGOING, THIRD PARTIES MAY HAVE POSTED SOFTWARE, MATERIAL OR CONTENT TO THIS REPOSITORY WITHOUT ANY REVIEW. USE AT YOUR OWN RISK.