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

Options
URF5M7P0V
URF5M7P0V Posts: 2 🧑🏻‍🚀 - Cadet
in Knowledge Sharing

📈📊 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
    Options

    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
    Options

    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 😉 )

Categories