Category: Enterprise software & integration (Page 14 of 32)

AtScale, a provider of semantic layer solutions for modern business intelligence and data science teams, announced deeper integration with Microsoft Excel’s advanced analytic functions. AtScale makes it possible to connect Excel workbooks to live cloud data platforms, including Snowflake, AWS, Microsoft Azure, Google Cloud, and Databricks. Excel users can work with data without extracting or moving data. Leveraging native MDX (Multi-Dimensional Expression) integration, the AtScale semantic layer is accessible with Excel PivotTables, Slicers, and Cell Definitions. New support includes the ability to work with cell-level CUBE functions for embedding dimensional queries directly in cell formulas. Capabilities include:

• Native Connection – AtScale’s MDX-based connector lets Excel users access models and data through a semantic layer, with no additional drivers or client-side software. AtScale shields data consumers from the raw data structures and cloud access.
• Performant Access to Live Cloud Data – Data requests through AtScale’s semantic layer are directed in real time to underlying cloud data platforms, with no need for extracts or pre-processing of data.
• Analytics Governance and Security – Supports Excel’s single sign-on with Active Directory / LDAP integration.
• Automatic Data Refresh – Supports Excel’s automatic data refresh to avoid stale data and the need to manually copy and paste raw data.

https://www.atscale.com/press/atscale-expands-semantic-layer-solution-for-microsoft-excel/

Couchbase, Inc. announced the availability of Couchbase Server 7. This release bridges the best aspects of relational databases like ACID transactions with the flexibility of a modern database.

Customers can execute business transactions within their customer-facing applications, develop customer 360 data models and applications, and execute plans to modernize relational-based applications to the cloud. Development teams can more easily make the transition from relational databases to Couchbase’s modern database without needing to re-train team members as the platform supports the programming languages they already use. Highlights: 

• Eliminating of database sprawl by adding mature SQL transaction capabilities. Customers no longer need both a relational database and a NoSQL database. Couchbase now has multi-statement SQL transactions by fusing together transactions and high-volume interactions.
• Enabling runtime updates with zero downtime through a dynamic data containment model. Couchbase Server 7 introduces schema and table-like organizing structures, called “scopes and collections,” within the schemaless database. With Couchbase Server 7 can customers add a table (the “collection”) in Couchbase, while transactions are happening without having to add or modify the schema (the “scope”) or take down the database for this upgrade.
• Faster operational performance that lowers the total cost of ownership facilitated by collection-level processing of data access, partitioning and index isolation.

https://www.couchbase.com

The company’s Version 5.12, brings together a range of components that essentially creates what officials called a “step over the threshold” from Datadobi’s DobiMigrate — a data migration solution — and DobiProtect (data protection) and into a complete data mobility engine that can address the scale and challenges inherent in large storage environments. The goal of the vendor-neutral data mobility engine is to give enterprises the means for managing unstructured data including images, videos, audio, emails, texts, social media content, spreadsheets, streaming data, and data from Internet of Things (IoT) devices.

Databobi engineers reworked the file access layer, enabling the engine’s NFS and SMB file access layers to focus on data copying and file system integrity verification in both the data center and the cloud, which tend to house products from myriad vendors. They used low-level optimizations in the NFS and SMB stack to drive more efficient data and metadata processing through pipelining of the protocol communication and parallelizing file access workloads across multiple servers. The engine comes with what the company dubs its Integrity Enforcement Technology layer, a chain-of-custody technology that makes vendor-neutral data mobility more reliable and improves the preservation of data and metadata integrity.

https://datadobi.com — (via Enterprise Storage Forum)