Unanswered questions

5 Topics

Q
quangdutran809Collaborator
asked in CData Drivers & Connectors

Azure Analysis Services JDBC Driver does not return any tables/schema data

Hi team, I have connected to AAS successfully using jar file:  But when I try to fetch data, nothing is returned. For example getting the metadata:ResultSet columns = databaseMetaData.getColumns(null,null,null,null)Or select from system tables:statement.execute("SELECT * FROM [sys_schemas]");They all return nothing, empty result set.Why?

2
Q
1 day ago
D
dean.roeserApprentice
asked in CData Drivers & Connectors

Syncing ASP.NET CData Driver Versions Between Multiple Developers

Hello! I work for an ETL service that builds some of its connectors based on CData drivers. We now have multiple developers trying to work on these connectors, some of which were built based on older CData drivers. However, when a new developer downloads the latest driver, it causes incompatibility issues if there have been major changes. Is there any tool for version control for CData drivers that is available? Is there another solution that can solve this problem? Is there any way to download older versions of the drivers? Thanks!

0
D
1 day ago
N
NeilHApprentice
asked in CData DBAmp

Data transport when using DBAmp remotely

If we configure DBAmp to use a remote server (e.g. Azure managed SQL), does all data flow through the server where DBAmp is installed?  And if so, what is the transport-layer security between the DBAmp-server and the remote server?

0
N
2 days ago
Q
quangdutran809Collaborator
asked in CData Drivers & Connectors

SQL Analysis Services JDBC Driver detects all column as VARCHAR

Hi Cdata folks,Cdata driver latest version v23Weird thing is that SQL Analysis Services JDBC Driver detects all column as VARCHAR no matter what type of the model column: This is the model in Visual Studio: Before importing, the data type is also detected correctly in Visual Studio:   But in meta data, type for all columns is VARCHARThis is how I get the metadata:Connection conn = DriverManager.getConnection("jdbc:ssas:AuthScheme=BASIC;User=user;Password=pwd;URL=http://HOST/OLAP/msmdpump.dll;");Statement stat = conn.createStatement();DatabaseMetaData databaseMetaData = conn.getMetaData(); try(ResultSet columns = databaseMetaData.getColumns("TabularProject3","Model","Table","integer")){ while(columns.next()) { System.out.println(columns.getString("COLUMN_NAME")); System.out.println(columns.getString("DATA_TYPE")); System.out.println(columns.getString("COLUMN_SIZE")); System.out.println(columns.getString("TYPE_

0
Q
8 days ago
R
RahmanfpApprentice
asked in CData Sync

Failed to use backup setting

Hi, So I have a system with CDataSync to sync my data from SQL Server to Azure Synapse with below detail: Old System:CDataSync Version: 22.0.8342.0CData AzureSynapse Provider Version: 22.0.8326.0 New System:CDataSync Version: 23.3.8704.0CData AzureSynapse (23.0.8616.0) I backup the old configuration and restore it to new configuration. However, it keeps getting an error like this Error: The SQL Error Number is 103010, State is 1, Severity is 16, Error is 'Parse error at line: 1, column: 126: Incorrect syntax near '.'.', Server name is server1, Line number is 1. The Token Type is 170. I found that the task is successful when I use this conditions:I dont use a new scheme for the destination, but I checked the Drop Table/Truncate Table I use a new scheme, but I unchecked the Drop Table/Truncate TableIs there a new query or options that changed in the new version? What can I do to fix the error? Thank you

0
R
23 days ago

Badge winners

  • Product Expert
    dean.roeserhas earned the badge Product Expert
  • Product Expert
    NeilHhas earned the badge Product Expert
  • Product Expert
    Ismete Mhas earned the badge Product Expert
  • Product Expert
    ReiMhas earned the badge Product Expert
  • Product Expert
    TechWizard2023has earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings