MicroStrategy ONE

Bases de données relationnelles pouvant être connectées par un serveur proxy HTTP

Vous pouvez créer des connexions aux bases de données via un serveur proxy. Les bases de données suivantes peuvent être connectées via un serveur proxy HTTP à l'aide des exemples de chaîne de connexion.

Passerelles certifiées et exemples de chaînes de connexion

Base de données Chaîne de connexion ODBC Chaîne de connexion JDBC
Microsoft SQL Server
Copier 
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname={hostname}; Port={port}; Database={database}; AuthenticationMethod=1;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copier 
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
Copier 
DRIVER={MicroStrategy ODBC Driver for Amazon Redshift Wire Protocol}; HostName={hostname}; PortNumber={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copier 
JDBC;DRIVER={com.microstrategy.jdbc.redshift.RedshiftDriver};URL={jdbc:microstrategy:redshift://{hostname}:{port};DatabaseName={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Azure Synapse Analytics
Copier 
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};
Copier 
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}};
Instance gérée Azure SQL
Copier 
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};
Copier 
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
Copier 
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};
Copier 
JDBC;DRIVER={com.mysql.jdbc.Driver};URL={jdbc:mysql://{hostname}:{port}/{database}?useCursorFetch=true&defaultFetchSize=1000&ProxyMode=1&ProxyHost={proxyserverhost}&ProxyPort={proxyport}};

PostgreSQL
Copier 
DRIVER={MicroStrategy ODBC Driver for PostgreSQL Wire Protocol}; HostName={hostname}; PortNumber={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copier 
JDBC;Driver={com.microstrategy.jdbc.postgresql.PostgreSQLDriver};URL={jdbc:microstrategy:postgresql://{hostname}:{port};DATABASENAME={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Oracle
Copier 
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};
Copier 
JDBC;DRIVER={com.microstrategy.jdbc.oracle.OracleDriver};URL={jdbc:microstrategy:oracle://{hostname}:{port};ServiceName={servicename};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};

SnowFlake
Copier 
DRIVER={SnowflakeDSIIDriver ODBC};SERVER={hostname};DATABASE={database};SCHEMA={schema};WAREHOUSE={warehouse};Proxy={proxyserverhost}:{proxyport};
Copier 
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
Copier 
DRIVER={MicroStrategy ODBC Driver for DB2 Wire Protocol}; IpAddress={hostname}; TcpPort={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
Copier 
JDBC;DRIVER={com.microstrategy.jdbc.db2.DB2Driver};URL={jdbc:microstrategy:db2://{hostname}:{port};DATABASENAME={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};

MongoDB
Copier 
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};
Copier 
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/;};