I am able to fetch Splunk data into Excel, following the ODBC App documentation.
Now I need to do the same but into a PowerPivot (running as a plugin inside excel), but I couldn't make it work:
On PowerPivot I choose:
Get External Data >>
From other Sources >>
Others (OLEDB/ODBC) >>
Build... >>
Provider = MS OLE DB Provider for ODBC Sources >>
Datasource name = Splunk ODBC >>
set User and password >>
Test Connection ...>> Test Connection Succeeded>>
OK >>
(connection String = "Provider=MSDASQL.1;Persist Security Info=False;User ID=pinhesm2;DSN=Splunk ODBC)"
Next >>
Error: "Failed to connect to the server. Reason: ERROR [HY000] [Splunk]ODBC Not enough information provided to establish a connection to the data source and specified to not prompt for more information.
ERROR [HY000] [Splunk]ODBC Not enough information provided to establish a connection to the data source and specified to not prompt for more information."
Do you know if its possible and how to set it up?
Thanks
... View more