.svg)
.svg)
How Does the ETL for Reporting App Report Jira Changes?
Report Jira changes automatically with ETL rules, update database rows, and use technical columns.
Event triggered automatic reporting
Once a Data ETL rule has been created by the Jira Admin, the app starts the reporting of Jira changes based on these rules:
- If the end user creates an issue in a project matching the rule, the app inserts immediately a corresponding row in the reporting table
- Every custom or system will be stored as a column in the reporting table
- If the end user changes an issue in a project matching the rule:
- If the database row already exists, the app updates the reporting table
- if the database doesn’t exist, the app creates a corresponding row in the reporting table
When the rule is created and several issues matching the rule exist in the system, the admin can make a bulk change of the issue (e.g., add a Label and then remove it) to store all previous issues in the reporting table.
Created reporting tables
The tables created by the app should NOT be changed by DB Admins to ensure a correct operation.
The following technical columns always exist for every reporting table:
- id: technical IDs of Jira issues
- serverid: the unique Jira server ID
- vip_lean_ver: version of the app
- row_created: timestamp set by the app after creation
- row_updated: timestamp set by the app after update
Integrate your CRM with other tools
Venenatis sollicitudin posuere elit consequat et enim. Neque tortor amet dictum tempor. Leo facilisis aliquet viverra scelerisque eleifend viverra est. At massa erat vel amet enim laoreet dictum pellentesque. Urna cursus quam pulvinar tellus. Duis fermentum nibh volutpat morbi. Et ac sed ultricies ut nunc.
How to connect your integrations to your CRM platform?
Et urna ac et maecenas fusce amet. Nibh nec commodo massa sed. Tincidunt porttitor in pharetra egestas sit neque ac lacus. Amet a nunc et cum. Odio at volutpat volutpat in leo eget ipsum diam elementum. Erat magna arcu orci.
- Morbi fringilla molestie magna sed dictum. Praesent pharetra.
- Cras mi purus, viverra vitae felis sit amet, tincidunt fringilla lorem.
- Non mattis urna ex nec sem. Donec varius diam et suscipit.
- Quisque euismod posuere lacus sit amet volutpat praesent.
Quis faucibus massa sit egestas. Sit fermentum est ac pulvinar et sagittis sed sit ut. Quis faucibus aenean nibh vestibulum enim mi sit. Sollicitudin ultrices ultrices in ipsum urna fringilla massa leo. Sapien ultricies vitae rhoncus molestie purus. Urna urna dolor euismod porttitor et. Magna adipiscing dictum et adipiscing.
Quis faucibus massa sit egestas. Sit fermentum est ac pulvinar et sagittis sed sit ut. Quis faucibus aenean nibh vestibulum enim mi sit. Sollicitudin ultrices ultrices in ipsum urna fringilla massa leo. Sapien ultricies vitae rhoncus molestie purus.
Infotech is the next-gen CRM platform designed for modern sales teams
Cursus curabitur euismod vel fermentum sapien non dolor odio vel. Tortor lectus mauris in praesent a tincidunt nam. In aenean odio aliquet pretium viverra elit quis magna. Eget ut risus posuere velit purus nisi nec sollicitudin tellus enim.
“Sed id mi eget urna facilisis pharetra. Nunc viverra est at magna maximus consectetur. Sed nec maximus augue. Aliquam commodo sem eu.”
Cursus curabitur euismod vel fermentum sapien non dolor odio vel. Tortor lectus mauris in praesent a tincidunt nam. In aenean odio aliquet pretium viverra elit quis magna. Eget ut risus posuere velit purus nisi nec sollicitudin. Tellus enim interdum neque sit vestibulum lacus. Nam pulvinar a lectus justo aliquet.
Why using the right CRM can make your team close more sales?
Sed non quis tellus velit orci. Quam sed mauris elementum tempor viverra. Luctus semper risus ipsum id diam praesent. Pretium eget mauris ultrices curabitur sed sem amet. Erat nulla habitant in mattis massa mi adipiscing.
- Morbi fringilla molestie magna sed dictum. Praesent pharetra.
- Cras mi purus, viverra vitae felis sit amet, tincidunt fringilla lorem.
- Non mattis urna ex nec sem. Donec varius diam et suscipit.
- Quisque euismod posuere lacus sit amet volutpat praesent.
What other features would you like to see in our product?
Sed non quis tellus velit orci. Quam sed mauris elementum tempor viverra. Luctus semper risus ipsum id diam praesent. Pretium eget mauris ultrices curabitur sed sem amet. Erat nulla habitant in mattis massa mi adipiscing ullamcorper condimentum. Erat quisque integer tincidunt ac amet.