Utilize Business Intelligence Tools and Maintain Your Customer Reports and Queries
Tridex Systems has helped many Infor SX.e users make the switch to Infor Cloudsuite Distribution. A common request we receive during migrations regards how to keep leveraging the many custom, on-premise reports distributors have built on top of SX.e over many years. While Infor Data Lake and new business intelligence offerings provide clear advantages in data analytics and reporting, some distributors want to continue to use their older reporting while they progressively migrate to the new toolsets.
DATA POND AND DATA LAKE: THE BEST OF BOTH WORLDS
Some Infor SX.e users have concerns that moving to Cloudsuite Distribution, Data Lake and business intelligence tools could mean losing custom reporting they’ve built their businesses around. Various reports and queries need to be rebuilt because you cannot query Data Lake in the same ways you did with your on-premise reporting in the past and some fields are different. Additionally, while business intelligence suites have many advantages over legacy reporting tools, it can take time and resources to convert your existing on-premise reporting over to new BI tools.
With Tridex Systems’ Data Pond, you now have a way to replicate your Data Lake information on-premise so you can keep running the same SQL Server reports you’ve been running for years. This is the best of both worlds for distributors running Infor – enjoy everything Cloudsuite, Data Lake and business intelligence tools have to offer while running the reports you’ve relied on for years.
DATA POND: AN ON-PREMISE SQL DATABASE THAT MIRRORS DATA LAKE
Data Pond provides you with an on-premise copy of your data in a SQL Server database. We use the same files that Cloudsuite Distribution sends to Data Lake and ingest that data into an on-premise copy. So every time you touch a record inside of Cloudsuite Distribution, you have data sent to both Data Lake and Data Pond.
DATA POND IS EASY
Data Pond works behind the scenes with no user intervention.
- Data is updated in Cloudsuite Distribution through the course of work
- New data objects are sent to Data Lake
- We send those data objects to Data Pond using ION
- You now have an on-premise SQL Server database that mirrors Data Lake
- Continue to enjoy Data Lake and business intelligence tools while you also enjoy your previously created reports and queries.
As a live copy of Data Lake, Data Pond gives you several advantages.
- You keep the same data but you can use the on-premise reporting and querying that you’ve established previously.
- You can continue to use and build BI out in your organization but do so at your pace without losing any important reports and queries.
- Data Pond does not interfere with any ETL tools from Infor, we’re simply taking a raw copy of Data Lake. But in cases where you may be lacking fields you are used to, we have the ability to transform that data for you in SQL. That way your fields and data are similar to what you were used to in your Progress database.
- No user intervention is needed. We file share using ION so it all runs behind the scenes for you.
