What StarfishETL’s AI Features Mean for You

StarfishETL, the low-code iPaaS (Integration Platform as a Service) known for its user-friendly interface, just announced a game-changer for data analysts and business users: a suite of AI-powered features!

StarfishETL already offers visual editing tools, low code automation, and pre-configured mapping options to help kickstart client data projects, but these new AI additions add even more capacity to skyrocket project timelines and decrease coding. Let’s take a look at what’s new:

Effortless Field Mapping

Many of StarfishETL’s maps already come pre-configured, but now, customers with more obscure data connections still have efficient options. AI-assisted field mapping analyzes your data and suggests matches between source and destination fields, getting you started quickly. Need to map just a few fields? No problem, you can narrow down the suggestions before finalizing.

StarfishETL offers connections to more than 400 popular business applications. Its Cloud Cartographer is low code, with a visual mapping designer to guide the user on their data flow. The AI-powered field mapping further simplifies this essential function of integration.

Seamless Script Writing

Scripting is the process of creating automated sequences of commands or instructions that perform specific tasks related to data movement, transformation, and analysis. StarfishETL supports scripting in four major coding languages: C#, JavaScript, VBScript, and Python.

Traditionally, script writing involves writing, testing, and debugging the code to implement in the integration. With StarfishETL’s new AI functions, much of that manual work is eliminated. The AI model can interpret what the user is trying to accomplish and present them with a complete script to review and approve for their mapping.

It can also tackle activities beyond basic scripting functionality like performing lookups, logging data, and working with cross-reference lists (Xrefs). This has the potential to exponentially increase the speed of script writing and dramatically cut down on errors.

Supercharged SQL Query Writing

SQL queries are essential for data integration as they allow you to extract, transform, load, and validate data efficiently and flexibly. They can be used to interact with relational databases and perform various operations, making them a fundamental tool for data integration processes. Building complex SQL queries can sometimes become very time-consuming.

StarfishETL's AI simplifies the process. Just tell it what data you need, including the tables involved, and the AI will generate a complete SQL SELECT statement for you to refine and use. This leads to more efficient and powerful SQL query writing capabilities.

Faster, More Accurate Data Projects

So, what do all these AI enhancements mean for you? You can apply them to reduce manual effort, accelerate project timelines, and simplify complex data projects for teams of all skill levels.

More is yet to come, so stay tuned for future AI releases! To start your next project, request a demo of these new AI-powered features, and experience the difference for yourself.