6š
Iām not sure what your definition of BI is or why you assume that a BI solution requires more than one data source.
In my experience, BI means statistical analysis of data. A reporting schema, using dimensional techniques, can be the basis for it. The data is usually ETLād from various transactional sources into the single, dimensional schema, which then becomes the source for all analysis.
If what Iām saying is correct, then you donāt need multiple data sources.
Maybe another way to think about the question is: Do the ORM techniques built into Django lend themselves to modeling a dimensional star schema using objects?
2š
Itās doable, Iāve done it for my work. Canāt opensource it yet, Iāve been able to release the heterogeneous replication app so far, but I havenāt given up.
I use the Django ORM for the project data, copied and pasted Djangoās āload_backend() functionā to be able to connect to more than one DB. The database used as source (companiesā DB in ORACLE) for the graphs & tables is queried in raw SQL (the Django ORM would just get in the way anyways, many complex joins & aggregation).
Graphs are done with ājqPlotā, tables are done using ājqGridā. User account and auth is done using āldap-groupsā with simple patches and binded to the Active Directory tree.
The replication app is here Django-Replication and can give you an example how to connect to multiple DBs from Django. It also features time limited (expirables via a timeout) queries and concurrent queries via pythonās multiprocessing & threading libraries.
āTried posting images of the app, but new users arenāt allowed toā
- [Django]-Get string from TextChoices class in Django
- [Django]-Running django application via SSH on Windows
- [Django]-Internet Explorer does not talk with django dev server
- [Django]-Django adding a feedback form on every page