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..

Hi there! Has someone experience with copying data from Spryker to a BI tool like Qlik or Tableau? W

URF5M7P0V
URF5M7P0V Posts: 2 🧑🏻‍🚀 - Cadet

Hi there! Has someone experience with copying data from Spryker to a BI tool like Qlik or Tableau? What approach did you take?

Comments

  • Alberto Reyer
    Alberto Reyer Lead Spryker Solution Architect / Technical Director Posts: 690 🪐 - Explorer

    For BI Tools like MS PowerBI, which copies the data from the DB already, a readonly user is enough.

    For tools who relay on copied data I recommend creating DB dumps nightly, if there is no requirement for live KPI's, which gets imported in you existing datawarehouse.
    When you need live data or have a high pull frequency I recommend a data replication.
    This can be a read slave which is accessed by the BI system or by streaming every data change into you data pipeline (e.g.: https://ksqldb.io/ for postgresql).

    Hope that already gives you some ideas.

  • UKHD8KTMF
    UKHD8KTMF Posts: 393 🧑🏻‍🚀 - Cadet

    Depending on your needs, you can generate CSVs or something or a ZED API endpoint or a simple ZED controller.