News & Blogs

News and blogs on our products, services, and events

  • 117 Topics
  • 160 Replies

117 Topics

Anne Buit
Administrator
Anne BuitAdministrator
published in News & Blogs

Lifecycle Policy for Runtime Components

The Thinkwise Platform allows applications to stay functionally and technologically up-to-date. This is at the core of our mission.Free the world of legacy softwareTo keep this promise, we must eventually remove support for runtime components that use aged technologies or architectures. While they are supported, they may hamper further architectural developments of the Thinkwise Platform and take up valuable development time. Support for modern deployment scenarios, operating systems, and browsers becomes difficult and ultimately impossible.Most importantly, as technology ages, it poses an increased security risk. For any technology, some vulnerabilities may be discovered. While these can be resolved quickly for modern technologies,  framework developers and component vendors eventually discontinue support for older technologies. This puts applications that use these technologies at risk. An application using the 2-tier Visual Basic 6 GUI. Support for this user interface was discontinu

1184
Anne Buit
Administrator
27 days ago
D
Moderator
Diana KuipersModerator
published in News & Blogs

Product updates/release notes have moved to their own spaceNews

Hello everyone,We have good news; the product updates (release notes) and hotfixes have moved to a place of their own! Of course, they still are a part of this community. But the new space offers the advantage of product selection. So, for example, if you wish to update the Universal GUI, you only need to select 'Universal GUI' for a clear overview of all its available releases and hotfixes.The area where you are now will remain dedicated to all other product news. So, keep your subscription here to make sure you will not miss out on the in-depth blogs about our services, products, and their features.You can find the area for product updates here. It now contains all the release notes and hotfixes, though we are still fine-tuning it. Don't forget to subscribe to the Product Updates!

1422
D
Moderator
7 months ago
Anne Buit
Administrator
Anne BuitAdministrator
published in News & Blogs

Introducing: AutoMLNews

One of the main goals for the Thinkwise Platform is to enable developers to focus on the functional aspects of software development instead of the technical aspects. To allow developers to leverage machine learning with minimal technical hurdles, we've added AutoML to the Thinkwise Platform in version 2020.2! Machine learning Machine learning combines software engineering with the field of mathematics and statistics to create algorithms that can learn from experience. To apply this in the field, data scientists use domain knowledge to apply these algorithms to create machine learning models that can make estimates and predictions based on the knowledge gained from experience. In applications built with the Thinkwise Platform, experience is often existing historical data. Machine Learning techniques in these applications are often leveraged for calculations that are difficult or impossible to express with regular code. Some examples include: Demand predictions over time Project cos

2634
Anne Buit
Administrator
8 days ago
Renée Evertzen
Moderator
Renée EvertzenModerator
published in News & Blogs

Coming up in the 2023.1: Temporal versioning of the Software FactoryBlog

Although the 2022.2 version of the Thinkwise Platform has only just been released, we already have big plans for a major change for the 2023.1. We are planning to store only the latest version of every project and move all old data to history tables.The main goal of this change is performance improvement by separating the operational data in the Software Factory from the non-operational data. A secondary goal is preventing massive amounts of unnecessary data from being stored.In the 2022.2 and earlier versions of the Software Factory the version control was handled by making a copy of a complete model in the shape of a project version. This resulted in largely the same data being saved multiple numbers of times, whenever a new project version or branch was created. Since the changes only make up a small percentage of the whole model, this unnecessary data caused the Software Factory databases to grow over time and becoming slower due to their size.The change that is intended is to star

1942
Kasper Reijnders
2 months ago
Erik Brink
Moderator
Erik BrinkModerator
published in News & Blogs

Asynchronous Task/Report executionBlog

Most of us probably have been in the situation where you wrote a time-consuming SQL stored procedure for a task or designed a report that takes a long time to create, knowing that your users will have to wait until everything is done before they can continue working in the GUI. The same goes for tasks or reports that are executed on multiple rows at once. Waiting for an hourglass to stop spinning is very boring so users will lose their patience and look for alternative ways to finish their work. You can put a progress dialog on it showing the users how long they will need to wait. But what if a task will take minutes or even hours? Maybe we would start multiple GUIs at once to split the work that needs to be done and visit the blocked GUI occasionally to watch the progress. We could lose some valuable time here not knowing exactly when the time-consuming action will finish exactly. How cool would it be when the user could simply continue their work after starting their action, and st

4121
B
Rookie
3 months ago
D
Moderator
Dick van den BrinkModerator
published in News & Blogs

Using OAuth to get data from external applicationsBlog

The Thinkwise Platform has powerful functionality to connect to external applications using OAuth. Customers often use external applications, for example a payment system. In that case they often want to import the data to the Thinkwise database, as the external system is their single source of truth. We can use the Thinkwise Platform to synchronize this data. With the support of system flows we can even automate this to automatically collect the latest data.In this blog I will use Exact Online as the external application to synchronize the projects from Exact to a database.Creating the data modelI made a very simple model for demo purposes. As a developer you can extract a lot more data from the API.The data model contains two tables, the oauth_token_info table to save the OAuth access and refresh tokens. The project table contains the information we will extract from the Exact Online API.Data modelApp RegistrationTo call the API first we need to register an application in Exact Onlin

60013
D
Moderator
3 months ago
V
Moderator
Vincent DoppenbergModerator
published in News & Blogs

Sign in with ... the choice is yoursBlog

IntroductionSince the release of version 2020.1 of the Thinkwise platform, the combination of Indicium and IAM forms a full-fledged authentication provider that implements the OpenID Connect protocol. This means that third party applications can authenticate their users through the Thinkwise platform. Starting with the next release of Indicium Universal (2020.2.9), the Thinkwise platform also supports authenticating its users through third party authentication providers that support OpenID Connect. This makes it possible to authenticate users through Azure Active Directory, Google, GitHub, Facebook and many other authentication providers.What is OpenID ConnectOpenID Connect is an industry standard protocol that allows for applications to delegate the authentication of users to a so-called Identity Provider. Common examples of Identity Providers are Microsoft, Google and Facebook. Whenever you see that button “Sign in with Google” on a website or an app on your smartphone, it means that

7094
Mark Jongeling
Administrator
4 months ago
D
Moderator
Diana KuipersModerator
published in News & Blogs

Monitoring Indicium live with Azure Application InsightsBlog

A lesser-known feature of Indicium is its capability to automatically log to Azure Application Insights. This service can be used for monitoring Indicium live. You can, for example, inspect failed requests, monitor response times, or investigate exceptions.Read the example below to learn how Azure Application Insights can help you in the development process. Especially when you don't have direct access to Indicium's error logs, having such logging capabilities is extremely useful. But even when you have direct access to the log files, the extra features offered by Azure Application Insights make it worth enabling it. Setting up Azure Application InsightsThis feature is enabled by default, but to use it, you need a paid Azure account with Application Insights enabled as a resource.Once you have everything set up in Azure, the next step is to find your Application Insights instrumentation key and add it to Indicium's appsettings.json.Instrumentation key"ApplicationInsights": { "Instrumen

2403
V
Moderator
5 months ago
Anne Buit
Administrator
Anne BuitAdministrator
published in News & Blogs

Revised creation and automationBlog

The Thinkwise Platform version 2021.3 has revised the way the Creation screen works, opening up more elegant ways to leverage tooling to automate this process.The generation screen consists of a number of steps:Generate definition Validate definition Generate source code Execute source code Run unit testsThis has remained unchanged between versions 2021.2 and 2021.3. However, the way these steps are performed has fundamentally changed.In the previous version, the steps in the generation screen were bound to a specific client. A developer would start Generate definition and the definition generation would be orchestrated start-to-end by the users client. This has served us well for many years, but there are some drawbacks that we’ve addressed in this release. The new Creation approachAll ‘jobs’ are no longer performed by a client, but are instead performed by Indicium. This means that generation, validation and such will continue even if the developer closes the screen or even the Softw

92323
Anne Buit
Administrator
6 months ago
F
Thinkwise blogger
Frank Wijnhout
published in News & Blogs

Create your own validationsBlog

Too few developers create their own custom validations and solely rely on the default validations offered by the Software Factory. Though this default validation set is already great for higher quality, there is always room for improvement, especially in certain situations.Developers tend not to make custom validations for several reasons:The functionality is unknown Development itself has more priority Validations are not being used at all Developers think creating a validation is difficultTo stimulate the use of custom validations, we created a video in which we show an example. We hope this motivates you to create your own validations. Create a custom Validation in the Thinkwise Software Factory   

1021
M
Sidekick
7 months ago
Robert Jan de Nie
Thinkwise blogger
Robert Jan de NieThinkwise blogger
published in News & Blogs

Check constraints using the Software FactoryBlog

In any application it is important to validate a user’s input.Is the value of the order smaller than the maximum order value? Is the start-date earlier than the end-date? Does this action lead to a stock amount smaller than zero?There are a few options how you, as a developer, can implement these checks:Domain (using min/max value) Default Trigger Check constraintA closer lookLet’s take the following example and work out if and how we can implement its validation:Is the start-date earlier than the end-date?Domain Validation through a domain is not possible in this case since we need to compare two values Default Clear out the end-date field and send a warning to the user informing that the end-date should occur after the start date Advantage: The user is being informed while the data is being entered. Risk: Business rule is only being enforced on the screens where the default has been implemented. When this data is created through other means, for example a task or external interfa

