Dashboards in minutes

Connect Sólides DP to Qlik Cloud Analytics: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Sólides DP to Qlik Cloud Analytics

Kondado offers a direct way to replicate your attendance records from Sólides DP into Qlik Cloud Analytics without complex technical setup or intermediate databases. Simply connect your Sólides DP account as a data source, select Qlik Cloud Analytics as your destination, and choose which employee information you want to visualize. Your attendance data flows on a configurable schedule, keeping your dashboards current with worked hours, employee details, and productivity metrics that help you manage your workforce effectively.

13
available pipelines
276
extractable fields
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial

Try out all the features for free for 14 days

With Kondado, you can replicate 153 fields from Sólides DP’s Daily Summary and Employees pipelines directly into Qlik Cloud Analytics, with automated refreshes as frequent as every 5 minutes to keep attendance reports current without manual exports.

Business teams use this connection to track workforce productivity, monitor overtime patterns, and analyze attendance trends across departments without writing code. By automating data replication, you eliminate manual spreadsheet work and ensure your Qlik dashboards always reflect the latest employee time records, enabling faster operational decisions and better workforce planning.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Sólides DP data available in Qlik Cloud Analytics

Each item below is automatically replicated by Kondado from Sólides DP into Qlik Cloud Analytics — no schema setup, no manual mapping.

13
available pipelines
276
extractable fields
∞
Auto-refresh

Available integrations

Daily Summary
Includes information such as worked hours, paid hours, and compensatory hours. Fields like id, employeeid, and isholiday help analyze employee attendance.
Employees
Contains data about employees, including name, email, and admission date. Fields like id, jobroledto__id, and birthdate provide essential details about each employee.
Time Clock Records
Employee clock-in and clock-out punches, one per row, with date and time, entry and exit geolocation, workplace, and adjustment and validation flags (fingerprint, facial recognition).
Time Adjustments (incl. vacations and leaves)
Time adjustments such as vacations, medical certificates, days off, and excused absences. Each row has the period, reason, employee, and approval status, useful for tracking justified absences.
Adjustment Reasons (incl. vacations and leaves)
Registered adjustment reasons, such as vacation, medical certificate, day off, and excused absence. This is the table that classifies time adjustments.
Job Roles
Company job roles, with description, CBO (Brazilian occupation code), and base salary.
Work Schedules
Registered work schedules (shifts), one per row, to compare the planned workday with the recorded hours.
Workplaces
Workplaces (departments and units), active and inactive, to analyze attendance and hours by unit.
Managers
Registered managers and their matching employee record, to build attendance analysis by team and leadership.
Companies (branches)
Registered companies (headquarters and branches, by CNPJ). Employees point to their company through the company__id field, so attendance and hours can be analyzed by branch.
Time Clock Rules
Registered time clock rules: tolerances, night hours, hour bank vs. overtime control, and hour bank percentages and limits.
Hour Bank (current balance)
Current hour bank balance for each employee at read time. The table is rewritten on every run, as a snapshot of the balance, without history.
Time Edit Justifications
Justifications available for manually editing clock punches, with the attachment and note requirements of each one.

Try out all the features for free for 14 days

With the Daily Summary pipeline, you can build Qlik dashboards that visualize worked hours, paid hours, and compensatory hours to identify overtime trends and attendance patterns across different teams and periods. The Employees pipeline brings essential workforce data including job roles, admission dates, and contact information, enabling you to analyze productivity metrics by department or tenure length. Together, these pipelines allow you to create comprehensive attendance reports that correlate time clock data with employee demographics, helping managers spot scheduling gaps, track holiday usage through the isholiday field, and optimize workforce allocation based on actual worked hours versus planned shifts.

Try out all the features for free for 14 days

How to create Sólides DP dashboards in Qlik Cloud Analytics

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Sólides DP to Kondado

Add Sólides DP as a data source by entering your account credentials and selecting the Daily Summary and Employees pipelines you want to replicate. Kondado will map the 153 available fields including worked hours, employee details, and attendance records.

2
Choose Qlik Cloud Analytics

Select Qlik Cloud Analytics as your destination to receive the Sólides DP data, choosing whether to send information to an existing app or create a new visualization workspace. This establishes a direct connection that eliminates the need for intermediate databases or manual file uploads.

3
Configure Refresh and Build

Set your data update schedule to run every 5 minutes, hourly, or daily based on your reporting needs, then build custom dashboards in Qlik analyzing attendance patterns, overtime trends, and workforce productivity. Your reports stay current as Kondado replicates new time clock entries on your configured schedule.

Access Sólides DP data in Qlik Cloud Analytics and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Sólides DP data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Sólides DP data in Qlik Cloud Analytics automatically

How do I connect Sólides DP to Qlik Cloud Analytics using Kondado? ▼
Start by adding Sólides DP as a data source in your Kondado account and authenticate with your credentials. Then select Qlik Cloud Analytics as the destination and choose the Daily Summary and Employees pipelines you want to replicate. Kondado handles the data transfer automatically, delivering your attendance records directly to Qlik without requiring database configuration or coding.
What attendance KPIs can I track in Qlik Cloud Analytics with Sólides DP data? ▼
You can monitor essential metrics like total worked hours, paid hours versus planned hours, compensatory time balances, and overtime frequency by department. The Daily Summary pipeline provides fields like employeeid and isholiday to analyze individual attendance patterns and holiday usage, while the Employees pipeline enables filtering by job role or admission date to track tenure-based productivity trends.
How often does Sólides DP data update in Qlik Cloud Analytics? ▼
You configure the update frequency based on your business needs, choosing intervals from every 5 minutes to daily or weekly schedules. This automated refresh ensures your Qlik dashboards display current attendance information without manual exports, keeping managers informed about workforce availability and time clock records on a near-real-time basis.
Can I share Sólides DP attendance dashboards with my team in Qlik? ▼
Yes, once your data is in Qlik Cloud Analytics, you can distribute reports to HR teams, operations managers, or department heads through Qlik's built-in sharing features. Your colleagues can view attendance trends, worked hours summaries, and employee productivity metrics without needing access to the original Sólides DP system or Kondado platform.
Do I need technical skills to replicate Sólides DP data to Qlik Cloud Analytics? ▼
No coding or database expertise is required to connect these platforms. Kondado provides a no-code interface where you simply select your data source and destination, choose your pipelines, and set your schedule. The platform manages the data replication process for you, making attendance analytics accessible to business users and HR professionals.
What is the difference between the Daily Summary and Employees pipelines? ▼
The Daily Summary pipeline contains time clock records including worked hours, paid hours, and compensatory hours for specific dates, perfect for tracking attendance patterns and overtime. The Employees pipeline stores static workforce information such as names, emails, job roles, and birthdates, which you use to enrich time records with employee demographics and organizational details in your Qlik analysis.
Can I send Sólides DP data to other tools besides Qlik Cloud Analytics? ▼
Yes, Kondado supports multiple destinations, so you can replicate the same Sólides DP data to Power BI, Looker Studio, or Google Sheets simultaneously. This flexibility allows different teams to access attendance reports in their preferred visualization platform while maintaining consistent data across your organization.

Try out all the features for free for 14 days