Hi everyone,
i wanted to write in Maria DB, so i installed the necessary driver for Maria DB: https://help.alteryx.com/20213/designer/mariadb
After that i followed the setup of @jarrod (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Is-MariaDB-compatible-with-In-database/td-p/401790) and @PeterP (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Data-source-name-not-found-and-no-default-driver-specified/ta-p/400402). The connection is successfully tested.
However the DSN does not show in drop down list for selecting. I tried forcing this with connecting querry but i failed too (Error: No database selected). Someone has an idea, what is it about?Screenshot of setup and error:
Oh i got it fortunately. There were 2 reasons for this problem in Alteryx (i have no problem in connection through MySQL Client).1. I have to set the connection with MySQL Driver instead of MariaDB Driver (maybe it's a bug of SIMBA MariaDB within Alteryx).
2. I can't see the created tables in tab "Table" in Connect-IN-DB Tool, even after refreshing. But it worked with SQL Editor (SELECT * FROM test.books)
Thanks so much for your efforts and time
A few things:
1) You haven't finished setting up your In-DB connection yet so you will not be able to connect with either an Input Data or a Connect In-DB.
2) You need to choose your connection in the Connections drop-down under the Connection Type toggle in Manage In-DB.
3) Once that is done you should be able to choose the proper connection string in the dropdown connected to connected string.
I always test with a Connect In-DB and cache by tables/views there - as opposed to trying to connect via Input data
2) You need to choose your connection in the Connections drop-down under the Connection Type toggle in Manage In-DB.I think you mean the selection in drop-down in picture 2. There is no options under that toggle.I though it could work by setting up the connection within the Driver Setup. So i can choose this driver as connection type. But it doesn't work neither.Same error: No database selected
Sorry - this is the dropdown you need to have a value in.
Thanks for clarifying, So i set this up but i dont know what should i do next to create a table.
that means it worked!!!!
Click on Tables!
It feels so close.The table is empty...I'm sorry for my noobery
Start by hitting refresh.
That says you had a table list from 2014. This is also for reading in/making sure you have a working connection. Once you do you can write using Output data/datastream in and Write-DB etc.
After hitting refresh button the table window remains, nothing changed. Last Refresh is still in 2014.That means the connection is not working well?
That's weird. Are there tables at the DB you are pointing to? Should there be tables - or is it only to writing to?
If it's only for writing to - hook up an Output data tool and writing your table now. You'll need to use a SQL table definition of "XXXX"."XXXX" (etc....)
It's for me to writing to. I tried to set up the connection in Output Tool as above. The querry is below
Humor me on this one - delete the two output data fields.
Drag a Datastream In. Define your table name and options there.
Drag a Write In-DB. Repeat table name et all there.
I don't use Output data much to write to DBs but you will need schema and table for both.
The same error with Datastream-In. It says "No Database selected".What does it even mean ...
that's not a database. That's a table name.
To write you need to include a DB, a Schema and a table. so like "DB"."TEST"."test" - Your data admin team should be able to provide you this syntax.
I'm sorry for taking so long. I've got finally supports from the IT-Appartment today.We could create the connection and database on the MySQL Client. In the "test" Database we created several tables (1. Foto). Back in Alteryx i can not select any table nor databases.2.Foto: Setting for connection parameters.3.Foto: In-DB Setting4.Foto: No tables show after refreshing ... Here i cant change the connection Name like u said, otherwise i'll get an error (5. Foto)
your connection name is test - not test books.
drag a text input.
write the number 1 in it.
drag a datastream in.
try creating a table called something like "TEST"."TEST2" or I don't know if MariaDB needs a schema included. "TEST"."TEST"."TEST2"
create a table in test called something like:
I know the DSN is test, it didn't work. So i tried like you recommended with "test.books" but it doesn't work neither...Datastream-In doesn't work obviously, because there was no connection (with In-DB). All 3 options failed as output with "test", "test.test2" and "test.test.test2"
wait - you have a database now in your TEST connection - now - right? the books one. Can you see it on connect-in-db if you refresh your table view under TEST (not -test books)? If your team created it for you - you should be able to see it but you'll have to refresh your table view? If you already did refresh then I don't really know. It looks like a working connection and clearly you have data there. So I don't know. You are authorized to read the data too - correct?
We're just trying to get the syntax down it's probably something like "TEST"."TEST"
Wow. This is still incredibly weird. You can write-in-db but you can't see that table you are writing to. I've never seen that (unless you do not have permission to see the table).
Yes it is. I can write in using Datastream-In or Output Tool but can't read it in the Table Query, so i thought there was no connection at all
