Page Comparison

To develop Play SQL as far as my users need, we need to convince stakeholders, such as banks, administrations and partners. One of the most frequently questions is "How many users do you have?". Atlassian Marketplace doesn't provide these statistics. To provide the best improvements, we sometimes need to know "Do people use feature X?". And to provide support and training, we need to get in contact with you to make you aware of the last improvements. This privacy policy is dedicated to limiting your privacy exposure and maximizing the benefits you get from the relationship.

CNIL

CNIL is the French regulatory body which ensures personal data privacy laws are dutifully applied.

The following policy is covered by the norm NS-48 (see details) and the file has been declared to CNIL. For any enquiry, the contact person is Adrien Ragot (see details below).

Channels of collection

The information collected by Play SQL comes from:

• The data Atlassian provides:
  • The data in the licenses created by the Atlassian Marketplace, including the biller's contact,
  • Statistics about downloads on the Marketplace,
  • Feedback emails when customers uninstall the add-on,
• The add-on's self-reporting feature:
  • Usage statistics can be deactivated before the first e-mail is sent (It is a step in the setup),
  • The add-on sends reports by email back to the author,
  • A report are sent after installation, then once a month.
• The information you provide:
  • The website and the documentation website use cookies, local storage and/or anonymous identifiers,
    • The documentation website uses Google Analytics based on Display Advertising (including Google Analytics Demographics and Interest Reporting),
    • Visitors can opt-out of Google Analytics for Display Advertising and customize Google Display Network ads using the Ads Settings.
  • When contacting the support or submitting issues, you inherently provide informations about yourself.

...

This is our privacy policy for all our apps and websites, as of June 26th, 2023. By using our products:

• You agree that your information may be used according to the following policy,

• You agree that your information may be used according to the Security Policy,

• You agree to the Terms of Use (for cloud products) or to the End-User License Agreement (for downloadable products),

• You agree that Atlassian is not responsible for the privacy, security or integrity of Vendor-Collected End User Data.

Contents:

What information we collect

We gather information through support cases. We also receive information from Atlassian through licenses ("Atlassian-collected end-user data"), Jira support issues, and from website tracking tools such as Google Analytics, Fullview, or other session-recording tools.

We host data created by users in our Cloud apps.

We don't collect any data when apps are installed by the customers on their own server, with the exception of the "feedback job" in Play SQL Base, explained in the table below.

How we use information we collect

We use the information in the following cases:to:

• Provide the service,

• Provide support for the software,

• Explain features and develop engagement about the software,

  Provide
• better services to all of our users, by spending more time tuning or developing the most used features, by developing extensions or new software,

  Balance the time we spend improving features which are used the most,

• We may use information in aggregated form (statistics, etc) for advertising,

• For accounting purpose, concerning billing information,

• For legal reasons, to protect the owner, the company, the software or when required by law.

This includes:

• Customers

  who create an evaluation

  with a license are

  subscribed by default to an "Evaluator Training"

  added to a mailing list

  which explains how to use the product week by week,
• When usage statistics show a problem on an instance, we may contact the customer to provide advice.

Information we collect

We collect information provided through the channels listed above, including:

• Contact details provided for the evaluation license:
  • Name and details of the technical and billing contact, type and dates of the license, name of the company, location.
  • Note that some information may not be necessary, but it is not possible to choose which fields are sent by Atlassian: Most often, we throw away parts of the information above, which is not relevant to us, as soon as we get it.
• From the self-reporting email of the product: Number of users, versions of Confluence and of the add-on, types of connections, statistics about the number of queries and spreadsheets and the usage of features, and the Server ID.
• From support activities: Name, email, company name, and information you provide explicitly.

How the information is processed - and how we share with partners

The information is processed on servers around the world. This may include servers which are not in your country of residence. In most cases:

• The web servers are located in France, Canada and USA,
• The Atlassian servers are not under our control,
• The author is based in France, so your data may be downloaded and processed on personal computers.
• We process your information using partners' services. We never sell or provide partners with permission to collect, use or sell your information. Our partners include:
  • Hosting: Amazon, 1and1, OVH,
  • The mailing list you get subscribed to: MailChimp,
  • Marketplace platform: Atlassian
  • Support: Twitter and Google Mail

We can't say whether we provide information to the NSA or the DGSE, but they surely take it anyway.

Deletion

Your information will not be kept longer than 2 years after the end of our commercial relationship. The data which may be used for legal reasons (in the event of a trial for example) will be kept as long as required by the law.

Access and correction

You have a right to access the personal information we collect and correct it. You may perform this right of access and correction by mail to:

Adrien Ragot
107 cours Gambetta
69003 Lyon

If you want to reduce your privacy exposure

• Deactivate the job in Confluence which sends monthly reports,
• Or encrypt your SMTP channel so the reports are sent securely to Gmail,
• Ask Google to opt out of their tracking (for example Ads Settings).
• Unsubscribe to the newsletter when you receive it

  to notify them about features of the product. They can unsubscribe from this mailing list.

What data is collected?

Data collected in the products

Atlassian defines:

• Atlassian-collected end-user data (basically, the license details)

• Vendor-collected end-user data, which we've split in 3 categories:

  • Data containing PII,

  • Other collected data, in normal usage (The free data that users create in the application - We only "collect" this data when you use Cloud products),

  • Data collected by the application when sending a support request (only for Requirement Yogi).

Atlassian is not responsible for the privacy, security or integrity of Vendor-Collected End User Data.

(1) As defined in Atlassian Marketplace Publisher Agreement, section §8.4: Generally the company name, country, address, technical email, licensing email, reseller details, license number, etc.

(2) Free text may contain PII if users have entered any.

(3) PII: Personally identifiable information (user names, email, phone number, etc).

