MicroStrategy ONE

Database relazionali che possono essere connessi tramite un server proxy HTTP

È possibile creare connessioni ai database tramite server proxy. I seguenti database possono essere connessi tramite un server proxy HTTP utilizzando gli esempi di stringhe di connessione.

Gateway certificati ed esempi di stringhe di connessione

Banca dati Stringa di connessione ODBC Stringa di connessione JDBC
Microsoft SQL Server
Copia
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname={hostname}; Port={port}; Database={database}; AuthenticationMethod=1;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;Driver={com.microstrategy.jdbc.sqlserver.SQLServerDriver};URL={jdbc:microstrategy:sqlserver://{hostname}:{port};DATABASENAME={database};fetchTWFSasTime=TRUE;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Amazon Redshift
Copia
DRIVER={MicroStrategy ODBC Driver for Amazon Redshift Wire Protocol}; HostName={hostname}; PortNumber={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;DRIVER={com.microstrategy.jdbc.redshift.RedshiftDriver};URL={jdbc:microstrategy:redshift://{hostname}:{port};DatabaseName={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Azure Synapse Analytics
Copia
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname={hostname}; Port={port}; Database={database}; EncryptionMethod=1; ValidateServerCertificate=0;EnableQuotedIdentifiers=1;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;Driver={com.microstrategy.jdbc.sqlserver.SQLServerDriver};URL={jdbc:microstrategy:sqlserver://{hostname}:{port};DATABASENAME={database};EncryptionMethod=SSL;ValidateServerCertificate=false;fetchTWFSasTime=TRUE;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Istanza gestita SQL di Azure
Copia
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname={hostname}; Port={port}; Database={database}; EncryptionMethod=1;AuthenticationMethod=1;ValidateServerCertificate=0;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;DRIVER={com.microstrategy.jdbc.sqlserver.SQLServerDriver};URL={jdbc:microstrategy:sqlserver://{hostname}:{port};DatabaseName={database};EncryptionMethod=SSL;ValidateServerCertificate=false;fetchTWFSasTime=TRUE;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
MySQL
Copia
DRIVER={MySQL ODBC 8.0 Unicode Driver}; SERVER={hostname}; PORT={port}; DATABASE={database};DriverUnicodeType=1;FORWARD_CURSOR=0;NO_CACHE=0;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;DRIVER={com.mysql.jdbc.Driver};URL={jdbc:mysql://{hostname}:{port}/{database}?useCursorFetch=true&defaultFetchSize=1000&ProxyMode=1&ProxyHost={proxyserverhost}&ProxyPort={proxyport}};

PostgreSQL

Copia
DRIVER={MicroStrategy ODBC Driver for PostgreSQL Wire Protocol}; HostName={hostname}; PortNumber={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;Driver={com.microstrategy.jdbc.postgresql.PostgreSQLDriver};URL={jdbc:microstrategy:postgresql://{hostname}:{port};DATABASENAME={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Oracle
Copia
DRIVER={MicroStrategy ODBC Driver for Oracle Wire Protocol}; HostName={hostname}; PortNumber={port}; SERVICENAME={servicename}; AlternateServers=; EnableNCharSupport=1; IANAAppCodePage=111;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;DRIVER={com.microstrategy.jdbc.oracle.OracleDriver};URL={jdbc:microstrategy:oracle://{hostname}:{port};ServiceName={servicename};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};

Snowflake

Copia
DRIVER={SnowflakeDSIIDriver ODBC};SERVER={hostname};DATABASE={database};SCHEMA={schema};WAREHOUSE={warehouse};Proxy={proxyserverhost}:{proxyport};
Copia
JDBC;DRIVER={net.snowflake.client.jdbc.SnowflakeDriver};URL={jdbc:snowflake://{hostname}/?warehouse={warehouse}&db={database}&schema={schema}&useProxy=true&proxyHost={proxyserverhost}&proxyPort={proxyport}};
IBM Db2
Copia
DRIVER={MicroStrategy ODBC Driver for DB2 Wire Protocol}; IpAddress={hostname}; TcpPort={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;DRIVER={com.microstrategy.jdbc.db2.DB2Driver};URL={jdbc:microstrategy:db2://{hostname}:{port};DATABASENAME={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};

MongoDB

Copia
Driver={MicroStrategy ODBC Driver for MongoDB}; hostname={hostname}; Port={port}; Database={database}; SD=#TEMP_PATH#123;WhereClauseHandlingMode=0;ReadOnly=0;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copia
JDBC;DRIVER={com.microstrategy.jdbc.mongodb.MongoDBDriver};URL={jdbc:microstrategy:mongodb://{hostname}:{port};DATABASENAME={database};ValidateServerCertificate=false;EncryptionMethod=noEncryption;ReadOnly=false;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};SchemaMap=#TEMP_PATH#/tpch-jdbc-proxy/;};