在Excel 用户之间共享数据的一种好方法就是使用 Office 数据连接 (ODC) 文件。 它们设计为可移植且易于更新。 我们建议采用以下方法,使用 Power Query 形状的数据共享外部数据源。 本示例使用从数据工作簿导入的数据共享工作簿。 但是,此过程适用于 Excel 可以导入和连接的几乎所有外部数据源。 ...
ODC_JAR_FILE指定 Jar 文件目录。默认路径:/opt/odc/lib/odc-web-starter-*.jar。 ODC_WORK_DIR指定 ODC 工作目录。默认路径:/opt/odc/script。 ODC_JVM_HEAP_OPTIONS指定 JVM 内存配置。默认值:-XX:MaxRAMPercentage=60.0 -XX:InitialRAMPercentage=60.0,表示使用 60% 的的内存,可通过指定参数ODC_JVM_HEAP_...
ODC_JVM_GC_OPTIONS指定 JVM GC 策略。默认指定:-XX:+UseG1GC -XX:+PrintAdaptiveSizePolicy -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+PrintGCDateStamps -Xloggc:/opt/odc/log/gc.log -XX:+UseGCLogFileRotation -XX:GCLogFileSize=50M -XX:NumberOfGCLogFiles=5。
However, the Power BI dataset has a PROD and TEST version and I have been asked to allow the Excel files to be “switched between”. So effectively there are two different Dataset IDs so there should be two different “Connection Strings” in the ODC file (or two different ODC files for...
Information in this article describes how you can create an Office Data Connection file to connect to an Azure Analysis Services server from Excel 2016 version number 16.0.7369.2117 or earlier, or Excel 2013. An updated MSOLAP.7 provider is also required....
Copy the sample connection file below and paste into a text editor. Inodc:ConnectionString, change the following properties: InData Source=asazure://<region>.asazure.windows.net/<servername>;change<region>to the region of your Analysis Services server and<servername>to the name of your server...
The XML in an ODC file determines the core connection information for the data source. This information includes:Data provider-specific connection string that is used to establish and open a connection to the data source Query text that is used to fetch data Name of the specif...
I would like to create an .odc file to connect to SQL Server 2005 within a C# project. I am using the SQL connection to create an XYTheme from a table and would like the .odc connection to be created and discarded after use each time the program runs.Here is the code that I have...
Variant 类型，可选。可用于搜索该文件的以空格分隔的关键字。Excel VBA教程：SaveAsODC方法·示例 下例将缓存的源保存为名为“ODCFile”的 ODC 文件。本示例假定数据透视表缓存位于活动工作表上。Sub UseSaveAsODC() Application.ActiveWorkbook.PivotCaches.Item(1).SaveAsODC ("ODCFile")End Sub ...
at com.oceanbase.tools.loaddump.dumper.sql.SqlFileDumper.generateDumpTasksForPrivateCloud(SqlFileDumper.java:195) ~[ob-loader-dumper-3.0.2-BP3-SNAPSHOT.jar!/:?] at com.oceanbase.tools.loaddump.dumper.sql.SqlFileDumper.generateDumpTasks(SqlFileDumper.java:96) ~[ob-loader-dumper-3.0.2-BP3-...