This HTML5 document contains 34 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Namespace Prefixes

PrefixIRI
n23https://www.openlinksw.com/about/id/entity/urn/howto:
n13http://data.openlinksw.com/oplweb/
n26http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep2#
n25http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep1#
n22http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep3#
n24http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep4#
n19http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep5#
n30http://www.openlinksw.com/about/id/entity/urn/data:opl:web:seo:mdata:
n14http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep10#
n15http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep7#
n21http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep6#
n2http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuide#
n10https://www.openlinksw.com/about/id/entity/urn/mdata:websites:google:uda:howto:
n11http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep9#
oplsofthttp://www.openlinksw.com/ontology/software#
n18http://data.openlinksw.com/oplweb/uda/howto/MacOSXLiteOracleDataSourceNameConfigurationGuideStep8#
wdrshttp://www.w3.org/2007/05/powder-s#
n16http://data.openlinksw.com/oplweb/opsys_family/MacOSX#
schemahttp://schema.org/
n7https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/DAV/data/turtle/general/
n20http://wikis.openlinksw.com/UdaWikiWeb/
n6https://www.openlinksw.com/about/id/entity/urn/data:openlink:
n27http://data.openlinksw.com/oplweb/dbms_family/Oracle#
n31http://data.openlinksw.com/oplweb/uda/howto/MacOSXSampleAppUsageiODBCDemoUsageGuide#
n8https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/data/turtle/general/
n17https://www.openlinksw.com/about/id/entity/urn/mdata:websites:google:
n28http://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/data/turtle/general/
n9http://data.openlinksw.com/oplweb/product_format/st#
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n4https://www.openlinksw.com/about/id/entity/urn/data:opl:web:seo:mdata:
xsdhhttp://www.w3.org/2001/XMLSchema#
n29https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/DAV/uda2.openlinksw.com/data/turtle/general/

Statements

