How can I make a mock DB to be pulled into Alteryx?

pavanligue

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.

Genevieve P.

Hi @pavanligue

This Community forum is dedicated to questions about the Smartsheet application:

https://www.smartsheet.com/

It seems like you have questions around Oracle and Alteryx, which would be better suited to one of their forums:

• https://community.oracle.com/hub/
• https://community.alteryx.com/

Here's a Webinar that explains more about Smartsheet:

https://youtu.be/vYqYdlmAj-E

Smartsheet can help you store information and create Dashboards and charts from your data, if that's what you're looking for. You could use a Smartsheet Form to intake data into a grid. Here's a free Webinar that demonstrate's Smartsheet Forms.

Cheers,

Genevieve