Introducing AIQuery in StarfishETL: Harnessing the Power of AI in your Integrations

In today’s fast-paced business world, automation and efficiency are critical to staying ahead. At StarfishETL, we’ve always strived to provide the best tools for seamless data integration, and now we’re taking things a step further with our newest feature: AIQuery.

This functionality allows you to leverage AI directly within your integration. By combining StarfishETL’s robust iPaaS capabilities with advanced AI-driven insights, AIQuery transforms how businesses handle integrations. With AIQuery, you can analyze data, generate summaries and reports, and transform data.

What Is AIQuery?

AIQuery is a new feature in StarfishETL that empowers users to:

Call AI with a specific prompt: Pass your prompt with data to receive tailored outputs.
Generate dynamic insights: For example, pass CRM or ERP data and a prompt like, “Summarize key performance trends from this dataset,” and get actionable insights instantly.
Train AI agents for better results: Companies can specify an AI agent and train it on their internal processes, documentation, and knowledge base. This customization ensures the AI delivers results aligned with your unique workflows and standards.
Generate responses to support queries: Use AIQuery to craft tailored replies to common or complex questions. For example, provide the AI with details of a new support request and ask it to generate a troubleshooting guide, user-friendly instructions, or client-ready documentation. This functionality enhances the efficiency of your support team.

Use Cases for AIQuery

Data Analysis

Example: Provide AI with sales data from a CRM integration and prompt it to “Identify the top-performing sales reps and regions for Q4.” Instantly receive a detailed summary.

Data Transformation

Example: Use AIQuery to parse and transform complex data without having to code the data transformation. For example, we can pass bad data, such as multiple phone numbers stuck into the office number field and ask AI to return the phone numbers separated into a list of valid phone numbers.

Next Steps Guidance

Example: Pass the information from a new Case to AI and ask for next steps. If the AI agent has been trained on your software platform, the recommendations can be tailored to fit your needs.

Real Life Example

Using AIQuery, I can transform phone numbers into the proper formatting, no matter the data being sent to it. A simple C# script to accomplish this is:
object ScriptedField()
{
                string result;
                result = Starfish.AIQuery("Please convert this phone number: \"" + ConvertObj2String(Starfish.OriginData["GENERAL_OFFICE_C"]) + "\" to this format: \"(999) 999-9999, x 9\". Respond with only the phone number.");
                return result;
}

The results of this look like:

“333-444-5555 ext 1234 - office ; 999-888-7777 - cell” to “(333) 444-5555, x 1234”

Looking Ahead

AIQuery is just the beginning. At StarfishETL, we are committed to continuous innovation that simplifies integration and drives business excellence. We believe AIQuery will be an essential tool for any organization seeking to enhance their data processes and communications.

Ready to see AIQuery in action? Contact us today to learn how this feature can revolutionize your integration workflows.