Connect Securely to Your Data with SyncEzy's PowerBI Integrations: using SSL Connections

Connect Securely to Your Data with SyncEzy's PowerBI Integrations: using SSL Connections


In our continuous effort to provide robust and secure data access solutions, SyncEzy is thrilled to announce the introduction of SSL (Secure Sockets Layer) connections for our PowerBI integrations. As part of our commitment to ensuring the highest security standards for your data, we will be transitioning to SSL-only connections starting from 30th June 2024. This guide will walk you through the benefits of SSL connections and how you can seamlessly integrate them into your current workflow.

Understanding SSL Connections


SSL connections encrypt the data transmitted between your PowerBI application and SyncEzy's database, ensuring that your information remains secure and inaccessible to unauthorized parties. This encryption protocol safeguards your data integrity and privacy, making it essential for compliance with data protection regulations and internal security policies.

Benefits of SSL Connections


- **Enhanced Security:** SSL encryption protects your data from being intercepted by malicious actors during transmission.
- **Data Integrity:** Ensures that the data sent and received remains unchanged and free from tampering.
- **Compliance:** Meets the requirements of various data protection regulations, helping your organization stay compliant with industry standards.
- **Trust:** Encrypting your data transmission builds trust with your stakeholders by demonstrating a commitment to data security.

How to Enable SSL Connections in PowerBI


Given Below are the steps to enable data transfer over SSL for PowerBi integration between SyncEzy database and PowerBi application:

  • open PowerBi report for specific integration.
  • If SSL is not enabled in connection string and data sync is tried then below error will be encountered in PowerBi


  • click on "File" from top menu bar > click on "Options and settings" > open "Data source settings".


  • Now click on "Change Source .." at the bottom


  • add ";sslmode=require" in connection string at the end and click on "OK" button.




Steps to update password in existing PowerBi connection:

  • Click on "Edit Permissions ..." in Data source settings


  • Click on the "Edit" button in credentials sections


  • Copy new password from SyncEzy portal, paste in password input box and click on save button.




Notes

Password and ssl both can be updated at once.


1. **Update Your Connection Settings:**
   - Open your PowerBI Desktop.
   - Navigate to the "Data Source Settings" within the PowerBI interface.
   - Select the SyncEzy database connection and click on "Edit".
   - In the connection properties, ensure that the option to use SSL encryption is checked.

2. **Verify Your Certificate:**
   - SyncEzy provides a digital certificate that verifies our server's identity. Ensure that this certificate is installed and trusted by your system to prevent any connection errors.

3. **Test Your Connection:**
   - After enabling SSL and verifying the certificate, test your connection to ensure that data can be securely accessed without any issues.

4. **Adjust Your Firewall Settings:**
   - If you have firewall settings that restrict outbound connections, you may need to adjust these to allow SSL connections to SyncEzy's servers.

## Timeline for Transition to SSL Only


- **Immediate Effect:** SSL connections are available immediately for all users to ensure that you have ample time to transition.
- **Enforcement Date:** Starting from 30th June 2024, SyncEzy will enforce SSL-only connections for all PowerBI integrations. Non-SSL connections will no longer be supported beyond this date.


We highly encourage all our users to transition to SSL connections as soon as possible to take advantage of the enhanced security features and to ensure a seamless experience post-enforcement date. 

## Need Help?

Should you encounter any difficulties or have any questions regarding the SSL connection setup, our dedicated support team is here to assist you. Please reach out to us through the SyncEzy Helpdesk, and we'll ensure your transition to SSL connections is smooth and hassle-free.

Embracing SSL connections marks a significant step forward in our ongoing commitment to data security and privacy. We appreciate your cooperation in making this transition successful and look forward to supporting your secure data access needs.

    • Related Articles

    • Updating your PowerBi connection string to SSL

      We are transitioning to SSL-only connections for all our PowerBI integrations. This encryption protocol ensures that data transferred between your systems and our services is secure and inaccessible to eavesdroppers. Please ensure you switch to an ...

    • Introducing Password Regeneration for PowerBI Integrations

      Enhancing Data Security: Introducing Password Regeneration for PowerBI Integrations In the digital age, ensuring the security of customer data is paramount for any organization. With cyber threats evolving constantly, proactive measures are essential ...

    • KeyPay to PowerBI (One-Way) Integration FAQs

      This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com. General Questions How often does the sync run? The sync runs every night ...

    • simPRO - PowerBI Setup Documentation

      Introduction Below is a guide on how to connect your SimPRO account to PowerBI or any other BI tool through SyncEzy’s server. Note: SyncEzy has a template PBIX file available. You will need a subscription to the SimPRO-PowerBI Service on ...

    • Enhancing Data Security: Introducing Password Regeneration Feature in SyncEzy Portal

      In the digital age, ensuring the security of customer data is paramount for any organization. With cyber threats evolving constantly, proactive measures are essential to safeguard sensitive information. Recognizing this need, SyncEzy is proud to ...