Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Thinkwise Platform
News & Blogs

News & Blogs

News and blogs on our products, services, and events

152 Topics
305 Replies

When you subscribe we will email you when there is a new topic in this category

152 Topics

Most replies

Most views

Newest first

Anne BuitCommunity Manager

published in News & Blogs

Switching from SSMS to Azure Data Studio - Tips & TricksBlog

SQL Server Management Studio has been the backbone for writing queries and managing SQL Server databases for a long time now. I’ve been using SSMS for well over a decade.A new kid on the block - Azure Data Studio - is gaining popularity. This IDE has been around for a couple of years now and is a close relative to Visual Studio Code. And with the possibility of plugging in extensions such as GitHub Copilot, I’ve recently completely switched to Azure Data Studio.In this blog, I’ll highlight some of the features of Azure Data Studio and suggest some key binding changes which I did make the transition from SSMS to Azure Data Studio easier. Familiarize yourself with F1Not unlike Visual Studio Code, virtually all commands, actions and settings can be done in Azure Data Studio via the F1 menu. If you want to do something and you don’t see a button - always press F1.The F1 menu of Azure Data Studio Tab display sizeThis may be a personal preference - I always ensure tabs are back to their orig

437911

4 days ago

Arie VCommunity Manager

posted in News & Blogs

Succesful pentest of the Thinkwise Platform (Q4 2024)

To ensure both ourselves and our customers that the Thinkwise Platform is secure, our Cybersecurity partners regularly perform pentests. We are happy to share that the pentest performed in Q4 2024 has resulted in 0 High/Medium identified risks (as classified by the OWASP Risk rating methodology). 1 Low risk has been identified on changing the Password policy, for which we would like to provide some guidance below. If you would like to receive a Third Party Memo of the pentest report (it’s in Dutch), please contact your Account Manager.Use latest ReleasesWe strongly recommend you keep your Thinkwise Platform up to date with the latest Releases of our products, as these are the most secure versions available. Also make sure to install all available Platform improvements (hotfixes) on a regular basis.Password policyBy default the Minimal password strength is set to the recommended 5/5 for Users with authentication type IAM. If this is not the case in your environment, we recommend you cha

610

23 days ago

Remco KortThinkwise blogger

published in News & Blogs

Getting started using web connectionsBlog

In today's interconnected world, seamless communication between applications is essential. But how can you efficiently integrate these connections into your Thinkwise application? The answer: web connections.Web connections provide a streamlined way to model APIs and their endpoints consistently, reducing complexity and minimizing code. In this video, I'll walk you through the process of setting up your first Web connection, making integration easier than ever.

1413

1 month ago

Mark JongelingAdministrator

published in News & Blogs

Tags in the Software FactoryBlog

Hi everyone,In every day life we encounter all kinds of tags, like in the store where we find price tags. These tags are essential for you to know what the price of a particular product is, but it also tells you whether or not the product is actually for sale and not there for decoration. Nowadays more and more price tags are shown on a smart display and can show the percentage of discount or other information. Tags in essence can hold important information.But hey, we’re developing software here. Tags can also be significant for your software. The Software Factory allows you to define your own tags that you can link to many model entities. Here’s what our Documentation page says about tags:A tag is a freely definable property that can be linked to rows of a table and can be provided with a value. They provide information that is not available in the Software Factory's meta model.You can use tags administratively or in a meta control procedure (dynamic model) to manipulate your model.

590

1 month ago

Bart MetselaarUI/UX Designer

published in News & Blogs

Data density in the Universal GUIBlog

