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

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!

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on Reporting.

Questions:

1. 02:42 - Will pivot table adjustments be added directly to reports?
2. 04:44 - Can the email attachment file name be dynamic?
3. 06:18 - How to filter import in Qlik Cloud Reporting?
4. 07:47 - How to set CC and BCC in Qlik Cloud Reporting?
5. 11:12 - What are best practices in Qlik Cloud Reporting?
6. 12:12 - Are there any special PowerPoint themes in Cloud?
7. 13:59 - How to develop visuals for PowerPoint in Cloud?
8. 16:12 - Will CSV exports be a new feature?
9. 17:02 - Any tips for fitting charts in PowerPoint?
10. 17:38 - How to customize the attachment timestamp?
11. 19:22 - Can Qlik Automate customize the timestamp format?
12. 20:36 - Is there an option to not send if there is no data?
13. 21:28 - How to define the recipient groups?
14. 23:42 - How to see what is on development on the roadmap?
15. 24:25 - How to migrate from NPrinting to Qlik Cloud?
16. 26:02 - How to make the file name dynamic?
17. 27:43 - Will it be possible to export to Google Sheets?
18. 28:50 - How to adjust the file size?
19. 31:26 - How to limit who can run reports?
20. 33:54 - Is there a guide for Pixel Perfect reports?
21. 36:12 - Can reports be triggered after a condition is met like alerts?
22. 37:00 - Is there documentation on using Qlik Automate for reports?
23. 38:48 - How to monitor reporting tasks?
24. 40:00 - How to schedule on the first workday of the month?
25. 41:15 - Will reporting block in Qlik Automate be updated?
26. 41:28 - How to filter recipients inside Qlik Automate?
27. 43:06 - Is there an ideal page size for visuals in PowerPoint?
28. 44:08 - Is there a guide for how to generate reports?
29. 46:20 - Can alerts be sent if a report fails to send?
30. 47:58 - How to limit who can run an automation?
31. 49:20 - Can Qlik Answers run reporting tasks?
32. 50:17 - Is Pixel Perfect a good alternative for reports?
33. 52:07 - Are there themes that are optimal for reporting?
34. 52:33 - Can we overlay multiple charts in the same space?
35. 53:59 - Can one report come from multiple apps
36. 54:55 - How to filter reports by recipients in Automate?

Resources:

• Qlik Ideation Portal
• Techspert Talks: Migrating To Qlik Cloud Analytics
• Creating report filters
• Creating a distribution list for your report
• Qlik Help: Reporting from Qlik Cloud Analytics with Qlik Automate
• Generate a report using Qlik Application Automation
• Limitations for reporting with Qlik Automate
• Best practices for in-application reporting
• Qlik Learning: Introduction to PixelPerfect Editor & Tabular Reporting
• Playlist: In app reporting with Qlik Cloud Analytics
• API: Get report request processing status
• Techspert Talks: Qlik Cloud Reporting Evolution

Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@Andrea_Bertazzo 

@Frank_S 

@Vinay_B