
Servicenow odbc manager software#
Servicenow odbc manager drivers#
Servicenow odbc manager driver#
While I believe that the way they've built their integration is inherently firewall-friendly (you shouldn't have to muck with any firewall issues), could there be a proxy server on the network?Īnd a likely frustrating part of this is, the functionality of their driver depends on their custom integration. So ServiceNow has built an ODBC driver to allow their customers to talk to their ServiceNow data as though it were another relational database. The ServiceNow aspect helps - to give you perhaps more background than you'd like, the OpenAccess SDK is a toolkit used by companies to build SQL interfaces to their unique data sources. Invalid attribute? Why? It worked so easily in the Excel worksheet, but Power Pivot seems much pickier. Reason: ERROR Required user name is missing.ĮRROR Invalid attribute in connection string: User ID.ĮRROR Invalid attribute in connection string: Initial Catalog.ĮRROR Invalid attribute in connection string: Persist Security Info.ĮRROR Required user name is missing.

Clicking 'Next' on the Table Import Wizard reveals this very mean looking error message that reads:įailed to connect to the server. Then I enter credentials, and a promising "Test connection succeeded" message appears when I click the 'Test Connect' button.īut after that point, things become problematic. I see that my list of data sources show up nicely in the dropdown under 'Use data source name'.

I choose '.ODBC Drivers' in the Provider tab, then click the 'Connection' tab. Here is what I did: In Power Pivot, I start with Get External Data > From Other Sources > Others (OLEDB / ODBC). Now trying to 'migrate' the project to Power Pivot, using the exact same connection logic, and the process fails. I was able to set up the queries in an Excel worksheet and they work just fine. Attempting to import some data into Power Pivot using an ODBC connection.
