Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

scarvalone

HP Vertica Support

Submitted by on ‎01-13-2015 09:06 PM
Adding support to connect to an HP Vertica database
Status: Planned
See more ideas labeled with:
26 Comments (26 New)
Comments
nishalit
New Member
‎08-15-2020 07:15 PM
Thanks everyone for the feedback - We plan to release an HP Vertica connector before end of CY17. Stay tuned for more updates.
melody_jones
New Member
‎08-15-2020 08:41 PM
Hello, we have a Vertica database that I want to connect to from PowerPivot. I was able to use the connection wizard and connect using the ODBC DSN data source. When it asks you to select the tables and views in the table Import Wizard, I selected three tables. But I get an error when it tries to import the data. Does anyone know what this error is and how to resolve this? Your help is greatly appreciated!! OLE DB or ODBC error: ERROR 4856: Syntax error at or near "[" at character 8 ; 42601. An error occurred while processing table 'GamePlayLog'. The current operation was cancelled because another operation in the transaction failed.
melody_jones
New Member
‎08-15-2020 08:48 PM
Hello, we have a Vertica database that I want to connect to from PowerPivot. I was able to use the connection wizard and connect using the ODBC DSN data source. When it asks you to select the tables and views in the table Import Wizard, I selected three tables. But I get an error when it tries to import the data. Does anyone know what this error is and how to resolve this? Your help is greatly appreciated!! OLE DB or ODBC error: ERROR 4856: Syntax error at or near "[" at character 8 ; 42601. An error occurred while processing table 'GamePlayLog'. The current operation was cancelled because another operation in the transaction failed.
syepes
New Member
‎08-15-2020 08:48 PM
'+5 For this one
melody_jones
New Member
‎08-15-2020 08:51 PM
Hello, we have a Vertica database that I want to connect to from PowerPivot. I was able to use the connection wizard and connect using the ODBC DSN data source. When it asks you to select the tables and views in the table Import Wizard, I selected three tables. But I get an error when it tries to import the data. Does anyone know what this error is and how to resolve this? Your help is greatly appreciated!! OLE DB or ODBC error: ERROR 4856: Syntax error at or near "[" at character 8 ; 42601. An error occurred while processing table 'GamePlayLog'. The current operation was cancelled because another operation in the transaction failed.
syepes
New Member
‎08-15-2020 08:51 PM
'+5 For this one
TheMoron1983
New Member
‎08-15-2020 08:52 PM
Yes, Vertica is really important as it is a great column database, even free for a 3 node 1TB license. Microsoft would be crazy not to support such a good clustered DB for analysis. Continuous querying would also be important.
volodin
New Member
‎08-15-2020 08:52 PM
We are using vertica right now. Probably, the lack of HP Vertica support is one of the major arguments not to switch to PowerBI from Tableau. Put 3 votes for it.
gramchandra
New Member
‎08-15-2020 08:52 PM
Please could we have an update on this topic? Its been an year since the last update. Thanks.
shamany_na
New Member
‎08-15-2020 08:53 PM
Yes, Connection to Vertica is really important.