DSharp Engine Version 4.0 released

We are excited to announce the latest version of our D# Engine, version 4.0. With this new release, we have added some major new features that will take the tool’s capabilities to the next level.

One of the most significant new features in version 4.0 is the support for Microsoft Synapse Analytics. Specifically, our tool automatically handles table distribution and selects the best indexing model for each table using the exact same metadata our users have been using for years. This integration provides a seamless experience for users who want to utilize Microsoft Synapse Analytics, making it easy to access and analyze their data in the cloud. Synapse works extremely well with large data masses, so bigger organizations will welcome this new possibility.

In addition to the Microsoft Synapse Analytics support, version 4.0 also includes extended source data mapping functionality. This allows users to easily map their data from various sources in a more flexible way than before. For example, the users can now map several source tables within the same schema to the same class, split denormalized data to several classes and map the same source column to multiple attributes. This enhancement greatly simplifies the development process and data integration, further streamlining the development process by replacing yet more manual work with automation.

Another important feature of version 4.0 is the ability to generate partial solutions if parts of the model fail validation. You can restart the Data Vault generation process even though some classes have failed verification. The failed classes will internally be marked as non-implementable before starting the process. This allows users to continue working with the deployment, even if another part of the model contains errors.

We are confident that these new features will greatly benefit our users and help them extend the use of the D# Engine. If you’re interested in trying out D# Engine version 4.0, contact us and we’ll set up a meeting.

We appreciate the support of our users, and we look forward to continuing to improve D# Engine.

See full release notes here.

Check out the recording of our release webinar (in Finnish) here.

I’ve been with DSharp for just over a year now and we have had the time of our lives! During 2022 almost all our company functions have taken a big leap forward. We have gained many new customers and worked on tens of projects with our current customers and partners. The vibe in all business areas has been very good. A new investor committed to our growth and we became a fully independent company! We also hired a new Business Development Lead, Konsta Weber, to take us international. 

Overall the interest in our unique way of building low code (or even no code!) data warehouses has been great and is increasing. Our public training courses have been fully booked almost every month and additionally we have given seminars and workshops as well as been leading business modeling projects. Efficient collaboration between management, business representatives and Data professionals is one key to success. Professional services have been record high, we have helped customers and partners with data warehouse architecture, POCs and data warehouse optimization. I’m happy to say that all this has led to having our monthly license revenue doubled during the year! 

Our main product, D# Engine, has been receiving well-deserved attention. We published four new versions this year, three of them minor releases and one major release with our first open source target database support, PostgreSQL. Now we are publishing another major version, 4.0! This includes full support for Microsoft Azure Synapse dedicated pool with automatic distribution and index selection. This version concludes our full support for the Microsoft ecosystem, and now we can deploy the data warehouse to an on-premise SQL Server, Azure SQL database (all versions) and Azure Synapse dedicated pool, all based on the same conceptual model. And any migration between these is done just by pressing one button! This is also true for PostgreSQL. 

Stay tuned! During 2023 we will continue growing and we have exciting features in the pipeline! Creating, extending and maintaining a data warehouse has never been easier! 

I want to thank all of you – customers, partners, developers, everyone – for everything we have done together! Cooperation with all of you has been really good and fun! 

I wish you all a Happy New Year and see you next year! 

Best regards, 

Tero-Matti 

DSharp Engine on the Microsoft Azure Marketplace

The DSharp Engine can now be found on all Microsoft’s marketplaces: Azure Marketplace and AppSource.

– The cooperation with Microsoft has progressed to the point where we can take our software to the world together with them. As a cooperation partner, Microsoft brings the necessary credibility in the international market, Konsta Weber, business development lead, describes the importance of the step.

The listing process involved several meetings with different Microsoft representants. Microsoft has a well-designed path for entering the marketplace so once the first more tricky steps had been taken the process continued smoothly.

Microsoft AppSource is a place to find business solutions. Microsoft Azure Marketplace is designed to be used by developers. As the DSharp Engine serves both business users and developers it is suited to be present in both Marketplaces.

DSharp has worked with Microsoft for a long time. The databases we support in Azure are Azure SQL Database and Microsoft Synapse Analytics. We also support SQL Server Databases for on-premise implementations. Taking DSharp Engine to the marketplaces was a logical next step.

In the future we aim to deepen our collaboration with Microsoft in co-selling and offering a wider range of products in Azure.

Beginning to sell our solution through Microsoft on its Marketplaces brings us new opportunities to expand our international sales.

Links to the Marketplaces:

Microsoft Azure Marketplace

  • The DSharp Engine is listed in the Azure Marketplace here

Microsoft AppSource

  • See DSharp’s company page on the Microsoft Azure Marketplace
  • The DSharp Engine is listed in Microsoft AppSource here
Järvenpää

The city of Järvenpää is now able to produce reports quickly and cost-effectively from different information systems. The information has been harnessed even better for decision-making and it is also planned to be shared openly with the municipal citizens. DSharp worked together with Netum on the data platform project for Järvenpää.

Business modeling in focus

Data warehouse automation played a key role in the development of Järvenpää city’s knowledge-based management. At the heart of data warehouse automation was the concept modeling done by DSharp. When the data warehouse is built model based, no one has to code it. According to, Tero-Matti Kinanen, CEO of DSharp, the city of Järvenpää has understood very well what agile development means.

– The city of Järvenpää has put ready-made reports into use and in this way has been able to immediately enjoy the results of the work. Significant benefits from data warehouse automation have been obtained at a fast pace, says Tero-Matti Kinanen

Business benefits have always been the red thread of the work.

– Business modeling has played an absolutely central role in the fact that the city of Järvenpää has risen to the forefront of the municipal sector in knowledge management, says Kinanen.

Read the full story in Finnish here on Netums web page.

DSharp engine 3.2

The new version 3.2 of the D# Engine brings direct database connectivity. You can now connect to source and target servers using native drivers when connecting to Microsoft SQL Server variants and ODBC otherwise.

Use the new Servers tree view to browse the contents of the registered database servers.

You can also import the table structures into new mapping files from here, which makes mapping easier than before.

The Source-data-to-Model-element mapping process is now inside the D♯ Engine. You can use the familiar spreadsheet layout to edit and create the mappings inside the D# Engine. In the new version it is also possible to create mappings by dragging and dropping from the Server and Conceptual model hierarchies, either row by row or in larger batches which greatly simplifies the mapping process.

The Data Grid is updated. It now has the same syntax-aware SQL editor as the SQL pane. The user can click anywhere on any class or data object, real or virtual, to browse its data. For classes and generated tables and views, it queries the data from the SQL Target server, which can be set in the Properties of the database server. For real server objects it shows the content of the actual clicked table or view.

Version 3.2 was released on the 30th of September. Data Platform Developers with access to the community pages can read the full release notes here. We will continue to publish 1 release per quarter. Revisions may be published more frequently. Stay tuned for our year end version v.3.3; we have some amazing stuff in the pipeline.