I have used the BloB Convert tool to convert a string to a GEOMETRY,
now I am just outputting the file to an ODBC connection.
However in the create table statement I get the field is created as IMAGE type rather than a BLob type, how to rectify this?
Solved! Go to Solution.
I have attached a sample field, I want to import the Geometry field to the ODBC database.
I have the field currently as v_string. So I got the ODBC output error - doesnt support TEXT field. Then I used BloB convert which is a valid datatype in the ODBC connection, but the Create statement by Alteryx generates a Image type for the column rather than directly using BLOB file.
I am using firebird ODBC as destination.
So for starters you do really need to be aware that Firebird isnt officially supported in Alteryx, so you may run into issues. That said I have used it sucessfully in the past.
In terms ofimporting your geometry field then Alteryx isn't converting the Create Table syntax properly, you need to specify this yourself.
I've attached an image of how you might do this taken from one of my colleagues modules doing this for producing geocoding maps for Tableau. Here you can see the settings he used (you need Transation size as 1 not 10000):
The key settings are options 3 and 5.
Please let me know how you get on.
Chris
Awesome, this is exactly what I needed.
Alterrnatively, I created the DB Schema using RazorSql and then just inserted the data.But this is more automated.
Great news, gladto help.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |