Answered

Compatibility of SQL Server 2022 in TARGIT

Carsten · October 19, 2022 13:37

At the Targit Copatibility Overview vor relational an multidimensional databases and Targit Releases there is still no entry for SQL Server 2022. I need to know what versions are compatible for SQL Server 2022. We have a release of our software which works in many installations together with TARGIT 2019 Update 3 right now.

Will TARGIT 2019 Update 3 be compatible with SQL Server 2022 or is it sure that this will not be supported or even testet?

Comments

16 comments

Sort by Date Votes

Thomas Veit October 19, 2022 13:58
In addtion, it would be great, if TARGIT would add also information of the compatibilty with Windows Server 2022
0
Ole Dyring October 21, 2022 08:29
Hi Carsten and Thomas.

Thank you for your input. We will work on getting our Compatibility overview articles updated asap.

So far I can tell that TARGIT 2022 is compatible with Windows Server 2022 and Windows 11.

BR / Ole
0
Ole Dyring October 25, 2022 10:29
And another update: TARGIT 2019 Update 3 has been specifically tested ok with SQL Server 2022 (on a Windows Server 2022).
0
Thomas Veit October 25, 2022 10:54
Perfect!
0
Thomas Veit January 12, 2023 14:19
Hi Team,

when will there the BIA Custom SSIS tasks for 2022 be available?

Kind regards

Thomas
0
Ole Dyring January 20, 2023 09:59
Hi Thomas,

Currently we have no short term plans for developing BIA / Custom SSIS tasks for SQL Server 2022.

BR / Ole
0
Ole Dyring January 26, 2023 13:59
Hi Thomas,

We are currently investigating options with regard to BIA / Custom SSIS tasks for SQL Server 2022.

In the meantime, it should be possible to move an existing BIA data warehouse to an SQL 2022 Server. The SSIS package may not run in the SQL 2022 environment (due to the incompatible Custom SSIS tasks) - however, the SSIS package may be kept running in an SQL 2019 instance on the same server, and feed data into the new SQL 2022 data warehouse.

BR / Ole
0
Niels Thomsen January 26, 2023 14:02
Hi Thomas

Can you specify which tasks you currently are using?

Period table, Quality check, Enumeration - or other?

br/Niels
0
Thomas Veit January 26, 2023 14:29
Hi Niels,

thanks for caring!

We are using the "standard" BIA tasks you mentioned!

Kind regards

Thomas
0
Thomas Veit January 26, 2023 14:38
... and sometimes the custom task for Excel-Import
0
Niels Thomsen January 26, 2023 15:15
hi again

I just tried to install the 2019 custom task and later run a very small job that utilized the period table task and delivered a period table in a database in a 2022 SQL Server instance?

Have you tried to install the 2019 version of the custom tasks manually and then move your etl script to the SQL 2022 instance?
0
Ole Dyring January 31, 2023 12:08
I have created a little guide on how to use the 'TARGIT Custom SSIS Tasks for Microsoft SQL Server 2019' in a SQL Server 2022 environment: https://community.targit.com/hc/en-us/articles/9066113652253-TARGIT-Custom-SSIS-Tasks-package
0
Thomas Veit January 31, 2023 12:19
Hi Ole,

thanks for this workaround. Does this mean, TARGIT doesn't develop a BIA solution for SQL 2022?

Kind regards

Thomas.
0
Niels Thomsen January 31, 2023 13:10
Hi Thomas

This is still up for discussion - will get back to you on that.

As I see it, it will be possible to upgrade customers with the knowledge Ole has provided - do you agree?

br/Niels
0
Thomas Veit January 31, 2023 15:43
As I see, the update of an existing BIA BC customer is possible, but I'm in doubt if this approach works for new customers/installations ..
0
Ole Dyring April 24, 2023 14:01
More on this:

We upgraded the Custom SSIS package.

So now you can install it directly in a SQL 2022 deployment environment.

The new "TARGIT Custom SSIS task for Microsoft SQL Server 2022" is available in the TARGIT Download Center, in "Other downloads".

https://portal.targit.com/Download-Support/Download-center

BR / Ole
0

Please sign in to leave a comment.