EPM - Configuring Oracle 11g ODBC Driver

相关文章推荐

私奔的绿豆 · 8c ...· 6 天前 ·

有情有义的领带 · 如何：指定绑定源 - WPF .NET ...· 1 年前 ·

有情有义的枇杷 · C# | ...· 1 年前 ·

腹黑的篮球 · Perl构建和打包自己的模块 - 骏马金龙 ...· 1 年前 ·

重情义的铁链 · 如何使用 FFmpeg 去除视频水印 - 掘金· 2 年前 ·

有胆有识的小蝌蚪 · Excel VBA 编程开发应用系列 ...· 2 年前 ·

</noscript><div id="body-container"><div id="site-title"><h1><a href="./" title="Home">Data, Academic Planning &amp; Institutional Research </a></h1></div><div id="search-form" role="search"><form accept-charset="UTF-8" method="get" action="search.php" title="Search"><label for="q">Find: </label><input class="inputBox" id="q" type="text" name="q" value="" maxlength="140"/><input class="search" type="submit" value="Search"/> <a class="other-links" href="links.php">Menu</a> </form></div><div id="container"><div id="mobile-container"><div id="page-content" role="article"><div class="fr-element fr-view"><h1 class="title">EPM - Configuring Oracle 11g ODBC Driver</h1><div style="float:right;text-align:right;background-color:#F6F4F0;padding:1px;border:0px solid #e5e5e5;border-radius:2px;"/> <div id="doc-summary"><p>This document describes how to configure the Oracle 11g ODBC driver to create connections to EPM.&#13; </p></div><p/><h3>Background:</h3>&#13; <p>Once the ODBC driver is installed and <strong>tnsnames.ora</strong> and <strong>sqlnet.ora</strong> files are configured, users must specify connection settings for the ODBC driver in the <strong>'Data Sources'</strong> administrative tool.</p>&#13; <div style="background: #FFEFC9; border: 1px solid #FFDD8E; padding: 15px;"><strong>NOTE:</strong> This document only describes the process of configuring a System-level ODBC connection to EPM. Certain programs, such as Oracle SQL Developer, may require users to configure ODBC connections directly within the application. For help configuring ODBC in specific applications, please refer to the software vendor's documentation.</div>&#13; <h3>Directions:</h3>&#13; <p>Click on <strong>Start &gt; Control Panel &gt; Administrative Tools </strong></p>&#13; <p>Double-click <strong>Data Sources (ODBC)</strong> and select the <strong>System DSN</strong> tab.</p>&#13; <p>Click <strong>Add...</strong> and select the 'Oracle 11g' driver. If this driver does not appear in the list, Oracle 11g software may not have been installed correctly.</p>&#13; <p>Fill out the following fields:</p>&#13; <ol type="a"><li><strong>Data Source Name</strong>: Name used to identify data source.</li>&#13; <li><strong>Description</strong>: A description of the data source.</li>&#13; <li><strong>TNS Service Name</strong>: The name of the connection entry in <strong>tnsnames.ora</strong> (should auto-populate based on the contents of the file).</li>&#13; <li><strong>User ID</strong>: The username assigned to you in one of the initial EPM authorization emails.</li>&#13; </ol><br/>Uncheck the box labeled <strong>Enable Query Timeout</strong> to prevent timeout errors on long queries. Click <strong>Test Connection</strong>. If you receive an error message, please refer to <a href="page.php?id=19644">EPM - Common ODBC Errors</a> for recommendations. Otherwise, click <strong>OK</strong> to save the connection.&#13; <div id="up-prev-next"><div id="prev">« Previous: <a href="19325">EPM - Editing 'tnsnames.ora' and 'sqlnet.ora' Files</a></div><div id="up">↑ Up: <a href="19669">EPM - Accessing EPM via ODBC Overview</a></div><div id="clear"/></div></div></div><div id="credit-feedback"><br style="clear:both;"/><br/><hr class="kbhr1"/><table class="kbfeedbacktable1"><tr><th>Keywords:</th><td><span id="kb-page-keywords">tnsnames, tnsnames.ora, names, EPM, ODBC, Enterprise Performance Management, HRS, data warehouse, data, ora file, sqlnet, MS Access, access, tsnnames, tns, Oracle Database, database, database connection, configure</span> <span id="suggestk-button"><a class="feedback-btn-link" onclick="suggestK(19658,'EPM+-+Configuring+Oracle+11g+ODBC+Driver','tnsnames%2C+tnsnames.ora%2C+names%2C+EPM%2C+ODBC%2C+Enterprise+Performance+Management%2C+HRS%2C+data+warehouse%2C+data%2C+ora+file%2C+sqlnet%2C+MS+Access%2C+access%2C+tsnnames%2C+tns%2C+Oracle+Database%2C+database%2C+database+connecti');">Suggest keywords</a></span><span id="suggestk"/><span id="ks-thank-you"/></td></tr><tr><th>Doc ID:</th><td>19658</td></tr><tr><th>Owner:</th><td>Steven T.</td></tr><tr><th>Group:</th><td>Data, Academic Planning &amp; Institutional Research</td></tr><tr><th>Created:</th><td>2011-08-08 19:00 CDT</td></tr><tr><th>Updated:</th><td>2023-04-03 07:57 CDT</td></tr><tr><th>Sites:</th><td>Data, Academic Planning &amp; Institutional Research, DoIT Help Desk</td></tr><tr><th>Feedback:</th><td><input type="hidden" id="did" value="19658"/> <span id="vote-yes"><input type="button" id="helpfulBtn" class="feedback-btn-yes" value="Helpful"/></span> <span id="count-yes">0</span> <span id="vote-no"><input type="button" id="unhelpfulBtn" class="feedback-btn-no" value="Unhelpful"/></span> <span id="count-no">0</span> <a class="feedback-btn-link" href="feedback.php?action=2&amp;help=comment&amp;id=19658">Comment</a><span class="suggest-doc3"> <a class="feedback-btn-link" href="feedback.php?action=2&amp;help=suggest&amp;id=19658">Suggest a new document</a></span><span id="feedback-thank-you"/></td></tr></table></div></div><footer><div id="copyright" role="contentinfo"><div class="uw-copyright">&#13;