3820
Robert Jan de Nie
Thinkwise blogger
7 months ago
Sjors Niesten
Moderator
Sjors NiestenModerator
published in News & Blogs

Release notes Universal GUI (2022.1.11)release notes

The release notes have been moved to a new area: Product updates.Don't forget to subscribe there!

1080
Sjors Niesten
Moderator
7 months ago
Anne Buit
Administrator
Anne BuitAdministrator
published in News & Blogs

Performance troubleshootingBlog

At Thinkwise, we strive to make development and maintenance of enterprise applications as easy as possible. But in the end, an operational application will have a lot of moving parts. Performance troubleshooting comes down to identifying and resolving a problem in one of those many moving parts.Unfortunately, most of the time it ends up in a witch hunt. Kick in every virtual door to find out what causes the curse. This makes performance troubleshooting very time- and resource intensive. Today, I’ll share a very focused approach to resolve performance issues.The title of this blog might as well be: How to avoid the red herrings! Performance troubleshooting processThere are many ways to approach performance troubleshooting. This blog uses a certain script that can be used and adapted for your own needs. The script assumes a single, agile development team working on an application.The script for performance troubleshootingI’ll go into detail for all the steps, but I’d like to start off wi

4961
E
Moderator
7 months ago
D
Moderator
Diana KuipersModerator
published in News & Blogs

Release notes Windows GUI and Web GUI (2022.1.12)release notes

The release notes have been moved to a new area: Product updates.Don't forget to subscribe there!

560
D
Moderator
7 months ago
Anne Buit
Administrator
Anne BuitAdministrator
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 [i]Car keys[/i] record, put it in edit mode and change a field indicating the location from [i]Counter[/i] to [i]My pocket[/i]. I would then save the record and.. [b]*[/b]Poof![b]*[/b] – 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! [h2]Model-driven drag-drop[/h2]As 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 logi

7875
Anne Buit
Administrator
7 months ago
Jasper
Administrator
JasperAdministrator
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

6317
Jasper
Administrator
7 months ago
Quido
Moderator
QuidoModerator
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

2252
Jasper
Administrator
8 months ago
Jasper
Administrator
JasperAdministrator
published in News & Blogs

Thinkwise Ideation Insights 2021Blog

Your input and feedback are incredibly valuable to us. That is why we devote a significant part of our capacity to implementing the great ideas posted and voted on by our amazing community. But how many of your ideas are actually being taken up?In this post we want to give you some insight into the number of ideas and votes that we have investigated, worked on, and delivered in 2021.Quick statistics for ideasSome figures about the ideas and votes in 2021:61 ideas delivered 🚀 252 new ideas created 💡 563 votes delivered 🚛 2029 votes added 💗Since the start of the Thinkwise community in 2019, we have managed to deliver no less than 23% of all votes cast! And this percentage is still steadily increasing, as the great ideas keep coming in.So once again, a big thank you to everyone in the Thinkwise Community who shares ideas and votes for other customer ideas. We greatly appreciate the insights and feedback you give us about our platform.Thinkwise Community dashboardIdeas we deliveredThes

860
Jasper
Administrator
8 months ago
Mark Jongeling
Administrator
Mark JongelingCommunity admin
published in News & Blogs

Revised synchronization and deploymentBlog

Hi everyone,We previously explained how the Thinkwise Platform version 2021.3 revised the way creation and automation works.In the Thinkwise Platform version 2022.1, we also revised the way the Synchronization to IAM (Intelligent Application Manager) and Deployment package screens work, allowing for seamless integration in CI/CD tools that many have been waiting for.The Synchronization and Deployment processes are the final two processes that now have been made to fully run via Indicium and therefore can be initialized via Indicium's API. More on that later in this blog.In the previous version, the steps in these screens were bound to a specific client. A developer would start to Synchronize to IAM and the synchronization would be orchestrated start-to-end by the user’s client. This also applies for the Deployment package process. This has served us well for many years, but there are some drawbacks that we’ve addressed in this release. The new approachAll ‘jobs’ are no longer performed

1810
Mark Jongeling
Administrator
8 months ago
Anne Buit
Administrator
Anne BuitAdministrator
published in News & Blogs

Software Factory on Azure - Problem with json data typeNews

