How can I make a mock DB to be pulled into Alteryx?
-
wrote on 5 Nov 2022, 10:57 last edited by
I am working on a school project and am having some issue figuring this out. My team and I's problem is that we have 24 XML files from our sponsor (they make custom garage doors), and it is unstructured data that needs to be organized to be able to determine trends, patterns, etc. We need help on figuring out how to create a mock database for those 24 files so Alteryx can pull from the DB instead of entering each file individually, (since the sponsor has millions of files it wouldn't work to enter each individually).
The sponsor's current situation is that they pull text files from an Oracle DB that are made into XML files when extracted. My team doesn't have access to the Oracle DB so we need to make a mock DB (doesn't have to be Oracle) that will mimic this to show how Alteryx can structure the unstructured data.
-
I am working on a school project and am having some issue figuring this out. My team and I's problem is that we have 24 XML files from our sponsor (they make custom garage doors), and it is unstructured data that needs to be organized to be able to determine trends, patterns, etc. We need help on figuring out how to create a mock database for those 24 files so Alteryx can pull from the DB instead of entering each file individually, (since the sponsor has millions of files it wouldn't work to enter each individually).
The sponsor's current situation is that they pull text files from an Oracle DB that are made into XML files when extracted. My team doesn't have access to the Oracle DB so we need to make a mock DB (doesn't have to be Oracle) that will mimic this to show how Alteryx can structure the unstructured data.
wrote on 5 Nov 2022, 11:08 last edited by@pavanforza
Hello and welcome.Qt supports SQLite as a database, which is very simple to set up and use (file based). You can still send it SQL queries/statements to execute through the same Qt
QSql...classes as would be used against an Oracle database.
1/2