Please at least one embedded Db support for Alteryx training/examples

[simonaubert_bd]

Hello all,

According to wikipedia :
https://en.wikipedia.org/wiki/Embedded_database

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application.

It's often like a single file/dll that you can use inside an application without the user having to connect (or at least to configure it) to it (it's all done inside the application). So, it's widely portable.


Why it does matter ?

As of today, there is not a single example of in database workflow because all the supported databases need the user to:

1/install an odbc driver (most of time, he won't have the rights to do so)

2/configure an odbc connection (sometimes, he doesn't have the rights to)

3/configure a connection on Alteryx (ok, he can)
So it requires IT action, which can be pretty long (in ùany organization, it requires several weeks !!). And even with all of that,the users must be granted privilege to access database and the customer need to develop its own examples and write its own specific documentation.

Well, this is not efficient.

What I suggest is Alteryx to use one of embedded database for training support/one tool examples. SQLlite seems good, maybe a more analytics oriented (like DuckDB ) would be more efficient.
The requirement are, I think, the following :
-OpenSource and free
-Fast
-SQL compliant
-With a bulk load ability

Best regards,

Simon

[cgoodman3]

It would be great if a database could be optionally pre-loaded on install, I can see it massively helping with adoption of in-DB tools as they are probably under utilised and in corporate environment they will be highly protected so being able to showcase with something like a Postgres db would be a definite winner in my view.

[simonaubert_bd]

Hello @cgoodman3  That's the idea. But instead of a postgresl (which requires admin rights ;) ) I would prefer an embedded database :)