AI Solution

Build an AI-Powered Marketing Management Campaign Tool in OCI and Azure

Introduction

AI is set to transform marketing, so interweaving marketing applications and AI capabilities is vital. But what if your SaaS marketing tool sits apart from your main infrastructure? Multicloud solutions can help. This example shows how to save time on repetitive tasks, using AI to automate the extraction of marketing campaign data and create an outbound email, all through a simple chatbot prompt.

In this demo, the AI-powered chat interface works across Azure OpenAI, Oracle Database on Microsoft Azure, and Oracle Fusion Cloud Eloqua Marketing Automation on Oracle Cloud Infrastructure (OCI). Steps covered include the following:

  • Data extracted from Oracle Eloqua Marketing Automation on OCI, using REST
  • Tabulated JSON data stored in Oracle Database running on Microsoft Azure
  • Embeddings, created by Azure OpenAI, added to the database
  • A simple prompt interface created using Streamlit

For the chat interface, prompt input is converted into embeddings, followed by a similarity search in Oracle Database on Microsoft Azure. Relevant data is then processed by Azure OpenAI models to generate a contextual response from the marketing application’s data.

Demo

Demo: Build an AI-Powered Marketing Management Campaign Tool in OCI and Azure (2:19)

Prerequisites and setup

  1. Oracle Cloud account—sign-up page
  2. Microsoft Azure account—sign-up page