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

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

Namespace Prefixes

PrefixIRI
n31http://data.openlinksw.com/oplweb/
n20https://www.openlinksw.com/about/id/entity/urn/howto:
n19http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep8#
n2http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuide#
n11http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep5#
n29http://www.openlinksw.com/about/id/entity/urn/data:opl:web:seo:mdata:
n10http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep2#
n25http://data.openlinksw.com/oplweb/dbms_family/PostgreSQLBridge#
oplsofthttp://www.openlinksw.com/ontology/software#
n30https://www.openlinksw.com/about/id/entity/urn/mdata:websites:google:uda:howto:
wdrshttp://www.w3.org/2007/05/powder-s#
n27http://data.openlinksw.com/oplweb/opsys_family/MacOSX#
schemahttp://schema.org/
n22https://www.openlinksw.com/about/id/entity/urn/data:openlink:
n26http://wikis.openlinksw.com/UdaWikiWeb/
n21https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/DAV/data/turtle/general/
n17http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep7#
n14http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep4#
n28http://data.openlinksw.com/oplweb/uda/howto/MacOSXSampleAppUsageiODBCDemoUsageGuide#
n18https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/data/turtle/general/
n9http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep1#
n7http://data.openlinksw.com/oplweb/product_format/st#
n23https://www.openlinksw.com/about/id/entity/urn/mdata:websites:google:
n5http://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/data/turtle/general/
n16http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep10#
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n15http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep9#
n12http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep6#
n8https://www.openlinksw.com/about/id/entity/urn/data:opl:web:seo:mdata:
xsdhhttp://www.w3.org/2001/XMLSchema#
n13http://data.openlinksw.com/oplweb/uda/howto/MacOSXLitePostgreSQLDataSourceNameConfigurationGuideStep3#
n6https://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 PostgreSQL Data Sources, for macOS Installation and Configuration of the Lite Edition (Single-Tier) ODBC Driver for PostgreSQL Data Sources, for macOS Installation and Configuration of the Lite Edition (Single-Tier) ODBC Driver for PostgreSQL Data Sources, for macOS Configuration of the Lite Edition (Single-Tier) ODBC Driver for PostgreSQL Data Sources, for macOS
wdrs:describedby
n5:uda-howtos-seo.ttl n6:UDAHowAndStepByGuides.ttl n8:webs n18:uda-howtos-qa.ttl n20:island n21:uda-howtos.ttl n18:uda-howtos.ttl n22:products n23:seo n29:offers n30:seo n22:websites
schema:name
Installation and Configuration of the Lite Edition (Single-Tier) ODBC Driver for PostgreSQL Data Sources, for macOS Configuration of the Lite Edition (Single-Tier) ODBC Driver for PostgreSQL Data Sources, for macOS Installation and Configuration of the Lite Edition (Single-Tier) ODBC Driver for PostgreSQL Data Sources, for macOS Configuration of the Lite Edition (Single-Tier) ODBC Driver for PostgreSQL Data Sources, for macOS
oplsoft:hasDatabaseFamily
n25:this n31:PostgreSQL
oplsoft:hasOperatingSystemFamily
n27:this
schema:category
Data Source Name Configuration Guide
schema:relatedLink
n26:InstallPostgreSQLLiteOSX n28:this
schema:genre
n7: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.</li> <li>Then, select the <strong>OpenLink PostgreSQL Lite Driver</strong> from the list of available drivers.</li> <li>Select the Unicode version of the driver if and only if you are working with multi-byte character sets, as unnecessary translations can significantly affect ODBC performance.</li> <li>Click <strong>Finish</strong>.</li> <li>The <strong>Data Source</strong> tab prompts for information that identifies the PostgreSQL database server and listen port. It also requests a name for your Data Source. You may also supply an optional description for your Data Source Name. <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>Hostname:</strong> The hostname or IP of the server on which PostgreSQL runs</li> <li><strong>Port number:</strong> The TCP port on which PostgreSQL listens</li> </ul> </li> <li>Press <strong>Continue</strong> once your data source details have been added.</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 PostgreSQL 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>Database:</strong> A valid PostgreSQL database</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> once your connection parameters have been set.</li> <li>Click <strong>Continue</strong> to view additional preferences that can be set for the 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.</li> <li>Then, select the <strong>OpenLink PostgreSQL Lite Driver</strong> from the list of available drivers.</li> <li>Select the Unicode version of the driver if and only if you are working with multi-byte character sets, as unnecessary translations can significantly affect ODBC performance.</li> <li>Click <strong>Finish</strong>.</li> <li>The <strong>Data Source</strong> tab prompts for information that identifies the PostgreSQL database server and listen port. It also requests a name for your Data Source. You may also supply an optional description for your Data Source Name. <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>Hostname:</strong> The hostname or IP of the server on which PostgreSQL runs</li> <li><strong>Port number:</strong> The TCP port on which PostgreSQL listens</li> </ul> </li> <li>Press <strong>Continue</strong> once your data source details have been added.</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 PostgreSQL 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>Database:</strong> A valid PostgreSQL database</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> once your connection parameters have been set.</li> <li>Click <strong>Continue</strong> to view additional preferences that can be set for the 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
n9:this n10:this n11:this n12:this n13:this n14:this n15:this n16:this n17:this n19:this