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
Hi there! Has someone experience with copying data from Spryker to a BI tool like Qlik or Tableau? What approach did you take?
Comments
-
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.
0 -
Depending on your needs, you can generate CSVs or something or a ZED API endpoint or a simple ZED controller.
0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 76 Spryker News
- 930 Developer Corner
- 788 Spryker Development
- 89 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 35 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 26 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
- 70 Spryker Safari Questions
- 50 Random