What are the supported data ranges

1. Supported Connection types

vividime Server supports connection to multiple types of connections, including:

•Read the local text file as the text connection to create an Excel dataset;

•Connect relational database to generate SQL connection;

•Connect multidimensional database to generate multidimensional connection;

•Connect to other targets such as NoSQL database and server request to generate other connections.

2. Support scope

➢Note: Most databases can get the driver jars from the jar files in the lib directory in the relevant database installation directory, which are often the most suitable drivers.

2.1 SQL Connection

企业微信截图_17327743885943.png (426.23 KB, Number of downloads: 18274)

Upload

Click on the file name to download the attachment

2.2 Multidimensional connection & other connections

Connection	URL
KYLIGENCE MDX	Jdbc: xmla: Server=http://<Databaseserver>: 7080/mdx/xmla/<ProjectName>
ORACLE ESSBASE	Jdbc: xmla: Server=http://<Databaseserver>: 13080/aps/XMLA
SAP BW	Jdbc: xmla: Server=http://<Databaseserver>: 8000/sap/bw/xml/soap/xmla (MDX connection)
SSAS	Jdbc: xmla: Server=http://<Databaseserver>: 80/olap/msmdpump.dll
MONGO	Mongodb://<Databaseserver>: 27017
NEO4J	Bolt://<Databaseserver>: 7687 (driver: org. no4j. driver. Driver) Driver download: https://neo4j.com/bi-connector/?version=1.0.10
RESTful	Request address, no fixed format