topic Re: Attunity Studio in Qlik Replicate

Attunity Studio

Abhi- — Fri, 15 Nov 2024 22:45:59 GMT

I have used a produxt called Attunity Studio. Which was used to transfer data from mainframe to SSIS(Open system). Since Attunit is Qlik now. Can someone please tell what product in qlik correspond to Attunity Studio

Re: Attunity Studio

boaz_newman — Fri, 04 Feb 2022 08:59:10 GMT

You can use Qlik Replicate to transfer data from the MF.

For DB2 - Only Replicate is needed.

For IMS and VSAM you will need Replicate with ARC (which previously known as Attunity AIS, and Attunity Studio is part of it)

boaz

Re: Attunity Studio

RST — Tue, 12 Apr 2022 17:49:39 GMT

Qlik Replicate

Re: Attunity Studio

Bill_Steinagle — Tue, 12 Apr 2022 19:53:47 GMT

Hello,

With the end of service of the AIS (Studio) is the Designer tool for the Server Product there is a replacement Product called ARC Version 6.2 the Latest Version for (Studio Replicate for Z/OS IMS and VSAM, File Type Sources on Z/OS). There is currently no product currently that would be the equivalent for this SSIS(Open System) AIS Product.

Re: Attunity Studio

lyka — Tue, 12 Apr 2022 20:36:15 GMT

Hi Abhi,

Please let us know if any of the replies helped with your issue

Thanks

Lyka

Re: Attunity Studio

RD2 — Wed, 01 Mar 2023 16:17:27 GMT

Hello,

We are using Attunity on the IBM mainframe. I'm not sure what the name of the product is, but what it does is run programs that are defined in CICS. I used the Studio product to set those programs up. This was in 2011 and it has been kind of forgotten about, but we have one application that is still using it. We are upgrading our operating system and I don't know if the version I am running will be compatible with the new OS.

So, what is the name of the replacement products and what do I need to do to get current.

My name is Rick Davis and I work for US Foods.

Re: Attunity Studio

Barb_Fill21 — Wed, 01 Mar 2023 16:33:03 GMT

Hello Rick!

Per my colleagues' replies, if you are accessing VSAM files via CICS on the mainframe then yes we still support that capability.

For VSAM you will need Replicate with ARC (which was previously known as Attunity AIS, and Attunity Studio is part of it)

How else can we help you? Please feel free to ask.

Sincerely

Barb

Re: Attunity Studio

RD2 — Wed, 01 Mar 2023 17:02:37 GMT

Hi Barb,

Thanks for the rapid response! In your reply you mention accessing VSAM files through CICS. What I believe is happening is Cobol programs that are defined in CICS are being run, so its more of a message processing kind of function and not a direct read of VSAM files. But the original developers on the distributed side are long gone and apparently the source code is also gone so I'm not really sure how it works. I'm the mainframe person. We also have the VSAM capability but we never implemented it. I have attached a word doc with a screen print from Studio and a clip from the Attunity log on the mainframe. So moving forward I guess I need to know if this will run in Z/OS 2.4 we are currently at 2.2, and if not replacement products and costs.

Thanks again for your help.

Re: Attunity Studio

Bill_Steinagle — Wed, 01 Mar 2023 17:46:03 GMT

@RD2

Hi, as per the screen shots and doc attached this is the old CDC for SSIS, part of the AIS 5.3.2 running on Z/OS which is out of Service and I do apologize there is no replacement product at this time. If you are upgrading the OS and or Hardware I believe we can share a License for the AIS Solution but it is no longer in Service or Support. If you require such license please reach out and let us know.

Note: If you export the Bindings and Workspace to share we can confirm

Thank you!

Bill

Re: Attunity Studio

RD2 — Wed, 01 Mar 2023 17:59:01 GMT

Thanks Bill,

See attached, hope it is what you need. Yes, we are doing both software and hardware so we will need a license. Any other customer experience with OS upgrades?

Rick

Re: Attunity Studio

Bill_Steinagle — Wed, 01 Mar 2023 18:31:40 GMT

@RD2

Thank you as reposted this is the old AIS component which is not part of the ARC Solution. In order to provide a License for the End of Life product please see the below update.

One final step is to confirm how we are providing the end-of-life license. Would you please reply that you accept the terms below?

This license key is provided “AS IS” and without maintenance or support. Customer assumes all risks associated with the use of the key. Qlik has no liability or responsibility with respect to Customer’s use of the key. The key cannot be transferred by Customer.

Once you accept that we are providing the license “AS IS” and without the support, I will release the license file.

Thank you.

Bill

Re: Attunity Studio

RD2 — Wed, 01 Mar 2023 18:35:44 GMT

Hi Bill,

Thanks for the information.

I accept the terms below.

Rick Davis for US Foods

Re: Attunity Studio

Bill_Steinagle — Wed, 01 Mar 2023 20:19:03 GMT

@RD2

Thank you for the reply. Can you share your email for the License.pak file to be shared with you?

Thanks!

Bill

Re: Attunity Studio

Barb_Fill21 — Wed, 01 Mar 2023 21:06:37 GMT

Hello @RD2 ,

I am in the process of emailing the file to you.

Sincerely,

Barb

Re: Attunity Studio

nareshkumar — Wed, 17 Apr 2024 15:40:37 GMT

Hi Bill,

ARC CDC solutions are separate entity or part of Qlik replicate ? Do we have any other documents available for IMS DB2 CDC solutions from Qlik Replicate ?

Apart from Below :

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/AIS%20CDC%20Solutions/prereq_ais.htm#Prerequisites%20for%20using%20ARC%20CDC%20solutions

Re: Attunity Studio

nareshkumar — Wed, 17 Apr 2024 15:43:28 GMT

So Replicate and ARC or different components ? if So why ARC solutions are part of Qlik replicate documentation ? We just thought ARC is a 3rd party tool to be installed in mainframe side .. is it integrated with Qlik replicate .. please advise ?

Re: Attunity Studio

DesmondWOO — Thu, 18 Apr 2024 05:48:12 GMT

Hi @nareshkumar ,

ARC is Qlik's (Attunity) product. ARC is installed on the mainframe to capture changes and transmit them to Replicate. Currently, Replicate still needs ARC for some source endpoints e.g. IMS. For other source endpoint e.g. Oracle, SQL Server etc., we do not need ARC.

For this post, customer is using AIS (previous version of ARC). Replicate was not available during that period, so customer had to rely on other 3rd party tools such as SSIS and DataStage. The environment is like this:
- AIS captures changes and writes changes to the AIS's staging area.
- SSIS reads changes from the staging area and applies changes to the target.

Regards,
Desmond