Effectuez les étapes facultatives suivantes afin d'activer la connectivité distante pour les fonctionnalités classiques telles que les analyses et les tableaux de bord.
Lorsque vous configurez la connectivité distante pour les analyses et les tableaux de bord, vous pouvez avoir à indiquer des chaînes et des classes de pilotes JDBC, ainsi que des détails de contexte et de connexion JNDI.
Oracle: Driver Class: oracle.jdbc.OracleDriver jdbc string: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=[\"host-name\"])(PORT=[\"port\"]))(CONNECT_DATA=(SERVICE_NAME=[\"service-name\"]))) Amazon Redshift: Driver Class: com.oracle.jdbc.redshift.RedshiftDriver JDBC String: jdbc:oracle:redshift://[\"host-name\"]:[\"port\"];DatabaseName=[\"service-name\"];EncryptionMethod=SSL;ValidateServerCertificate=false Apache Hive Driver Class: com.oracle.bi.jdbc.hive.HiveDriver JDBC String: jdbc:oracle:hive://[\"host-name\"]:[\"port\"];EncryptionMethod=SSL;ValidateServerCertificate=false DB2 Driver Class: com.oracle.bi.jdbc.db2.DB2Driver JDBC String: jdbc:oracle:db2://[\"host-name\"]:[\"port\"];DatabaseName=[\"service-name\"] Impala Driver Class: com.oracle.bi.jdbc.impala.ImpalaDriver JDBC String: jdbc:oracle:impala://[\"host-name\"]:[\"port\"];EncryptionMethod=SSL;ValidateServerCertificate=false MySQL Driver Class: com.mysql.cj.jdbc.Driver JDBC String: jdbc:mysql://[\"host-name\"]:[\"port\"]"[/database][?properties] SQL Server Driver Class: com.oracle.bi.jdbc.sqlserver.SQLServerDriver JDBC String: jdbc:oracle:sqlserver://[\"host-name\"]:[\"port\"];DatabaseName=[\"service-name\"] Teradata Driver Class: com.teradata.jdbc.TeraDriver JDBC String: jdbc:teradata://[\"host-name\"]/DBS_PORT=[\"port\"]
Oracle: <Resource name="jdbc/myoracle" global="jdbc/myoracle" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:orcl" username="my_user" password="my_password" maxActive="15" maxIdle="1" maxWait="-1" /> <Resource name="jdbc/oracleolap" global="jdbc/oracleolap" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@localhost:1522:orcl112" username="my_user" password="my_password" maxActive="15" maxIdle="1" maxWait="-1" /> <Resource name="jdbc/oraclenorthwind" global="jdbc/oraclenorthwind" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1234))(CONNECT_DATA=(SERVICE_NAME=MATSDB.EXMAPLE.COM)))" username="my_user" password="my_password" maxActive="15" maxIdle="1" maxWait="-1" /> DB2 <Resource name="jdbc/db2northdb" global="jdbc/db2northdb" auth="Container" type="javax.sql.DataSource" driverClassName="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://example.com:58263/NORTHDB" username="my_user" password="my_password" maxActive="15" maxIdle="1" maxWait="-1" /> SQLServer: <Resource name="jdbc/sqlservernorthwind" global="jdbc/sqlservernorthwind" auth="Container" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://example.com:61045;DatabaseName=Northwind" username="my_user" password="my_password" maxActive="15" maxIdle="1" maxWait="-1" /> Teradata: <Resource name="jdbc/teranorthwind" global="jdbc/teranorthwind" auth="Container" type="javax.sql.DataSource" driverClassName="com.teradata.jdbc.TeraDriver" url="jdbc:teradata://99.999.99.999" username="my_user" password="my_password" maxActive="15" maxIdle="1" maxWait="-1" /> Mysql_community <Resource name="jdbc/CEmysql" auth="Container" type="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" factory="com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory" username="my_user" password="my_password" serverName="example.com" portNumber="3306" databaseName="my_database" />
The JNDI for DD Drivers. SQLServer: <Resource name="jdbc/DDsqlserver" auth="Container" type="com.oracle.bi.jdbcx.sqlserver.SQLServerDataSource" factory="com.oracle.bi.jdbcx.sqlserver.SQLServerDataSourceFactory" user="my_user" password="my_password" serverName="example.com\MSSQLSERVER16" portNumber="61045" databaseName="my_database" /> DB2: <Resource name="jdbc/DDdb2" auth="Container" type="com.oracle.bi.jdbcx.db2.DB2DataSource" factory="com.oracle.bi.jdbcx.db2.DB2DataSourceFactory" user="my_user" password="my_password" serverName="example.com" portNumber="58263" databaseName="my_database" /> Impala: <Resource name="jdbc/DDimpala" auth="Container" type="com.oracle.bi.jdbcx.impala.ImpalaDataSource" factory="com.oracle.bi.jdbcx.impala.ImpalaDataSourceFactory" user="my_user" password="my_password" serverName="example.com" portNumber="21050" databaseName="my_database" /> Spark: <Resource name="jdbc/DDspark" auth="Container" type="com.oracle.bi.jdbcx.sparksql.SparkSQLDataSource" factory="com.oracle.bi.jdbcx.sparksql.SparkSQLDataSourceFactory" user="my_user" password="my_password" serverName="example.com" portNumber="10000" databaseName="my_database" /> HIVE: <Resource name="jdbc/DDhive" auth="Container" type="com.oracle.bi.jdbcx.hive.HiveDataSource" factory="com.oracle.bi.jdbcx.hive.HiveDataSourceFactory" user="my_user" password="my_password" serverName="example.com" portNumber="10000" databaseName="my_database" /> MySQL: <Resource name="jdbc/DDmysql" auth="Container" type="com.oracle.bi.jdbcx.mysql.MySQLDataSource" factory="com.oracle.bi.jdbcx.mysql.MySQLDataSourceFactory" user="my_user" password="my_password" serverName="example.com" portNumber="3306" databaseName="my_database" /> MYSQL: <Resource name="jdbc/DDmysql" auth="Container" type="com.oracle.bi.jdbcx.mysql.MySQLDataSource" factory="com.oracle.bi.jdbcx.mysql.MySQLDataSourceFactory" user="my_user" password="my_password" serverName="example.com" portNumber="3306" databaseName="my_database" />
Ajoutez un pilote JDBC à votre installation de Data Gateway de façon à pouvoir modéliser les données dans une base de données sur site.
Dans Oracle Analytics, vous pouvez modéliser les données sur site pour de nombreux types de base de données. Oracle Analytics prend en charge l'accès direct à certaines sources de données sur site via le modèle sémantique. Lorsque vous créez une connexion à la base de données à l'aide de l'outil d'administration de modèle, utilisez le format DSN approprié pour le type de base de données auquel vous établissez cette connexion dans le champ Nom de source de données de la boîte de dialogue Pool de connexions (onglet Général).
Amazon Redshift: DRIVER=Oracle 7.1 Amazon Redshift Wire Protocol;HOST=["host-name"];PORT=["port"];DB=["service-name"] SSL: DRIVER=Oracle 7.1 Amazon Redshift Wire Protocol;HOST=["host-name"];PORT=["port"];DB=["service-name"];EM=6;CPV=TLSv1.2,TLSv1.1,TLSv1, SSLv3, SSLv2;VSC=0 Apache Drill: DRIVER=MapR Drill ODBC Driver;Host=["host-name"];Port=["port"];CastAnyToVarchar=true;ExcludedSchemas=sys,INFORMATION_SCHEMA;AuthenticationType=Basic Authentication;ConnectionType=Direct Aster: DRIVER=Aster ODBC Driver;SERVER=["host-name"];PORT=["port"];DATABASE=["service-name"] DB2: DRIVER=Oracle 7.1 DB2 Wire Protocol;IpAddress=["host-name"];PORT=["port"];DB=["service-name"] SSL: DRIVER=Oracle 7.1 DB2 Wire Protocol;IpAddress=["host-name"];PORT=["port"];DB=["service-name"];EM=1;VSC=0 Greenplum: DRIVER=Oracle 7.1 Greenplum Wire Protocol;HOST=["host-name"];PORT=["port"];DB=["service-name"] Hive: DRIVER=Oracle 8.0 Apache Hive Wire Protocol;HOST=["host-name"];PORT=["port"] SSL: DRIVER=Oracle 8.0 Apache Hive Wire Protocol;HOST=["host-name"];PORT=["port"];EM=1;VSC=0 Impala: DRIVER=Oracle 7.1 Impala Wire Protocol;HOST=["host-name"];PORT=["port"] SSL: DRIVER=Oracle 7.1 Impala Wire Protocol;HOST=["host-name"];PORT=["port"];EM=1;VSC=0 Informix: DRIVER=Oracle 7.1 Informix Wire Protocol;HOSTNAME=["host-name"];PORTNUMBER=["port"];DATABASE=["service-name"] MongoDB: DRIVER=Oracle 8.0 MongoDB;HOST=["host-name"];PORT=["port"];DB=["service-name"] MySQL: DRIVER=Oracle 7.1 MySQL Wire Protocol;HOST=["host-name"];PORT=["port"];DB=["service-name"] PostgresSql: DRIVER=Oracle 7.1 PostgreSQL Wire Protocol;HOST=["host-name"];PORT=["port"];DB=["service-name"] Spark: DRIVER=Oracle 8.0 Apache Spark SQL;HOST=["host-name"];PORT=["port"] SSL: DRIVER=Oracle 8.0 Apache Spark SQL;HOST=["host-name"];PORT=["port"];EM=1;VSC=0 SQL Server: DRIVER=Oracle 7.1 SQL Server Wire Protocol;HOST=["host-name"];PORT=["port"];DB=["service-name"] SSL: DRIVER=Oracle 7.1 SQL Server Wire Protocol;HOST=["host-name"];PORT=["port"];DB=["service-name"];EM=1;VSC=0;CryptoProtocolVersion=TLSv1.2,TLSv1.1,TLSv1,SSLv3,SSLv2 Sybase: DRIVER=Oracle 7.1 Sybase Wire Protocol;NA=["host-name"], ["port"];DB=["service-name"] Teradata: DRIVER=Oracle 7.1 Teradata;DBCName=["host-name"];port_name=["port"]