Imagine you want to own a house, but you don't have a land and you haven't budgeted well for building materials and furniture. Instead of buying the land, building the house,laying pipes, and furnishing yourself, you rent a well fully furnished house where the landlord handles all the maintenance.
- The landlord: Aiven acts as the landlord
- The Apartment: Your Infrastructure
- The Advantages: You just move in (deploy your service) and enjoy the amenities. If the roof gets damaged(a server crashes) or you need more space(database scaling), Aiven fixes or upgrades it in the background.
Aiven - is a managed open-source data platform that provides databases, search engines, and streaming tools as a service. Allows users to perform real-time computation with SQL efficiently.
NOTE: Ensure you have the Postgresql and Power BI
STEPS ON HOW TO CONNECT AIVEN TO POSTGRESQL
1. SETTING UP AN AIVEN ACCOUNT
Log in into your browser and search for Aiven, click the result and you'll be directed to a landing page. Sign Up if you are a first time user and then proceed to log in with the credentials you have used to sign up with.
1. Click on any option according to what you want to use Aiven for.
2. Set up your country and Aiven gives you a default project name that you can customise according to what you want.
3. Click on explore Aiven for Streaming
4. Click on Services and choose Postgresql
5. Choose the tier you prefer and set region of your own liking and click on create service
6. Ensure the Service is running
2. CONNECTING POSTGRESQL TO AIVEN
Open DBeaver which is already configured to Postgresql.
Click CTRL+SHIFT+N or Click on new database connection on the top right corner of deaber.
Click the Postgresql and click next
_On the Prompt that is provided after clicking next(Connection Settings) follow the following steps:-
i) For the HOST: (delete localhost and replace with the Host name in Aiven in the connection information in step 6)
ii) Replace the Database name with the Aiven Database name from the Aiven connection information.
iii) Replace the port number with the Aiven port number from the Aiven connection information.
iv) Do the same for the Username and Password
v) Click on Finish_
NOTE: You are replacing the details with the details,
from the Aiven connection information from step 6 'Setting up Aiven Account'
3. CONNECTING TO POWER BI
Select data source and choose postgresql
For the Server enter : 127.0.0.1.5432(default for localhost server)
Database: postgres
Username: postgres
Password: Use the password that you set when installing postgresql
Finally finish and you are able to access the datasets in your local database.
NB: INCASE WHEN CONNECTING POWER BI TO THE DATABASE AND AN ERROR PROMPT ABOUT CERTIFICATE CONFIGURATION APPEARS
1. Download the SSL certifacte which is located in the connection information on Aiven.
2. Open the Manage Computer Certficate from your search bar.
3. Click on the Trusted Root Certification.
4. Right click on certificates and then choose all tasks and then import.
5. Change the file type to all files and select the SSL certificate you downloaded (a .pem file) and click on next until you finish.
6. Reload the Power BI and start the connection steps again.
Top comments (0)