Subject Item
n2:this
schema:description
Configuration of the Lite Edition (Single-Tier) ODBC Driver for Oracle 10g Data Sources, for macOS
wdrs:describedby
n4:webs n6:websites n7:uda-howtos.ttl n8:uda-howtos-qa.ttl n10:seo n6:products n17:seo n23:island n28:uda-howtos-seo.ttl n29:UDAHowAndStepByGuides.ttl n30:offers n8:uda-howtos.ttl
schema:name
Configuration of the Lite Edition (Single-Tier) ODBC Driver for Oracle 10g Data Sources, for macOS
oplsoft:hasDatabaseFamily
n13:Oracle n27:this
oplsoft:hasOperatingSystemFamily
n16:this
schema:category
Data Source Name Configuration Guide
schema:relatedLink
n20:InstallOracleLiteOSX n31:this
schema:genre
n9:this
schema:text
<ol> <li>To configure an ODBC DSN, run the OpenLink iODBC Administrator located in the /Applications/iODBC folder.</li> <li>Click the <strong>System DSN</strong> tab.</li> <li>Click the <strong>Add</strong> button. Then, select the <strong>OpenLink Oracle Lite Driver</strong> from the list of available drivers.</li> <li>Click <strong>Finish</strong>.</li> <li>The <strong>Data Source</strong> tab prompts for information that identifies the Oracle database server and listen port. <ul> <li><strong>DSN:</strong> A brief and meaningful title for your Data Source Name</li> <li><strong>Description:</strong> An optional description for your Data Source Name</li> <li><strong>Oracle Directory:</strong> Provides the full path to your local Oracle or Oracle client installation</li> <li><strong>Connection String:</strong> Your Oracle connection URL. Takes the following form:<br>//oracle_server_ip_address:oracle_listening_port/oracle_SID<br>For example:<br>//openhp2.OpenLinksw.com:1521/ORCL</li> </ul> </li> <li>Click <strong>Continue</strong>.</li> <li>The <strong>Connection</strong> tab takes a combination of required and optional parameters to make a connection to the target database: <ul> <li><strong>Username:</strong> A Oracle username</li> <li><strong>Row Buffer Size:</strong> This attribute specifies the number of records to be transported over the network in a single network hop. Values can range from 1 to 99.</li> <li><strong>Hide Login Dialog:</strong> Suppresses the ODBC "Username" and "Password" login dialog boxes when interacting with your ODBC DSN from within an ODBC compliant application.</li> <li><strong>Read Only connection:</strong> Specifies whether the connection is "Read-only." Make sure the checkbox is unchecked to request a "Read/Write" connection.</li> <li><strong>OCIPrefetchRows:</strong> Sets the number of rows to be prefetched.</li> <li><strong>OCIPrefetchMemory:</strong> Sets the memory allocated for rows to be pre-fetched.</li> <li><strong>SQL_DBMS Name:</strong> Manually overrides the SQLGetInfo(SQL_DBMS_NAME) response returned by the driver. This is required for products like Microsoft InfoPath for which the return value should be "SQL Server".</li> </ul> </li> <li>Click <strong>Continue</strong> to view additional preferences that can be set for the connection.</li> <li>The third tab contains settings that are not required for a basic connection: <ul> <li><strong>Initialization SQL:</strong> Lets you specify a file containing SQL statements that will be run automatically against the database upon connection.</li> <li><strong>Cursor Sensitivity:</strong> Enables or disables the row version cache used with dynamic cursors.</li> <li><strong>Max Rows Override:</strong> Allows you to define a limit on the maximum number of rows to be returned from a query. The default value of 0 means no limit.</li> <li><strong>Show Remarks:</strong> Affects output from the SQLColumns() ODBC API call.</li> <li><strong>Disable autocommit:</strong> Changes the default commit behavior of the OpenLink driver. The default mode is AutoCommit (box unchecked).</li> <li><strong>Disable rowset size limit:</strong> Removes OpenLink's default 100 rowset restriction.</li> <li><strong>Defer fetching of long data:</strong> Defers fetching of LONG (BINARY, BLOB, etc.) data unless explicitly requested in a query. This provides significant performance increases when fields in the query do not include LONG data fields.</li> <li><strong>Always include VIEWS in table list:</strong></li> <li><strong>Always include all types in table list:</strong></li> <li><strong>Custom Catalogue Views:</strong> Dictates whether custom OpenLink views are used to return metadata for certain ODBC catalog functions: SQLForeignKeys(), SQLPrimaryKeys(), SQLProcedureColumns(), SQLProcedures(), and SQLSpecialColumns(). These custom views provide more metadata than is normally provided by the standard Oracle data dictionary views.</li> <li><strong>User's own tables first in SQLTables:</strong> This option is specific to OpenLink's Oracle drivers. It prompts the SQLTables() ODBC API call to display the connected user's tables first in table lists. The default ordering is alphabetical.</li> <li><strong>Count stored procedure parameters in SQL Procedures:</strong> This parameter is specific to the Oracle data source. It affects the output from SQLProcedures() when "Custom Catalog Views" is enabled.</li> </ul> </li> <li>Click the <strong>Finish</strong> button to save your new Data Source Name.</li> </ol> <ol> <li>To configure an ODBC DSN, run the OpenLink iODBC Administrator located in the /Applications/iODBC folder.</li> <li>Click the <strong>System DSN</strong> tab.</li> <li>Click the <strong>Add</strong> button. Then, select the <strong>OpenLink Oracle Lite Driver</strong> from the list of available drivers.</li> <li>Click <strong>Finish</strong>.</li> <li>The <strong>Data Source</strong> tab prompts for information that identifies the Oracle database server and listen port. <ul> <li><strong>DSN:</strong> A brief and meaningful title for your Data Source Name</li> <li><strong>Description:</strong> An optional description for your Data Source Name</li> <li><strong>Oracle Directory:</strong> Provides the full path to your local Oracle or Oracle client installation</li> <li><strong>Connection String:</strong> Your Oracle connection URL. Takes the following form:<br>//oracle_server_ip_address:oracle_listening_port/oracle_SID<br>For example:<br>//openhp2.OpenLinksw.com:1521/ORCL</li> </ul> </li> <li>Click <strong>Continue</strong>.</li> <li>The <strong>Connection</strong> tab takes a combination of required and optional parameters to make a connection to the target database: <ul> <li><strong>Username:</strong> A Oracle username</li> <li><strong>Row Buffer Size:</strong> This attribute specifies the number of records to be transported over the network in a single network hop. Values can range from 1 to 99.</li> <li><strong>Hide Login Dialog:</strong> Suppresses the ODBC "Username" and "Password" login dialog boxes when interacting with your ODBC DSN from within an ODBC compliant application.</li> <li><strong>Read Only connection:</strong> Specifies whether the connection is "Read-only." Make sure the checkbox is unchecked to request a "Read/Write" connection.</li> <li><strong>OCIPrefetchRows:</strong> Sets the number of rows to be prefetched.</li> <li><strong>OCIPrefetchMemory:</strong> Sets the memory allocated for rows to be pre-fetched.</li> <li><strong>SQL_DBMS Name:</strong> Manually overrides the SQLGetInfo(SQL_DBMS_NAME) response returned by the driver. This is required for products like Microsoft InfoPath for which the return value should be "SQL Server".</li> </ul> </li> <li>Click <strong>Continue</strong> to view additional preferences that can be set for the connection.</li> <li>The third tab contains settings that are not required for a basic connection: <ul> <li><strong>Initialization SQL:</strong> Lets you specify a file containing SQL statements that will be run automatically against the database upon connection.</li> <li><strong>Cursor Sensitivity:</strong> Enables or disables the row version cache used with dynamic cursors.</li> <li><strong>Max Rows Override:</strong> Allows you to define a limit on the maximum number of rows to be returned from a query. The default value of 0 means no limit.</li> <li><strong>Show Remarks:</strong> Affects output from the SQLColumns() ODBC API call.</li> <li><strong>Disable autocommit:</strong> Changes the default commit behavior of the OpenLink driver. The default mode is AutoCommit (box unchecked).</li> <li><strong>Disable rowset size limit:</strong> Removes OpenLink's default 100 rowset restriction.</li> <li><strong>Defer fetching of long data:</strong> Defers fetching of LONG (BINARY, BLOB, etc.) data unless explicitly requested in a query. This provides significant performance increases when fields in the query do not include LONG data fields.</li> <li><strong>Always include VIEWS in table list:</strong></li> <li><strong>Always include all types in table list:</strong></li> <li><strong>Custom Catalogue Views:</strong> Dictates whether custom OpenLink views are used to return metadata for certain ODBC catalog functions: SQLForeignKeys(), SQLPrimaryKeys(), SQLProcedureColumns(), SQLProcedures(), and SQLSpecialColumns(). These custom views provide more metadata than is normally provided by the standard Oracle data dictionary views.</li> <li><strong>User's own tables first in SQLTables:</strong> This option is specific to OpenLink's Oracle drivers. It prompts the SQLTables() ODBC API call to display the connected user's tables first in table lists. The default ordering is alphabetical.</li> <li><strong>Count stored procedure parameters in SQL Procedures:</strong> This parameter is specific to the Oracle data source. It affects the output from SQLProcedures() when "Custom Catalog Views" is enabled.</li> </ul> </li> <li>Click the <strong>Finish</strong> button to save your new Data Source Name.</li> </ol>
rdf:type
schema:HowTo
schema:step
n11:this n14:this n15:this n18:this n19:this n21:this n22:this n24:this n25:this n26:this