What are the Slack Archives?
Itβs a history of our time together in the Slack Community! Thereβs a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.
Because this space is not active, you wonβt be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..
ππ Would anyone like to share their experience on how to connect
ππ Would anyone like to share their experience on how to connect Spryker to a BI tool as easily as possible? I would like to get more out of all the sales, inventory and status data records from the Spryker database. The dashboard in the backend is ...well let's say limited suitable π
Comments
-
We use a readonly user on DB level and PowerBI with direct access. But we use a few statistics in PowerBI with not that many accesses. PowerBI has the advantage to copy the data to the PowerBI Server first to speed up data access and limit the impact on the production database. This is a disadvantage for bigger datasets.
For simple to medium reports is fine for us, once we will reach limits we might move it to a dedicated data warehouse, but we havenβt reached this point yet.
0 -
some "decoupled/less intrusive" ways come to my mind...
1. use at least a read-replica db, so no impact on serving node by reading big data
2. use statemachine to push data realtime to an esb or data sink like kafka/nifi or aws datalake and import data from there in to your bi systems
3. use db views as "fixed" consumer interface of your data - db schemes are to change over time
...and just dont read directly from production - has never been an good idea and probably will never be (if you are asking for experience π )0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 69 Spryker News
- 896 Developer Corner
- 758 Spryker Development
- 83 Spryker Dev Environment
- 361 Spryker Releases
- 3 Oryx frontend framework
- 34 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 23 Job Opportunities
- 3.2K π Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 68 Spryker Safari Questions
- 50 Random