topic Re: Autonomouse Database as a source for Qlik Replicate in Qlik Replicate

Autonomouse Database as a source for Qlik Replicate

ititmatsuo — Fri, 01 Dec 2023 02:04:27 GMT

Hello,

Our procpect asked us if Qlik Replicate can support Autonomous Database (ATP or ADW) on OCI as a source.

Thank you.

Re: Autonomouse Database as a source for Qlik Replicate

SushilKumar — Fri, 01 Dec 2023 04:25:55 GMT

Hello Team,

As per Qlik help Document using Autonomous Database as a source for Qlik Replicate is yet not certified.

Replicate supports the following Oracle database editions:

Oracle Enterprise Edition
Oracle Standard Edition
Oracle Standard Edition 2
Oracle Express Edition

Information noteFrom Oracle 18.x, change capture from Oracle Express Edition is not supported.
Oracle Personal Edition

hope this helps

Regards,

Sushil Kumar

Re: Autonomouse Database as a source for Qlik Replicate

john_wang — Fri, 01 Dec 2023 04:30:26 GMT

Hello @ititmatsuo ,

Thanks for reaching out to Qlik Community!

Looks to me, ADW is supported as target endpoint ONLY.

Other Oracle Cloud support can be found in Oracle on Oracle Cloud.

Both ATP and ADW are not supported as source endpoint yet. Maybe you can give it a try, and We'd like to suggest you open Feature Request in Qlik Ideation Area to get PM team confirmation if you face any issues.

Hope this helps.

Regards,

John.

Re: Autonomouse Database as a source for Qlik Replicate

ititmatsuo — Fri, 01 Dec 2023 05:03:22 GMT

Hello Sushil and John,

Noted, thank you very much.
I could understand current situation and will discuss with our prospect.

Best regards,

Takuma Matsuo

Re: Autonomouse Database as a source for Qlik Replicate

Dana_Baldwin — Fri, 01 Dec 2023 15:41:44 GMT

Hi @ititmatsuo

Here is the link to our feature request website in case you need it: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Re: Autonomouse Database as a source for Qlik Replicate

iti-attunity-sup — Mon, 04 Dec 2023 01:06:22 GMT

Hello Sushil and John and Dana

Please let me check just to be sure about "Oracle on Oracle Cloud" in "Supported source endpoints".

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Support%20Matrix/supported_source_endpoints.htm#Supported%20source%20endpoints

I recognize that there are three types of database resources whichhave the Oracle Database as their backend in the Oracle cloud.
1. Base Database Service
2. Exadata Database Service
3. Autonomous Database

For 1 and 2, the database settings can be changed without any restrictions and administrator privileges can be used.
For 3, it is a full-managed service and some database settings cannot be changed and administrative privileges are not available.

[Question]
Does "Oracle on Oracle Cloud" in "Supported source endpoints" mean 1 and 2?

Best Regards
Nakagawa

Re: Autonomouse Database as a source for Qlik Replicate

john_wang — Wed, 06 Dec 2023 14:06:06 GMT

Hello Nakagawa-san, @iti-attunity-sup ,

Thanks for you update.

There are 7 databases services in OCI. Regarding the services:

1. Base Database Service
2. Exadata Database Service
3. Autonomous Database

Does "Oracle on Oracle Cloud" in "Supported source endpoints" mean 1 and 2?

You are right - Qlik Replicate does not support autonomous database (both ATP & ADW) as source endpoint yet. ADW is supported as target endpoint only.

Hope this helps.

Regards,

John.

Re: Autonomouse Database as a source for Qlik Replicate

iti-attunity-sup — Thu, 07 Dec 2023 00:41:56 GMT

Hi John-san

OK , I see. Thank you for you answer.

Best Regards

Nakagawa

Re: Autonomouse Database as a source for Qlik Replicate

john_wang — Thu, 07 Dec 2023 01:03:05 GMT

Hi Nakagawa-san,

Thank you for the feedback.

In the meanwhile I'm working with PM team and Documentation Team together to improve the documents related part, will keep you posted.

Regards,

John.