Konfiguriranje i registracija servisa Data Gateway za izvješćivanje

Izvršite ove neobvezne korake za omogućavanje udaljenih veza u značajkama za Classic, poput analiza i dashboarda.

Ako implementirate samo vizualizaciju podataka (na primjer, Oracle Analytics Cloud Professional Edition), ne morate slijediti te korake.

Prije početka slijedite korake za konfiguraciju u Konfiguriranje servisa Data Gateway za vizualizaciju podataka.

Zatražite naziv računala i broj ulaza za računalo na koje ste instalirali agent za Data Gateway.
U poslužiteljskoj implementaciji:
1. Izvršite naredbu /<Data Gateway install folder>/domain/bin/status.sh.
2. U izlaznim podacima naredbe zabilježite naziv računala sadržan unutar URL-a prikazan pod opcijom Status servisa Data Gateway i zabilježite vrijednost Data Gateway Jetty HTTP Port.
U osobnoj implementaciji:
1. Otvorite datoteku: %localappdata%\Temp\DataGateway\ports.properties.
2. Zabilježite naziv računala i broj ulaza.
Pokrenite agenta za Data Gateway.
Ako podatke želite modelirati prije udaljenog povezivanja, za uređivanje semantičkog modela upotrijebite alat Semantic Modeler ili alat Model Administration Tool (ako alat za modeliranje semantike ne podržava bazu podataka).
Ako upotrebljavate alat Model Administration Tool, učitajte izvorne metapodatke Java podataka.
1. U alatu za administriranje modela, u izborniku Datoteka pritisnite Otvori, a zatim U oblaku i u dijaloškom okviru Cloud odaberite Otvori kako biste definirali pojedinosti svog semantičkog modela.
2. Na izborniku Datoteka pritisnite Učitaj Java izvore podataka.
3. U dijaloškom okviru Priključivanje na poslužitelj Java izvora podataka:
  - U polje Naziv glavnog računala unesite naziv računala koji ste zabilježili u koraku 1. Potpuno kvalificirajte naziv glavnog računala. Na primjer, ako ste zabilježili machine u 1. koraku, trebali biste definirati machine.us.example.com.
  - U polje Ulaz unesite ulaz koji ste zabilježili u koraku 1. Na primjer, 51811.
  - U polja Korisničko ime i Lozinka unesite dummy ili bilo koji niz (ovim se sigurnosnim podacima ne provjerava valjanost jer se radi o javnom pozivu čija je svrha otkriti mogućnosti pridružene servisu Data Gateway).
Ako upotrebljavate alat Model Administration Tool, postavite fizičku vezu s bazom podataka:
1. U fizičkom sloju stvorite lokalnu (ne udaljenu) vezu s izvorom podataka putem standardnog sučelja za uspostavljanje poziva prikladnog za izvor podataka i modelirajte podatke prema potrebi.
2. Ako ste spremni uspostaviti udaljenu vezu sa semantičkim modelom i ponovo ga objaviti u oblak, uredite vezu koju ste stvorili.
3. Na kartici Općenito, u polju Sučelje pozivanja odaberite JDBC (Direct Driver), a u polju Niz za povezivanje definirajte JDBC niz i sigurnosne podatke u vezi semantičkog modela. Pod naslovom JDBC i JNDI predlošci i primjeri potražite popis podržanih JDBC nizova i klasa upravljačkog programa.
4. Na kartici Razno, u polju Upotrijebi SQL umjesto HTTP-a unesite vrijednost točno, a u polje RDC verzija unesite vrijednost 2 i definirajte klasu upravljačkog programa za JDBC.
5. Objavite semantički model u oblak.

Sada ste spremni za testiranje implementacije uspostavljanjem daljinske veze s lokalnom bazom podataka.

JDBC i JNDI predlošci i primjeri

Tijekom postavljanja udaljene veze za analize i dashboarde vjerojatno ćete morati definirati JDBC nizove i klase upravljačkih programa, kao i pojedinosti veze JNDI i pojedinosti konteksta.

JDBC uzorci niza i klase upravljačkog programa

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\"]

JNDI predlošci za nativne upravljačke programe

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" />

JNDI predlošci za DD upravljačke programe

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" 
/>

Dodavanje JDBC upravljačkog programa u Data Gateway

Dodajte JDBC upravljački program u instalaciju za Data Gateway kako biste mogli modelirati podatke u lokalnoj bazi podataka.

Prije nego što započnete, uvjerite se kako su Data Gateway i alat za administriranje modela instalirani na istom računalu sa sustavom Windows u vašem lokalnom okruženju.

Preuzmite JDBC upravljački program koji želite implementirati.
Npr., za modeliranje podataka u bazi podataka Snowflake, preuzmite najnoviji upravljački program za Snowflake JDBC (npr., u datoteci snowflake-jdbc-3.9.0.jar).
Kopirajte preuzetu JDBC JAR datoteku u instalacijsku mapu za Data Gateway.
- U poslužiteljskoj implementaciji JAR datoteku kopirajte u: <Data Gateway install_location>/domain/jettybase/thirdpartyDrivers.
- U osobnoj implementaciji unutar sustava Windows JAR datoteku kopirajte u: <Data Gateway_extract_path>\thirdpartyDrivers.
- U osobnoj implementaciji unutar sustava MacOS JAR datoteku kopirajte u: <Application->Show Package Contents>Resources->app.nw-> thirdpartyDrivers.
Ponovno pokrenite Data Gateway. Pogledajte Održavanje servisa Data Gateway.

DSN formati za definiranje izvora podataka

U servisu Oracle Analytics možete modelirati lokalne podatke za različite vrste baza podataka. Oracle Analytics podržava izravni pristup određenim lokalnim izvorima podataka putem semantičkog modela. Nakon što izradite vezu s bazom podataka s pomoću alata za administriranje modela, u polju Naziv izvora podataka dijaloškog okvira Skup veza (kartica Općenito) upotrijebite odgovarajući DSN format za vrstu baze podataka s kojom se povezujete.

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"]