XML Tools

AI Tools for Development and Data Integration

AI Assistants to Increase Productivity and Drive Innovation

Artificial Intelligence (AI) has made a significant impact on the field of software development – not by replacing software engineers as some have predicted – but by actually increasing their value by freeing them to focus on higher-level tasks. AI integration in developer tools offers opportunities to streamline processes, enhance productivity, and unlock new levels of innovation. Given the pace of business today, the integration of AI into development, data management, and database creation platforms is proving to be a game-changer.

Using software with integrated AI tools helps developers focus on more strategic and creative tasks, while AI handles the repetitive and labor-intensive aspects of a project. The gains in time and innovation give users a significant competitive advantage.

Altova offers multiple products that integrate AI capabilities into the existing workflow and development environment. This integration allows developers to benefit from AI assistance without disrupting their established processes and tools.

AI integration is available in:

  • XMLSpy AI Assistant for XML and JSON development
  • MapForce for AI-powered data transformation and ETL
  • DatabaseSpy for AI-assisted SQL editing tasks
  • RecordsManager for creating databases from natural language prompts

XMLSpy AI Assistant

AI Assistant for XML editing in XMLSpy

XMLSpy includes an integrated AI Assistant that allows engineers of any skill level to use natural language prompts to generate JSON and XML Schemas, XML documents, XSL and XQuery code, and more. The AI Assistant can also generate a sample instance documents filled with real-world data and any other documents to get a jump start on coding.

The code corresponding to your prompts is auto-generated by AI. Using the AI Assistant toolbar, you can copy the response to the clipboard, create a new document that includes the response, or open it in the XMLSpy XPath/XQuery window for further testing and refinement. Developers can explore and refine generated documents using intelligent editors and visual tools like XML Grid, JSON Grid, and graphical schema editors.

Accessing the AI Assistant in XMLSpy is as easy entering your current Open AI key using the Options dialog. This enables ChatGPT functionality directly in the development environment. Since the API is accessed directly by the editor, you’ll immediately have access to the latest available model (as well as previous models).

AI Integration in MapForce

Using AI for classification in ETL projects

Current AI models have the potential to enhance data integration tasks in numerous ways. Some of the most significant advances relevant to data mapping and ETL center around AI-powered classification abilities.

The ability of AI systems to classify inputs across various domains can help organizations add value to their data in meaningful ways. This is especially applicable for enhancing data written to a database or other datastore during data integration or ETL processes, where the AI-provided data offers additional signals to inform business decision making.

MapForce is AI-ready, with visual tools for constructing calls to any AI system available by API, including OpenAI's ChatGPT, the Azure OpenAI API, AWS AI Services, and so on. Using these calls users can enable AI-powered data processing in any data integration or ETL project.

Possible applications include using AI for:

  • Sentiment analysis
  • Image, photo, and video classification
  • Document classification
  • Machine translation
  • Summarizing long texts

AI-powered data processing adds value to data written to a database and can be used in any MapForce data mapping project involving XML, JSON, Excel, text, EDI, and other data formats.

DatabaseSpy AI Assistant for SQL

AI Assistant in DatabaseSpy SQL Editor

AI is a great productivity booster for IT projects, and working with databases is one area where AI is really making inroads for improving efficiency. By leveraging AI in database tools, DBAs and database developers of any skill level can save time and effort with AI-generated SQL scripts and sample data, for instance, as well as query optimization and troubleshooting.

AI tools in Altova DatabaseSpy simplify tasks like generating SQL scripts and sample data, alleviating the burden of manual coding and data creation. Additionally, AI can optimize query performance, identifying potential bottlenecks and proposing optimized query structures to improve overall system performance and responsiveness. This makes the multi-database tool, which supports all major databases in a single UI, even more useful.

The SQL AI Assistant in DatabaseSpy consists of two tools:

  • AI Chat Dialog
  • AI Extensions

The AI Chat Dialog allows you to send requests to ChatGPT to create sample SQL statements, create sample data for a given table structure, create relations between tables that have no keys yet, and so on. Once you send a request and receive the response, you can copy and paste the returned SQL into an existing file or create a new SQL file with the response.

During SQL editing, available AI Extensions include:

  • AI-Complete: will send a request to complete a SQL statement
  • AI-Explain: requests a textual explanation of a statement
  • AI-Explain Error: request details about an error and possibilities for solving it
  • AI-Pretty Print: formats the current statement in a more readable format

With built-in AI integration, DatabaseSpy becomes a more powerful and user-friendly platform, boosting productivity for both novice and experienced users

Build Databases with AI in RecordsManager

Business apps and enterprise solutions typically require a database backend, and developers are all too familiar with the need to carefully plan and design the database structure. This includes hours spent on creating tables, defining fields, setting up relationships, and ensuring normalization. It’s a crucial but time-consuming task that requires a deep understanding of database architecture and SQL.

Thanks to AI integration, Altova RecordsManager can now automate this entire process for you. Instead of starting from scratch and carefully mapping out every detail, you can simply provide a high-level prompt to the RecordsManager AI Assistant. It then acts as an intelligent assistant, instantly generating a complete database structure based on your prompt.

Your AI-created database includes the required tables, as well as list views, detail views, data entry forms, filters, and even charts and graphs for numerical data. The AI Assistant also provides real world sample data for previewing your new solution.

With RecordsManager, you can effectively go from idea to database in seconds.

Here's how to go from idea to database in seconds using RecordsManager

Try the Cloud-based Demo

You can experiment with the AI tools in RecordsManager using our cloud-based demo. You won't need to sign in or create an account; you can simply try some AI prompts to see how the functionality works.