Calling Developers!
We are reenergizing our code contribution process! Learn More

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

URF5M7P0V
URF5M7P0V Posts: 2 πŸ§‘πŸ»β€πŸš€ - Cadet

πŸ“ˆπŸ“Š 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

  • Alberto Reyer
    Alberto Reyer Lead Spryker Solution Architect / Technical Director Posts: 690 πŸͺ - Explorer

    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.

  • U015LSYAWTG
    U015LSYAWTG Posts: 4 πŸ§‘πŸ»β€πŸš€ - Cadet

    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 πŸ˜‰ )