avniproject / avni-product

https://avniproject.org/
7 stars 10 forks source link

[DMP 2024]: Integration with Metabase #1562

Open vinayvenu opened 3 months ago

vinayvenu commented 3 months ago

Ticket Contents

Description

Many organisations using Avni also use Metabase for analytics. The Avni hosted instance already has an instance of Metabase.

Each time a new organisation is onboarded, somebody manually creates database connection, user groups and basic visualisations for it on Metabase. This is both time-consuming and error-prone.

Metabase already has a good API that can be used to do all of this. If we can automate this mechanism, then users can directly use a bunch of predefined reports

Goals & Mid-Point Milestone

Goals

Setup/Installation

Expected Outcome

There has to be some basic dashboards that are created on Metabase automatically. The scope of the number of dashboards can be limited to the time available, but the solution should be extensible for newer standard visualisations The solution should be able to recreate these dashboards as an when changes happen to Avni, and also be able to retain manual visualisations built on top of these

Acceptance Criteria

No response

Implementation Details

Metabase API - https://www.metabase.com/learn/administration/metabase-api

Required knowledge - Java, Spring Boot

Mockups/Wireframes

No response

Product Name

Avni

Organisation Name

Samanvay Foundation

Domain

Other

Tech Skills Needed

Java

Mentor(s)

@vinayvenu

Category

API, Backend, Database

Related cards

Harish-2003 commented 2 months ago

What else tech stack do i need to know other than Java.... Are there any beginner friendly issues to do so that i can able to get familiar with the codebase

bhatia828 commented 2 months ago

Hi @vinayvenu , I want to contribute to this project but the installation guide is only for MAC and Ubuntu. Please let me know what can be done for windows. Thanks

vinayvenu commented 2 months ago

hi @bhatia828 since all developers on Avni either use a Mac or Ubuntu, nobody has yet been able to create an installation guide for windows. This will include creating scripts etc, but it doesn't exist today.

vinayvenu commented 2 months ago

What else tech stack do i need to know other than Java.... Are there any beginner friendly issues to do so that i can able to get familiar with the codebase

Basic knowledge of databases and APIs will be required. You should be able to look up good-first-issues on avni-server - https://github.com/avniproject/avni-server/labels/good%20first%20issue

iamdhanasekhar commented 2 months ago

Hi @vinayvenu I would like to contribute to this project my tech stack is spring boot, hibernate,Jpa will this tech stack enough for this project

vinayvenu commented 2 months ago

@iamdhanasekhar yes, that should be enough

Shamantak12 commented 2 months ago

hi @vinayvenu , I want to contribute to this project would you like to assign me on this?

vinayvenu commented 2 months ago

@Shamantak12 you can try starting off with a smaller issue to see how things go first - https://github.com/avniproject/avni-server/labels/good%20first%20issue

pradnya809 commented 2 months ago

@vinayvenu hi can i work on this on windows?

AieshaShetty commented 2 months ago

Hi @vinayvenu, I would like to contribute to this project. My tech stack includes core java, spring boot, JPA, authentication through java-jwt. Can we work on how to setup this application on Windows too?

vinayvenu commented 2 months ago

@AieshaShetty you can try, although you might not get help from the core contributors because none of them are on Windows. The build/run scripts on all repos will need some tweaking to work fine on Windows.

Abhishekyaduvansh commented 2 months ago

Hi @vinayvenu , I would also Like to contribute on this project. I have good understanding on Java with Spring boot and JPA. This would be My First time contribution to an open source project. I have the same Question how to setup this application on windows? Please let me know.

MiirzaBaig commented 2 months ago

Wanna contribute here, i shall go with the "good first issues" in order to understand the process. Is that correct? @AieshaShetty

AbhimanyuSamagra commented 2 months ago

Do not ask process related questions about how to apply and who to contact in the above ticket. The only questions allowed are about technical aspects of the project itself. If you want help with the process, you can refer instructions listed on Unstop and any further queries can be taken up on our Discord channel titled DMP queries. Here's a Video Tutorial on how to submit a proposal for a project.

merciajeno commented 2 months ago

Hello @vinayvenu , Regarding to database, I am a novice in MySQL. Is that sufficient for this open souce project?

vinayvenu commented 2 months ago

@merciajeno this will require you to set up two databases on your local machine. It requires intermediate skills in understanding databases

abhinavkumar1122 commented 2 months ago

Hi @vinayvenu I have experience of around 3 years in java and database , so I want to contribute in this project .

UTKARSHJHA-2005 commented 2 months ago

Hi @vinayvenu I am a 2nd year student and I want to contribute in this project.

Kgayathri03 commented 2 months ago

Hi @vinayvenu I am a 3rd year student and I want to contribute in this project.

Varun-Sethi-Dev commented 1 month ago

Hey I would like to work on this I have knowledge of core java, php for backend and databases, and majorly android development could you guide me where to start and what needed to learn and how to contribute to it.

Omsharnma commented 1 month ago

hi @vinayvenu , I want to contribute to this project would you like to assign me on this?

pinki639 commented 1 month ago

Hi @vinayvenu , I want to contribute to this project i know basic and advanced java