(4) There used to be a feedback job in Play SQL Base and Play SQL Spreadsheets. This feedback job was removed in version 3.1.2 (see the history of this page).

What other data is collected?

• We have Google Analytics on some of our websites.

  • Google collects data about page views which is returned in a form that is not personally identifiable to us, notably aggregated by location, age, gender or demographic factors.

  • We do not engage in remarketing.

  • We have NOT enabled Advertising features in Google Analytics.

• We have mailing-lists, managed by MailChimp. Users can opt-in, out-out and manage their subscription by clicking on the link in emails.

• Users can get support through a Jira Cloud website, which is under Atlassian's privacy policy.

• Users can get support by email, in which case we manage our emails through FastMail.

How we share information we collect

Requirement Yogi is currently a sole-trader company (company type "SASU" in France) with:

• The founder, Adrien Ragot,

• If any employee or intern is hired, they sign a contract stating that they are strongly forbidden from leaking any information,

• Temporary contractors, hired for a specific time or project.

There are special situations where external people may have access to the data:

• In the situation where the company or one product is sold to a new owner: We sign a mutual NDA before the negotiation. Upon ownership transfer, the new owner takes responsibility for respecting or updating the current licenses and privacy policy.

• In the situation where someone illegally accesses our systems, we cannot provide control about your data,

• In the situation where we are compelled by law to provide this information, we cannot provide control about your data.

Here is what we allow:

How we host and transfer data internationally

Security

Please see our Security Policy.

How long we keep information

We try to delete data as early as possible, except for backups which we keep a little longer. 

Subprocessors, where we keep information, how it is transferred internationally

Anchor
our_providers our_providers

Anchor
subprocessors subprocessors

Our products are generally hosted by Amazon AWS and Digital Ocean, except our website which is managed by OVH, France. The computers we use to create software and access your information are located in France.

How to access and control your information

You have a right to access the personal information we collect and correct it. Most of the processes are automated:

• Concerning the "feedback job" of Play SQL Spreadsheets, you can disable it in the "Privacy Policy" tab of your add-on,

• Concerning the data that is sent for support cases, you are notified and you can send an email manually to us,

• Concerning the free data that you create in the Cloud apps, you can edit it in the application.

• Concerning backups, our Cloud products contain a "Backup" page which can be used to export your data.

Architecture and specific information for Requirement Yogi Cloud (Confluence and Jira) 

Anchor
specific_information specific_information

Accurate on February 15th, 2022:

• The app is deployed on Amazon AWS,

• This app is integrated with Atlassian using the Atlassian Connect Spring Boot framework. It is not an Atlassian Forge product. It means, when the user interacts with Atlassian Confluence and Jira where the app is installed, Atlassian notifies the app of changes, the app downloads the relevant information, extracts the necessary information and stores it in AWS.

• The app is deployed in EC2 in the AWS Region eu-west-1 (Ireland),

• The data is stored in AWS RDS Aurora Postgres, with encryption enabled, in the same AWS Region.

• The network allowing access to the database is a private subnet, and there is no direct route from the worldwide internet to the database itself,

• The logs are stored in AWS CloudWatch using the default encryption,

• The change events are stored in AWS CloudTrail,

• Employees under confidentiality agreement can access the live data in the database, the live servers, and the backups.

This information is subject to change in case of architectural change: if we decide to migrate the app to another provider, or if we decide to change databases inside of AWS, or if we decide to add/remove availability zones, or if we decide of another architecture. In any case, we will ensure that the data is encrypted at rest.

The data that the app stores is subject to constant changes depending on features we develop. For the moment, the data is:

• The key and body of requirements,

• The keys and titles of Jira issues,

• The page IDs, and sometimes the page titles and page body, specifically if there is an error and the support might need to investigate,

• Data which the users create in the app, notably reports they create, transformation templates, etc.,

• The userKey associated with changes, which is an anonymized identifier provided to us by Atlassian,

• The clientKey, which is the key of the instance, and its URL,

• License information provided by Atlassian,

• We only retrieve information made accessible to us by Atlassian or edit information that Atlassian allows us to, and we don't recoup this information with other sources.

Contact

If any process is not automated or you do not know how to exercise your rights, you may exercise them by contacting Adrien Ragot at:

How we update this policy

We may update this policy without notice, for the purposes of being more specific, reflecting a new practice or complying to legal requirements.

Change log:

• October 17th, 2023: Added Fullview, Google Tag Manager, Google Analytics 4,

• February 15th, 2022: Added Amazon AWS and Requirement Yogi Cloud, and removed cloud products which have been shut down. Added a specific section for Requirement Yogi Cloud.

• October 2nd, 2019: Added SpiderOak for our backups; Reflected the removal of support-requests-through-the-app features.

• January 29th, 2019: Rewrite, to comply with Atlassian's request for updated policies, to have one policy for all products, to be specific on the location of your data, and to reflect up-to-date information.

• September 11th, 2015: Add sections "What data we have", "Who accesses the data", "How we keep our servers secure", "How you can opt out" - see page history.

• November 11th, 2013: Rewrite, to go from generic statements to specific ones.

• October 2nd, 2013: Original version.

Application

Our Privacy Policy applies to all of the websites and software offered by us and our affiliates, but excludes services that have separate privacy policies that do not incorporate this Privacy Policy. It excludes services offered by Atlassian or any other provider.

When we receive formal written complaints, we contact the person who made the complaint to follow up. In case of dispute, we seek the best amicable resolution. We may work with appropriate regulatory authorities to resolve complaints. The privacy policy is governed by the laws of France, and, subject to the following sentence, in case of dispute, the parties irrevocably and unconditionally submit to the exclusive jurisdiction of the courts of Lyon, France.Our Privacy Policy may change from time to time. We will post any privacy policy changes on this page.