Hi everyone,

We are experiencing an OAuth 2.0 authentication issue when trying to connect Qlik Cloud Analytics to Salesforce using the Salesforce connector from Add Data.

A new Salesforce External Client App was created following Salesforce's recent security changes.

According to Salesforce's updated security requirements, PKCE is mandatory for newly created applications, and the option to disable it is locked.

However, the Qlik documentation instructs us to disable PKCE as part of the connection setup.

We attempted to configure the Salesforce Callback URL using both:

https://connector.qlik.com/auth/oauth/v2.htm

https://connector.qlik.com/auth/oauth/v3.htm

Both attempts failed during authentication, resulting in the following errors:

redirect_uri_mismatch

OAUTH_APPROVAL_ERROR_GENERIC

We would appreciate hearing from anyone who has encountered a similar issue or has successfully established a Salesforce OAuth 2.0 connection in Qlik Cloud Analytics under the new PKCE requirements.

Thanks in advance for sharing your experience!

Hello team,

I am looking to automate our consumption report export and would like to know if the following workflow is possible:

- Generate and save CSV files to Azure Blob Storage using Qlik Application Automation
- Ingest the data into Snowflake and visualize it in Qlik Sense or Excel

Could you please confirm if this process is feasible? If so, any documentation or guides would be greatly appreciated.

Best Regards.

Hi ,

I configured a notification in Talend Administration Center (TAC) with the category Tasks and the event On task failed.

The notification email is received correctly when Include log files is disabled. However, when I enable this option, the email is no longer received.

In the configuration shown in the attached screenshot, Compress in a single file is also enabled.

What could cause this behavior? Are there any additional settings or permissions required to attach the execution logs? Which TAC logs should I check to investigate the issue?
Or how can I include the task’s error message in the notification email?

Thanks,

Hello everyone,

my department and I are currently bulding a new BI-Department.

At the moment I'm loading the TABLES from SF into Qlik. But I also have usecases where I have to concatenate several Tables.

One Engineer pointed out to my, why we're not using the views. So I tried to find usecased where people are using views and where the tables.

Unfortunately we have nobody in our team who is experienced in this kind of topic.

Is here anyone who can help me?

Hi everyone,

I just published a new Data Voyagers video on Qlik Code, the Visual Studio Code extension that lets you edit Qlik Cloud load scripts in VS Code instead of the Data load editor.

I wanted to cover the whole thing in one place, so the video goes through each feature in order. Once you sign in to your tenant, you can browse spaces, apps, and scripts, then view, edit, and sync load scripts using direct or local editing. The editor supports the Qlik script language with syntax highlighting, completions, hover help, and diagnostics. You can also insert script content to load files from the data catalog or a data connection, or pull in existing script assets like QVS files. When you are ready to test, you can reload the app, preview your data, look at the data model, and open the app in Qlik Cloud from your browser.

A few limits from the documentation are worth knowing. Qlik Code is aimed at developers who already work in Qlik Cloud, and it does not replace the activity centers, so tasks like managing spaces, sheets, and app permissions stay there.

Watch the video here: https://youtu.be/8omcueKfuQ8

Documentation: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikCode/code-extension-home.htm

I would like to hear how this fits your workflow. Are you already writing scripts in VS Code, or still in the Data load editor? Which feature would you use first, and what is missing for you? Tell me in the comments.

Regards,

Mark Costa

Hi everyone,

When configuring a notification in Talend Administration Center (TAC), the Mails selection dialog displays users’ email addresses in the Login column, but the Email column is empty, as shown in the attached screenshot.

When creating a user in TAC, I enter the email address in the Login field. However, the user creation form does not show a separate Email field.

Is this expected behavior? Should TAC also display the login email address in the Email column, or is there another setting required to populate it?

How does TAC determine which email address to use when sending notifications to the selected users?

Thanks

Your analytics applications already hold years of business logic. Now, you can reuse that work by extracting a data product from an existing application, making it governed, reusable, and discoverable.

What it is

Extract data product from application creates a new data product from an analytics application you’ve already built. The data product includes both the application’s data and a semantic model of its relationships, dimensions, and measures.

Why try it?

The business logic you’ve already built can now do more. Extraction brings your application’s relationships, dimensions, and measures into a governed data product, giving them a shared, reusable home. This lets you use existing work, rather than recreate it manually.

Get started

Start with an existing application.

1. Open the application details or use the application’s contextual menu in the catalog.
2. Select “Manage > Extract and create data product”.
3. Name the data product, choose a space, and extract.
4. Review the log to see what was extracted.
5. Open the new data product and check its semantic model.

Your original application stays as it is, and you can keep using it.

To extract, the application must be in a personal or shared space, and you need the “Can edit data in applications” permission. Extraction runs a script that creates new datasets as data files in Qlik Cloud, so consider the size of your application first.

For the full steps, see Qlik Help | Extracting data products from analytics applications.

To learn more about semantic models, see Qlik Help | Semantic models in data products.

What to know before you try it

This capability is in Public Preview, and there are a few limitations to keep in mind:

• Applications that use section access are not supported.
• Applications in managed spaces are not supported. Move or copy the application to a shared or personal space first.
• Extraction doesn’t carry over cyclic and drill-down dimensions.

How to enable the preview

Feature previews must first be enabled for your tenant, and your tenant admin needs to grant you access via the “Feature preview” permission. If you don’t see Feature previews in your profile, check with your tenant admin, as described in Managing feature preview for your tenant.

Once you have access, go to your “User profile > Feature previews” and activate the “Extract data product from application” preview feature. See Feature previews for details on how the program works.

Share your feedback

Use the in-product feedback button, either in the Feature previews dialog or when clicking on the “Preview” badge available in the “Extract to new data product” dialog.

We’re especially curious about:

• How does the extraction flow work for you, and did you expect something different?
• How does extraction behave on larger or more complex applications?
• What did you expect to find in the data product that wasn’t there?

I'm pretty new to Talend Studio and building pipelines with it and I've got a confusing situation.

I need to pull the three main fields from an HTTP Response (headers, status, body) and store them in a database (for audit purposes).  However, I also need to dive into the body of the response (which will be Json), find a specific tag (a metadata tag), and capture two fields from this metadata tag.  With both outputs, I then need to combine it into one and save an audit record to a database.

I know how to work with either the tJavaRow (to get the header, status, and body fields) and the tExtractJsonFields (to get the metadata).  What I'm having an issue with is combining these two outputs back together and then saving it to the database.  Every route to do this seems either overly complicated (trying to do some Java package imports and writing even more custom Java code) or is just flat-out not allowed by Talend Studio because you can't tUnion or even tMap from the 'same source' back together.

Is there a simpler way to do what I'm wanting?  For example, my HTTP response might be:

{"headers": "someheaders", "status": 200, "body": { "meta": { "field1": "value1", "field2": "value2"}}}

And I need to capture it into my database like this

headers -> someheaders

status -> 200

field1 -> value1

field2 -> value2