With our new function “SQL Data Warehouse” you can easily export all your stored infos from zistemo to a SQL database. This gives you the full control of your data and you can create every reports or chart you can imagine. Optimal for BI analysis with Tableau or Google Data Studio. This feature is exclusively for our “enterprise” users. We automatically update every hour the database informations. How the hourly sync works:
- Drop all tables from database
- Create tables
- Insert data into created tables
- Zistemo supports MySQL Version 5.6. or 5.7. See HERE, how to connect with MySQL 8.0;
- SSL connection is not supported
- Host field value is valid IP address or domain name
- Setup your firewall. Add IP 184.108.40.206 to allowed list
- If you have any issues with the permissions, please run this command:
GRANT ALL PRIVILEGES ON `yours_db_name`.* TO `yours_user_name`@`220.127.116.11`;
How to add the Integration
How to connect with MySQL 8.0
By default and for some reason, mysql 8 default plugin is auth_socket. Applications will most times expect to log in to your database using a password. If you have not yet already changed your mysql default authentication plugin, you can do so by:
- Log in as root to mysql
- Run this sql command: ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_passwordBY ‘password’;
Replace ‘password’ with your root password. In case your application does not log in to your database with the root user, replace the ‘root’ user in the above command with the user that your application uses.
Find also more infos HERE
Permissions for Users:
If you have any issues with the permissions, please run this command:
GRANT ALL PRIVILEGES ON ‘zistemo’.* TO ‘user_name’@’18.104.22.168’;
Change ‘zistemo’ to your given database name
‘user_name’ please change to your used username.
Cloud Applications recommendation (Data Base Storage)
If you want to test the service, we do have a recommendation, otherwise you can use any MySQL service you prefer. This is up to you.
Cloud Cluster: Is a Plattform where you can create a database platform for 6 months trial to test it
“Cloud Clusters is building an advanced and trustworthy Cloud Application Management Platform. We are dedicated to providing easy migration, management, and customization of cloud applications for the small and midsize businesses while ensuring rock-solid security and high performance.”
With Clou Cluster you can easily create an SQL Database and test a couple of months for free.
and choose Package for your needs – we do recommend “Express MySQL” to start.
You can find the credentials here:
1. The host
2. The port
3. The DB Name
Press “SAVE” and the connection is ready!
Bring the Data to Life
The next step is to get the Data into an BI (Business Intelligence) Solution. We recommend Tableau or Google Data Studio. You can also do whatever you want with your data 🙂 This is just an recommendation how to use it.
Here is a quick setup on the software “Tableau”:
1. Choose “MySQL” at the sidebar
2. Input your MySQL credentials as shown above
3. Inout your User credentials
4. Before you Login, you have to download the “MySQL” Driver. Please follow the instructions on the site.
After the successful installation/login, you need to restart tableau and connect/login again. SSL is not supported. In the next step you need to choose your Database:
As soon as your Database is loaded, you are ready to go. You can create any reports or charts you wish.