During our work on the Universal GUI Styling Update, we’ve had several discussions and deep-dives about topics like the form and grid suggestions of the Styling blog with some of you. In those meetings, and as an extra assignment, we investigated improving the data density of our Universal GUI. A common topic on the Community and during conversations is that predominantly the height of several components demands too much space.Our challenge from the perspective of UX is finding the balance between functional presented data and preventing a visual cluttered interface. We are in the midst of trying to reduce the height of components such as form fields and grid rows, but we also think that we have to look into other options, where data may be offered in a different way.Let’s take a look at the suggestions in order of expected impact. Grid elementsThe current Universal default row height is 36px. We want to bring that down to a default of 28px.On the left, the current Universal Grid (defa

2996

2 months ago

Jasper

published in News & Blogs

Customizing the Universal GUI using CSSBlog

We often get questions about customizing the Universal GUI, particularly the login page. We plan to offer several model-options to customize it in the future, such as the logo, colors, title text and background image, and to display maintenance messages, for example. But with the latest release of the Universal GUI, it is already possible to make these adjustments manually, using custom CSS! SetupStarting with the latest (beta) release of the Universal GUI it is possible to inject your own custom CSS to change the styling of various parts of the user interface.To get started, simply rename the custom.sample.css file in the public folder of the Universal GUI to custom.css. This file will then automatically be loaded by the Universal GUI. By renaming the file, it will no longer be overwritten with Universal GUI updates.Next, add your own CSS to the custom.css file and you’re off! CSS classesThe Universal GUI provides static CSS classes for a selection of elements, mainly on the login pag

144511

2 months ago

Robbert van TongerenThinkwise blogger

published in News & Blogs

Prevent lock escalations with merge statementsBlog

As we all know, merge statements are ideal for executing multiple actions in a single statement—an insert, update, and delete with one statement and one source query.This blog is intended to help you make a well-informed decision about when to use a merge statement and when it’s better to avoid it. There is no right or wrong choice, but be aware of the consequences of using a merge statement and the consequences of using separate statements.When using a merge statement, you must take into account that the source and target tables can be locked. These locks are larger than with separate statements due to lock escalation, which increases the likelihood of deadlocks. You can (partially) prevent this by using a CTE (Common Table Expression) to make the target table smaller, thereby reducing the size of the locks, and by placing the source table in a temporary table so that it doesn't cause a lock during the merge.For example:-- Collect data to mergeselect j.product_id , j.product_namein

650

3 months ago

Jasper

published in News & Blogs

Crystal Reports fails to connect

As of Windows Server 2019, Microsoft disabled the encryption protocols TLS 1.0 and 1.1 by default, and requires all connections to, for example, SQL Server instances on Windows Server 2019 to use TLS 1.2. This can cause problems with Crystal Reports documents that use the default SQL Server drivers included with Crystal Reports, instead of the Microsoft OLE DB Driver.To resolve this, you need to replace the drivers used by each report with the latest Microsoft OLE DB Driver for SQL Server, which you can download here. To update the driver in the report file:Open the Set Datasource Location dialog from the Database menu in the Crystal Reports designer. Select the connection to replace and click Make New Connection to create a connection using the Microsoft OLE DB Driver for SQL Server or select an existing MSOLEDBSQL connection. Do not use the Microsoft OLE DB Provider for SQL Server (SQLOLEDB). Select Update to replace the connection.Repeat this for all Crystal Reports files. An altern

32263

3 months ago

Marit BlomThinkwise blogger

published in News & Blogs

Thinkwise Summit 2024 - October 2, 2024Event

Join us for the fourth annual Thinkwise Summit on October 2, 2024! This year, we’re embracing the theme 'Innovation Without Compromise' - empowering you to drive IT innovation effortlessly and precisely the way you envision it. The event will be hosted in Dutch. We’ve designed two specialized tracks: a business track featuring inspiring sessions and real-life case studies, and a tech track with deep dives into technical topics. Register now for the Thinkwise Summit 2024 on October 2 at Orpheus Apeldoorn. Button: https://www.thinkwisesoftware.com/nl/thinkwise-summit-2024?utm_source=Thinkwise_Community&utm_medium=blog&utm_campaign=Summit Why attend? Session Highlight: From GUI to LUI! From Screen to Voice! Imagine interacting with your enterprise data not through a screen, but with your voice. Sounds like a distant future? Join us at the Thinkwise Summit and discover U.T.A., a revelation that will transform your ideas about the future of data interaction. Networking Opportuni

1731

3 months ago

Jasper

published in News & Blogs

Upload multiple files using the Universal GUI

There is a lot of demand from the Thinkwise Community for easy uploading of multiple files via the Universal GUI; see this idea for example.For the Web GUI, @Harm Horstman developed a great solution that leverages a custom upload page in a preview component, but unfortunately this solution is less suitable for the Universal GUI as it bypasses Indicium and requires a separate application to be installed on the web server.Fortunately, it is relatively easy to develop a similar component that uses the Indicium API to upload files and integrate it in the Universal GUI. In this blog post we'll show you how to do that. Click to enlargeConfiguring the preview componentTo display a custom component in the Universal GUI, we use the preview component as described here. In this preview component, we will display a URL pointing to our custom HTML page that contains the upload functionality. The first step is to model a screen containing the preview component. To do this, we create an upload table

156325

3 months ago

Remco KortThinkwise blogger

published in News & Blogs

Natural language search using generative AIBlog

Search is one of the most used functions of any software application. But there are many ways to implement it. In this video I want to highlight a new way of implementing search using the large language model embedding integration that the Thinkwise Software Factory provides. This allows users to search by using natural language.

3844

4 months ago

Erik BrinkModerator

published in News & Blogs

Grid task linksBlog

In my previous blog I made a promise that more possibilities would soon come available to start task actions from the grid component, so here we are with the next one. The grid component of both the Windows and Web GUI now supports translated links to execute a task with.The idea is to create a better user experience by placing important tasks of a subject at a more intuitive location, so the user can find it more easily. Also, this will require less clicks to get the required task executed on a (inactive) record so users can do their work faster. You can choose to execute a process flow after the task execution to guide the user through a series of actions. Let's see how we should configure the Software Factory to use those links: Two model extenders are used to assign a related task and translation to a domain of the column containing the task link. To let the GUI know this column is a “task link”, we added a new control type “task_link” to the domain.This domain should be assigned t

4828

4 months ago

Frank Wijnhout

published in News & Blogs

Data modelling guidelinesBlog

Data modeling was originally intended as a tool for database design, but has become a fundamental requirements technique for business analists, as it is relevant for anyone working with data structures, application logic, user interfaces and business processes. The guidelines in this document aim to ensure that Software Factory developers set up high quality data models. High quality means: Consistent Logical Well structured Unambiguous This document has guidelines for the following subjects: Data modeling Diagrams in the Software Factory Data modeling To create well structured data models, a distinction is made between: Strong entities Weak entities An entity is strong when it’s existence does not depend on the existence of any other entity in a database. A weak entity depends on a strong(er) entity for its existence. In the following section Strong and Weak entities form the basis of most of the Guidelines. General guidelines The name

3882

4 months ago

Jasper

published in News & Blogs

Common DevOps integrations

The Thinkwise Platform is the core of professional DevOps ecosystems in many organizations. But in modern fast-paced development landscapes, it never stands on its own. Integration with specialized third-party DevOps tools is essential for automating DevOps workflows, gaining deeper insights, and expediting deployments.In this article, we highlight some of the proven DevOps-related tools and integrations that will help you streamline and manage the entire software development and operations process with the Thinkwise Platform. Many of those tools are also used by ourselves, for example for the development of the platform - which is itself a Thinkwise application - and the automated deployment of the ThinkLab environment.For an overview of integrations to improve and enrich your Thinkwise applications, check out this post.DevOps LifecycleFor each of the eight phases of the DevOps Lifecycle, we list the third-party DevOps tools that are either natively integrated in the Thinkwise Platfor

3301

5 months ago

Jasper

published in News & Blogs

Securely Deploy Your Thinkwise Applications

Ensuring the security of all our customers' applications is a foundational element of the Thinkwise Platform. To maintain the integrity and security of our platform components, we have regular penetration tests conducted by a third party, designed to identify potential vulnerabilities before they can be exploited. We are proud that no exploitable vulnerabilities have ever been found during these tests, reflecting our commitment to security. However, ensuring security does not end with the platform components. The infrastructure on which these components are deployed plays a crucial role in maintaining a secure environment. One key aspect of this infrastructure is the web server configuration. Even the most secure platform can be compromised if the underlying web server is not configured correctly. The Importance of Web Server Security HeadersAmong the critical elements of web server configuration are security headers. These headers provide an additional layer of security by controllin

2066

6 months ago

Edo SpijkerModerator

published in News & Blogs

Devexpress Reports concat function breaking changeNews

Hello all. We’ve previously upgraded our DevExpress component in the Windows GUI, Indicium, DevExpress Report Designer, and we want to inform you about a breaking change in the DevExpress component. Specifically regarding the Concat function.The DevExpress upgrade is included in our products starting from version 2024.1.13.0 (around April this year). This Concat function was only available and could only be used inside the DevExpress Report Designer. Previously, passing a null argument to this function would return an empty string. However, following our recent DevExpress update, this is no longer the case.The new behavior will not return an empty string when a null value is passed to the Concat function. This change may affect the output of your reports, potentially causing unexpected results if null values are involved.To ensure your reports continue to function as expected, we recommend reviewing and updating any code that relies on the previous behavior. You can find more informati

590

6 months ago

QuidoRookie

published in News & Blogs

Deployment with DockerBlog

In order to easily package, ship, and run applications as lightweight, portable, and self-sufficient as possible, there is Docker. Docker allows us to run applications virtually everywhere. Therefore this blog post gives some guidance on how Thinkwise applications can be containerized.There are numerous approaches in how you might want to set up your Docker environment, so we will mainly focus on:Running Universal independently; Running Indicium independently; Running Indicium and Universal together.At the end of this post, we will uncover our future plans and what we're currently researching/developing. PrerequisitesTo follow along, you'll need to have:Docker installed on your desktop or server (for Linux containers); Universal downloaded from TCP; Indicium downloaded from TCP.Please note that for certain scenario’s with Docker you’ll need a license. The Docker FAQ is a good source to read upon these questions. Scenario'sThe scenarios covered here can be followed separately. 1. Runnin

5124

6 months ago

Jasper

published in News & Blogs

Windows Security Update (KB5035853) errors

Hi everyone,The latest Windows security update (KB5035853) has been linked to instances of Blue Screen of Death (BSOD) errors for Windows 11 users. These errors can also occur when using the Thinkwise Windows GUI.More information here: Windows 11 Update Causing Serious Problems For Millions Of PC Users (forbes.com)For users who have not yet installed the update (KB5035853), it is recommended to postpone the installation until Microsoft releases a possible fix. For users currently experiencing BSOD errors or Thinkwise application issues after installing the update, we recommend uninstalling the update using standard Windows update uninstall procedures.Microsoft has acknowledged that it is investigating these issues and is expected to provide a fix in the near future.

95012

7 months ago

Jasper

published in News & Blogs

Common integrations with Thinkwise applications

The Thinkwise Platform offers a wide range of integration options, allowing you to connect your application to virtually any third-party application, tool or service.In many cases this can be done using out-of-the-box integrations: ready-made components, controls, and connectors to integrating with, for example, Microsoft Exchange, Maps, OpenID, AI and barcode scanning. For all other integration needs, the platform provides generic connectors that allow you to connect to web services or APIs, databases, cloud services, and more.We are often asked which integrations have already been realized by us or our customers, and whether there are any solutions that we recommend for specific use-cases. In this blog post we list a number of implemented integrations that are known to work well in combination with the platform.This article focuses on functional integrations with Thinkwise applications. In addition, the platform also offers many DevOps-related integration options to streamline the so

6721

8 months ago

Bart MetselaarUI/UX Designer

published in News & Blogs

The Thinkwise UX Hall of FameUX Panel

Dear Community,We had a blast at the Thinkwise Developers Event 2024! Great to see all your faces again.There were a lot of ideas presented to us, like the advantages of AI. We’ve also invited you to register for our UX panel:‘The Thinkwise UX Hall of Fame’.Many of you did! For those who could not attend or still want to register, click here to go to the registration form.By participating in our UX panel, we can contact you to cooperatively share ideas and opinions about the development of our products.This will be done by informing you, through this panel, about the newest features and designs of our products. This gives us the opportunity to invite you to, for example, interviews or brainstorm sessions about these features and designs, which allows you to provide feedback directly.We look forward to your input and feedback, so don’t hesitate to share your opinions!Kind regards,The UX Team

3100

8 months ago

EstherModerator

posted in News & Blogs

Knowledge Session: AI Integration in the Thinkwise Platform: Unveiling the Power of Process Flow Connectors

The next knowledge session is scheduled on Tuesday the 23rd of April, hosted by Theo Neeskens who will present about AI Process flows connectors.Welcome to an exciting journey through the latest release, 2024.1, packed with cutting-edge AI features within the Thinkwise Platform. Among these groundbreaking enhancements are:GitHub Copilot Integration Elevating your coding experience right from the Software Factory. AI Code Review Streamlining and enhancing your development workflow with intelligent code analysis. Upcycler AI Enrichments Empowering your applications with advanced AI-driven enhancements. AI Process Flow Connectors Unveiling the potential of AI within process flows.We'll explore each of these features briefly, with a very special focus on the AI Process Flow Connectors.Rather than diving into complex functional solutions, we'll provide practical insights into how you, as a developer, can leverage these connectors effectively.Through straightforward technical demonstratio

730

8 months ago

EstherModerator

published in News & Blogs

Thinkwise Developer Event 2024 - 18 April in AmersfoortEvent

We're excited to invite you to the Thinkwise Developer Event 2024 on April 18th at Van der Valk Amersfoort-A1 in Amersfoort. Expect a day filled with the newest features, opportunities to connect with fellow users, and practical sessions aimed at boosting your skills.Please click here for more details and to confirm your attendance.Schedule: 09:30 - 10:00 Walk-in 10:00 - 10:15 Welcome 10:15 - 11:00 Navigating the Next Wave of AI Innovation with Vincent Everts 11:00 - 11:15 Short Break 11:15 - 12:00 Unlock the potential of AI for your business 12:00 - 12:15 Short Break 12:15 - 13:00 Embrace Universal, starting today 13:00 - 14:00 Lunch 14:00 - 14:30 A Rapid Switch to Universal 14:30 - 15:15 Supercharge your Development with the 2024.2 SF 15:15 - 15:30 Short Break 15:30 - 16:00 Thinkwise Roadmap 2024 16:00

2441

8 months ago

Jasper

published in News & Blogs

[UPDATE] Apple's iOS 17.4 breaks Progressive Web Apps

UPDATEApple has reverted its decision and will continue to support Progressive Web Apps 🎉.Update on apps distributed in the European Union - Support - Apple DeveloperOriginal messageWith the latest beta release of iOS 17.4, Apple has restricted the functionality of Progressive Web Apps (PWAs) for users in the European Union. Apple claims that this change is necessary to comply with the Digital Markets Act (DMA), the European law that regulates the behavior of large tech companies and prohibits companies from giving their own products or services an unfair advantage over those of their competitors.To comply with the DMA, Apple now permits the use of alternative browser engines - other than WebKit - for dedicated browser apps and in-app browsing experiences with iOS 17.4. But instead of allowing PWAs to run in all these browser engines, Apple claims they have not been able to pull that off and were forced to disable PWA features altogether, including for their own Safari browser.So, onl

7382

10 months ago

Jeroen van den BeltAdministrator

published in News & Blogs

Detecting identical aliases in your SQL join- or where clauses

Hi all,Who hasn't experienced this? You're testing your SQL code, only to discover that you're getting more results than expected. In some cases, accidentally using the same alias within the same join- or where clause can lead to this scenario. For example, “where t1.customer_id = t1.customer_id”. This effectively creates a condition like “1 = 1”, which is always true.In this small blog, I'll guide you through detecting this situation throughout your branch's codebase. To effectively follow this blog, you'll need access to a code editor that has built-in support for regular expressions. If anyone knows a more efficient way to achieve the same results, please share it in the comments. Hopefully this helps!Software FactoryGenerate the code files using the Software Factory:Start up your Software Factory. Switch to the desired model and branch, for which you want to check identical aliases, by starting the task Models > Switch branch. Go to the screen Deployment > Creation. Generate

1052

10 months ago

Anne BuitCommunity Manager

published in News & Blogs

Drag-drop of recordsBlog

When I leave my house every morning, I pick up my car keys from the counter and put them in my pocket. To me, this is a very common way of interacting with an object. I grab the keys, move them into my pocket and let go of the keys. But when it comes to our software, this would happen very differently. I would select the Car keys record, put it in edit mode and change a field indicating the location from Counter to My pocket. I would then save the record and.. *Poof!* – The keys are now in my pocket. Very unnatural if you ask me. Editing the car keys? I sound like a locksmith! This new feature, however, will bring our applications one step closer to the real world: Drag-drop of records! Model-driven drag-dropAs with every feature, the definition of drag-drop is a part of the model. To keep things as easy and accessible as possible, no new logic concepts were introduced. The existing concepts of tasks and corresponding context logic are used. Besides that, variants play a bi

16087

11 months ago

Page 1 / 7

Badges

Arie Vhas earned the badge Superhero
Yara Visserhas earned the badge Geek
avanderveldenhas earned the badge Transcriber
Tim Waalewijnhas earned the badge Problem solver
sven.neuteboomhas earned the badge Geek

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login to the Thinkwise Software Community

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your email address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.