Yellowfin BI installation on Docker
Hello.
I want to do a Yellowfin BI fresh installation on a Docker (Yellowfin Application Only), and I created an empty database to receive the Yellowfin repository.
After that, I read the following texts:
Configuring Yellowfin for Containerization,
If I understood correctly, they all say more or less the same and we need an already existing repository database, before starting the Yellowfin BI installation.
Question 1: For customers installing Yellowfin for the first time. How can I create a repository database before installing Yellowfin on a Docker?
Question 2: I think I am not understanding the purpose of Yellowfin BI installed on a Docker. Is it mandatory to do, first, a typical installation of Yellowfin on a computer where the installer will create the repository database?
Question 3: If yes to question 2, Is supposed to connect Yellowfin installed on a Docker to that repository database?
Context: I have a client using Yellowfin BI, which is installed on a virtual machine. They want to move the application to a Docker in Linux. Before doing that, I am testing in my own PC. After reading about the necessity of an already existing repository database, I created a backup from an old repository database and restore it to the new database. After that, the Yellowfin was installed on the Docker. I was able to login, open the dashboards coming with the Tutorial, but the dashboard doesn't load any data (from the AdventurousWorks database).
Question 4: What could am I missing to get things working?
Question 5: If I do something similar in my client, Will I get the same problem?
Thank you.
Best wishes,
Tiago
The same question
Hello Tiago,
My name is Ankit Asati from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:
Ticket Number: #33074
Case Title: Yellowfin BI installation on Docker
Issue Overview:
Yellowfin BI installation on Docker
Request for Additional Information:
To better understand and expedite the resolution of your case, please provide me following details:
https://community.yellowfinbi.com/topic/how-to-get-the-info-jsp
Next Steps and Workarounds:
Based on the provided context, here are the answers to your questions:
Question 1: For customers installing Yellowfin for the first time, you need to create a repository database before installing Yellowfin on Docker. This involves setting up a database on a supported database server (such as PostgreSQL, MySQL, etc.) and ensuring it is accessible from the Docker container. You will need to configure the database connection details (JDBC driver, connection URL, username, and password) when setting up the Yellowfin App-Only Docker image.
Question 2: It is not mandatory to perform a typical installation of Yellowfin on a computer to create the repository database. You can directly set up the repository database on a supported database server and then configure the Yellowfin Docker container to connect to this database.
Question 3: If you have an existing repository database, you can connect the Yellowfin installed on Docker to that repository database. This is typically done by specifying the database connection details in the Docker environment variables when setting up the Yellowfin App-Only image.
Question 4: If the dashboards are not loading data, it could be due to several reasons:
Question 5: If you replicate the setup at your client, you may encounter similar issues if the repository database or data source connections are not correctly configured. It is important to ensure that all database connections are properly set up and accessible from the Docker environment.
For more detailed information, you can refer to the official Yellowfin documentation on installing in a container: Install in a Container.
Sincerely,
Ankit Asati
Yellowfin Technical Support Engineer
Hello Tiago,
My name is Ankit Asati from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:
Ticket Number: #33074
Case Title: Yellowfin BI installation on Docker
Issue Overview:
Yellowfin BI installation on Docker
Request for Additional Information:
To better understand and expedite the resolution of your case, please provide me following details:
https://community.yellowfinbi.com/topic/how-to-get-the-info-jsp
Next Steps and Workarounds:
Based on the provided context, here are the answers to your questions:
Question 1: For customers installing Yellowfin for the first time, you need to create a repository database before installing Yellowfin on Docker. This involves setting up a database on a supported database server (such as PostgreSQL, MySQL, etc.) and ensuring it is accessible from the Docker container. You will need to configure the database connection details (JDBC driver, connection URL, username, and password) when setting up the Yellowfin App-Only Docker image.
Question 2: It is not mandatory to perform a typical installation of Yellowfin on a computer to create the repository database. You can directly set up the repository database on a supported database server and then configure the Yellowfin Docker container to connect to this database.
Question 3: If you have an existing repository database, you can connect the Yellowfin installed on Docker to that repository database. This is typically done by specifying the database connection details in the Docker environment variables when setting up the Yellowfin App-Only image.
Question 4: If the dashboards are not loading data, it could be due to several reasons:
Question 5: If you replicate the setup at your client, you may encounter similar issues if the repository database or data source connections are not correctly configured. It is important to ensure that all database connections are properly set up and accessible from the Docker environment.
For more detailed information, you can refer to the official Yellowfin documentation on installing in a container: Install in a Container.
Sincerely,
Ankit Asati
Yellowfin Technical Support Engineer
Hello Ankit.
I sent to you info.jsp in attachment.
Thank you for your answers, but something is not clear in my mind, yet.
In a typical installation of Yellowfin, I create, first, an empty database. After that, I run Yellowfin installer and set up the required configurations. At some point, the Yellowfin installer ask me for the repository database. I select the type of database (MS SQL, My SQL, Postgresql, ...), and I write the name of the instance, the name of the database, username and his password (with write privileges to that database). During installation, the installer will create all tables and relations necessary to Yellowfin BI work properly.
What I still don't understand is what happens during a Yellowfin installation on a Docker environment.
Question 1: Is it equal to a typical installation of Yellowfin?
Question 2: The repository database can be empty and then the installer will create the required tables and relations between tables during the Yellowfin installation on a Docker environment?
Question 3: Or the repository database must already contain the tables ans relations before running the Yellowfin installer?
Question 4: If yes to question 3, How can I create the repository database with the tables and relations necessary to Yellowfin run as expected?
Thank you.
Best wishes,
Tiago
Hello Ankit.
I sent to you info.jsp in attachment.
Thank you for your answers, but something is not clear in my mind, yet.
In a typical installation of Yellowfin, I create, first, an empty database. After that, I run Yellowfin installer and set up the required configurations. At some point, the Yellowfin installer ask me for the repository database. I select the type of database (MS SQL, My SQL, Postgresql, ...), and I write the name of the instance, the name of the database, username and his password (with write privileges to that database). During installation, the installer will create all tables and relations necessary to Yellowfin BI work properly.
What I still don't understand is what happens during a Yellowfin installation on a Docker environment.
Question 1: Is it equal to a typical installation of Yellowfin?
Question 2: The repository database can be empty and then the installer will create the required tables and relations between tables during the Yellowfin installation on a Docker environment?
Question 3: Or the repository database must already contain the tables ans relations before running the Yellowfin installer?
Question 4: If yes to question 3, How can I create the repository database with the tables and relations necessary to Yellowfin run as expected?
Thank you.
Best wishes,
Tiago
Hello Tiago
Thank you for your patience,
Request if your once go through this detailed yellowfin docker installation. It is detailed step by step guide for installation
https://wiki.yellowfinbi.com/space/yfcurrent/2197839/Docker
Hope it helps!
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tiago
Thank you for your patience,
Request if your once go through this detailed yellowfin docker installation. It is detailed step by step guide for installation
https://wiki.yellowfinbi.com/space/yfcurrent/2197839/Docker
Hope it helps!
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tiago
I wanted to follow up with you regarding the information I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tiago
I wanted to follow up with you regarding the information I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Ankit.
I am not sure what request your are asking, besides the info.jsp. If you are talking about this file, I made it available in my previous post.
Thanks for the new link (https://wiki.yellowfinbi.com/space/yfcurrent/2197839/Docker). I read it and I could not find useful answers to my questions.
Note: The links in the end are dead.
Thank you
Best wishes,
Tiago
Hello Ankit.
I am not sure what request your are asking, besides the info.jsp. If you are talking about this file, I made it available in my previous post.
Thanks for the new link (https://wiki.yellowfinbi.com/space/yfcurrent/2197839/Docker). I read it and I could not find useful answers to my questions.
Note: The links in the end are dead.
Thank you
Best wishes,
Tiago
Hello Tiago,
Thank you for your patience,
Below are the answers to your questions regarding Yellowfin installation on a Docker environment:
Question 1: Is it equal to a typical installation of Yellowfin?
In a Docker environment, Yellowfin is available as a variety of images, such as the Yellowfin All-In-One image and the Yellowfin App-Only image. The installation process may differ slightly from a typical installation, as Docker uses container technology to deliver the software.
Question 2: The repository database can be empty and then the installer will create the required tables and relations between tables during the Yellowfin installation on a Docker environment?
Yes, similar to a typical installation, the repository database can be empty. The Yellowfin installer will create the necessary tables and relations during the installation process.
Question 3: Or the repository database must already contain the tables and relations before running the Yellowfin installer?
No, the repository database does not need to contain the tables and relations before running the Yellowfin installer. The installer will handle the creation of these elements.
Question 4: If yes to question 3, How can I create the repository database with the tables and relations necessary to Yellowfin run as expected?
Since the answer to question 3 is no, you do not need to manually create the tables and relations. The Yellowfin installer will automatically create them during the installation process.
For more detailed information, you can refer to the Yellowfin documentation on installing in a container: Install in a Container
Please let us know if it helps.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tiago,
Thank you for your patience,
Below are the answers to your questions regarding Yellowfin installation on a Docker environment:
Question 1: Is it equal to a typical installation of Yellowfin?
In a Docker environment, Yellowfin is available as a variety of images, such as the Yellowfin All-In-One image and the Yellowfin App-Only image. The installation process may differ slightly from a typical installation, as Docker uses container technology to deliver the software.
Question 2: The repository database can be empty and then the installer will create the required tables and relations between tables during the Yellowfin installation on a Docker environment?
Yes, similar to a typical installation, the repository database can be empty. The Yellowfin installer will create the necessary tables and relations during the installation process.
Question 3: Or the repository database must already contain the tables and relations before running the Yellowfin installer?
No, the repository database does not need to contain the tables and relations before running the Yellowfin installer. The installer will handle the creation of these elements.
Question 4: If yes to question 3, How can I create the repository database with the tables and relations necessary to Yellowfin run as expected?
Since the answer to question 3 is no, you do not need to manually create the tables and relations. The Yellowfin installer will automatically create them during the installation process.
For more detailed information, you can refer to the Yellowfin documentation on installing in a container: Install in a Container
Please let us know if it helps.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Ankit.
Thank you for your answer. It brings some light to this issue.
I have two more questions:
Question 1: Regarding your answer to "Question 2: The repository database can be empty and then the installer will create the required tables and relations between tables during the Yellowfin installation on a Docker environment?" - Is the answer valid for both cases (All-in-one and App-only)?
Question 2: Where are the instructions to install Yellowfin App-only in a Docker environment for an empty repository database? For example, https://wiki.yellowfinbi.com/space/yfcurrent/2196024/Install+in+a+Container has the instructions to install Yellowfin App-Only, but it only mention how to connect (JDBC, repository URL, password, and username).
Thank you for your patience.
Best wishes,
Tiago
Hello Ankit.
Thank you for your answer. It brings some light to this issue.
I have two more questions:
Question 1: Regarding your answer to "Question 2: The repository database can be empty and then the installer will create the required tables and relations between tables during the Yellowfin installation on a Docker environment?" - Is the answer valid for both cases (All-in-one and App-only)?
Question 2: Where are the instructions to install Yellowfin App-only in a Docker environment for an empty repository database? For example, https://wiki.yellowfinbi.com/space/yfcurrent/2196024/Install+in+a+Container has the instructions to install Yellowfin App-Only, but it only mention how to connect (JDBC, repository URL, password, and username).
Thank you for your patience.
Best wishes,
Tiago
Replies have been locked on this page!