Update - jan-27The problem has been resolved.All new installations of the Thinkwise Platform will once again deploy properly on Azure databases.Platform upgrades from 2020.2 and up have been adjusted to not re-introduce the conflicting data type.Existing installations up until 2020.2 have a service fix available that will phase out the json user-defined data type.------------------------------------- An undocumented (or unintended) changeSomewhere around the start of this year, Azure has introduced a change to the managed SQL Server databases regarding user-defined data types. The change did not affect any existing databases but prevents deploying any databases which use a user-defined type named json as an Azure SQL Server database.The change has occurred overnight and we have yet to trace it back to a specific Azure Database update. So far, we have not been able to find any documentation regarding this change either. No versions of on-premise SQL Server databases seem to be affected

1434
Anne Buit
Administrator
8 months ago
Erik Brink
Moderator
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

3004
Erik Brink
Moderator
8 months ago
Jasper
Administrator
JasperAdministrator
published in News & Blogs

Which DB2 drivers should I use?Blog

The Thinkwise Platform provides extensive, out-of-the-box support for the DB2 for IBM i database management system for many years already. This is why we have a large number of customers that successfully use the Thinkwise Platform to modernize their legacy DB2 application landscape. This is also recognized by IBM, who named Thinkwise as Best IBM Business Partner of the Year in Europe in 2009, and awarded one of our customers with the Most Innovative IBM i User of the Year award because it used the Thinkwise Platform.However, IBM did (and still does) not make things easy for us.When we started, IBM was still in the process of replacing their Classic Query Engine (CQE) with the much faster and more powerful SQL Query Engine (SQE), and we have been in regular contact with IBM about bugs in these query engines that nearly drove us insane. With the necessary adjustments and bug fixes by IBM and some workarounds in the Thinkwise Platform, we were able to solve these problems, and the Thinkw

3281
A
Superhero
8 months ago
Anne Buit
Administrator
Anne BuitAdministrator
published in News & Blogs

Applications using Crystal Reports in Azure CloudBlog

The Thinkwise Platform supports various types of report generation solutions. The choice for a certain type of reporting has functional implications. For instance, not all reporting solutions support the usage of sub-reports. Other reporting solutions may offer more features regarding the use of SVG images or HTML markup.There are also non-functional aspects to consider. License costs is often noted. Another important aspect is the portability of the reports. Not every type of report can run on both Windows and Linux environments.Quite some research has gone into the portability of the usage of Crystal Reports lately. We’d like to share some of our findings in this blog.Runtime installationAdministrators who have deployed applications using Crystal Reports know that it requires the installation of the Crystal Reports runtime. Either on the desktop clients when the Windows GUI is used or on the web server when the reports are generated by Indicium, the Application Tier, or the Web GUI.A

4080
Anne Buit
Administrator
8 months ago
Mark Jongeling
Administrator
Mark JongelingCommunity admin
published in News & Blogs

Test System flow during Development by Indicium APIBlog

Hi everyone!,Often we hear developers wanting to test their system flows but not knowing what is an effective and quick way of doing so. This blog will help you out!To test System flows, we can make use of Indicium's Process flow API as described here: https://docs.thinkwisesoftware.com/docs/indicium/process_flows.htmlSince Indicium requires a POST request, some extra tooling is needed to send such a request. We commonly use either Insomnia or Postman, but alternatives are available online. For this blog, I'll use Insomnia.Creating a System flowStart of making or determining a system flow you would want to test.System flowFor my example, I kept it very simple. The Decision process action will run a process procedure to create a new record to the system_flow_table in my database.DesignControl procedureUsing InsomniaInsomnia is a powerful app what can do a lot, but for this example we'll create a new POST request.Start off by right clicking in the left panel (or use the shortcut Ctrl+N t

2212
Mark Jongeling
Administrator
9 months ago
Jasper
Administrator
JasperAdministrator
published in News & Blogs

Log4j vulnerability does NOT impact the Thinkwise PlatformNews

You have probably heard about the critical vulnerability found in the Apache Log4j library in the past few days, which is used by millions of Java applications for logging error messages. This vulnerability, CVE-2021-44228, is a Remote Code Execution (RCE) vulnerability that allows attackers to gain full access to a system.The Thinkwise platform does not use Java and is therefore not subject to this vulnerability.Thinkwise does advise its customers to check whether other applications or services use the affected library and to take appropriate steps to prevent abuse.At Thinkwise, we closely monitor the security of all third party libraries and components used in our platform, and notify our customers if any vulnerabilities are reported.

1480
Jasper
Administrator
9 months ago

Badges

Show all badges
Terms & ConditionsCookie settings