[jarendtsz]

A couple of questions on the new ODBC driver:

1) According to the documentation, you only need your regular username and password. What happens if this login is used for more than one account that has enterprise reporting setup? If you don’t specify an account number, how would NS know which account to connect to?

2) Has this driver been tested using the Java JDBC-ODBC bridge driver? Are there any plans for a pure JDBC driver in the future?

Thanks

Jan
This is a cached copy. Click here to see the original post.

[ivan.parra]

RE: New ODBC driver

1. When you log in, you will see multiple companies/roles for all roles that have the Advanced Analytics Permission(or Administrator). This is best viewed with tools like Crystal or Aqua Data Studio. Excel, however, does not show the company names. This makes it very hard to see which database schema you are currently working on. When a query is ran, ODBC will choose a role based on your default login role OR if the table is fully qualifed. For example:

select * from “My Company”.”My Role”.Account will gather information from “My Company” as role “My Role”. While “select * from account” will default to your default login role, else the first role with ODBC access.

2. The driver is provided by Open Access Software, whom supports all forms of drivers. In our first release, we aimed only for an ODBC driver. As demand increases, we may add other forms of drivers depending on our customer’s needs and requirements.

[Author]

Posts