In the world of data management and analysis, Microsoft Excel reigns supreme as one of the most powerful tools available. Its versatility is further enhanced through add-ins, which extend its functionality and compatibility with various databases. With the release of Devart Excel Add-ins version 2.9.1323, users can expect exciting new features and expanded support for database versions, enabling even greater flexibility and efficiency in data manipulation and analysis.
New Database Version Support
One of the most significant updates in Excel Add-ins 2.9.1323 is the expanded support for the latest versions of popular databases. Users can now connect Excel to the following new database versions:
- Oracle 23c
The latest iteration of Oracle database technology, Oracle 23c, is now fully supported by Excel Add-ins. This ensures that users can enjoy the newest features and improvements offered by Oracle for their data analysis tasks. - MariaDB 11
With support for MariaDB 11, Excel Add-ins continue to provide compatibility with one of the most popular open-source relational databases. Users can harness the power of MariaDB 11’s enhancements while working within the familiar Excel environment. - PostgreSQL 16
PostgreSQL remains a top choice for many organizations due to its robust features and performance. Excel Add-ins now support PostgreSQL 16, allowing users to seamlessly integrate data from this advanced database system into their Excel workflows. - SQL Server 2022
As Microsoft continues to innovate with its SQL Server platform, Excel Add-ins ensure that users can connect to the latest version, SQL Server 2022. This compatibility provides smooth data transfer and analysis for users relying on SQL Server’s cutting-edge capabilities. - NetSuite 2023.2
NetSuite is a leading cloud-based ERP system, and Excel Add-ins now support the latest version, NetSuite 2023.2. Users can easily extract and analyze data from NetSuite directly within Excel, streamlining their reporting and analysis processes.
Introducing New Products
In addition to enhanced database support, Excel Add-ins 2.9.1323 offer compatibility with new products, expanding the range of integrations available to users. One notable addition is the integration with Zoho Books and Zoho Desk, two popular solutions for accounting and customer support management. For more detailed information about these new integrations, check out our blog post here.
Enhanced Functionality and Performance
The update is not just about expanding support; it’s also about enriching the Excel add-in experience with improved functionality and performance. The latest updates are designed to refine the user experience and boost efficiency in Excel data operations. Significant among these improvements are:
- Product Renaming:
- The Excel Add-in for Magento has been rebranded as Excel Add-in for Adobe Commerce.
- The Excel Add-in for QuickBooks has transitioned to Excel Add-in for QuickBooks Online.
- Better Error Handling:
- Introduced a new setting: “Do not validate single update/delete per row on commit” under Options -> Edit -> Error Handling.
- Expanded Integration Capabilities:
- Support for Zendesk Custom Lookup Fields has been implemented.
- Optimized filtering and caching for V3 Product-related tables in BigCommerce.
- Improved Data Management:
- Now, when updating the Purchase object in QuickBooks, the necessary PaymentType parameter is automatically included.
- Advanced security with the support for two-factor authorization for Adobe Commerce.
- Additional Fields:
- CostRate field added to the TimeActivity object in QuickBooks.
- Phone field added to the Customers object in Shopify.
Conclusion
The release of Excel Add-ins 2.9.1323 represents a significant step forward in empowering users with enhanced database support, new product integrations, and improved performance. Whether you’re working with Oracle, MariaDB, PostgreSQL, SQL Server, NetSuite, or exploring new integrations with Zoho products, Excel Add-ins provide the tools you need to excel in your data analysis tasks. To learn more about specific features and capabilities of our products, visit the product pages Excel Add-ins for Oracle, MariaDB, SQL Server, PostgreSQL, and NetSuite.
