<div>
Do you have to use ODBC? What is the application architecture?
</div>


Do you have to use ODBC? What is the application architecture?

<div>
We have an application platform called Pivotal, which requires during setup the user identify two databases via ODBC. &nbsp;We'd like to install the app on everyone's desktop (rather than run it from a Citrix server, as we do now) but we would save installation time if we could set up the O<br />
DBC connections centrally, like mapping drives.
</div>


We have an application platform called Pivotal, which requires during setup the user identify two databases via ODBC.  We'd like to install the app on everyone's desktop (rather than run it from a Citrix server, as we do now) but we would save installation time if we could set up the O
DBC connections centrally, like mapping drives.

<div>
<div class="content wysiwyg-content">
Is there a way to have our IT department create and manage ODBC connections centrally, rather than having to set up a connection to a database on each user's desktop? &nbsp;We have about 250 users on our LAN/WAN, and it would make the rollout of one of our new pieces of software much easier if we didn't have to &quot;visit&quot; each of the machines individually.
</div>
</div>


Is there a way to have our IT department create and manage ODBC connections centrally, rather than having to set up a connection to a database on each user's desktop?  We have about 250 users on our LAN/WAN, and it would make the rollout of one of our new pieces of software much easier if we didn't have to "visit" each of the machines individually.

Creating and managing ODBC connections centrally

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.