"Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$variable name$$. Variable is marked as required but not set in the query" when querying SAP Hana object
Stored Procedures are powerful and helpful, however, in Designer and Server it is required for them to have a return value. If that is not the case the error "no columns returned" will occur.
Error "An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB'" when converting an ODBC DSN-less connection to OLEDB
Receive error "ORA-00942 - table or view does not exist" or "ORA-00903 - invalid table name" using output mode to "Append Existing" even though the table exists
Alteryx allows you to connect to many different types of data sources. One type of data source you can connect to is a database. Examples of databases are SQL Server, Oracle, Teradata, and MongoDB; amongst many others. There are several connection methods to connect to database sources including ODBC, OleDB, or natively.
Below is a quick overview of how the different types of database connections appear within "workflow dependencies." This will help determine and compare different connection types from a quick glance.