CData Drivers

I’m getting the following exception when trying to run the following code.  Does the driver support the Trino JSON type?  I don’t see json referenced in GetResultTypeData method source.string sql = "SELECT _id, CAST(extra_columns AS JSON) as extra_columns FROM hive.default.measures";PrestoCommand cmd = new PrestoCommand(sql, connection);PrestoDataReader rdr = cmd.ExecuteReader();  Message: Test method Juniper.Test.Trino.TrinoClientTests.PrestoAdoRead threw exception: System.Data.CData.Presto.PrestoException: [500] Could not execute the specified command: Unknown datatype: JSON. ---> oro230j.TC: Unknown datatype: JSON. Stack Trace: ZN.GetResultDataType(FormulaEvaluationContext )RqC.K(SqlFormulaColumn )RqC.mI(SqlTable , SqlColumn )Rod.C(SqlCollection`1 )Rod.Nd(LLB`2 )Roh.Nd(LLB`2 )KJ.U(SQLQuery , Int32 , RRq )KJ.d(ID

I’m getting the following exception when trying to run the following code.Is there a way to enable or set the HTTP Header X-Trino-User?PrestoConnection connection = new PrestoConnection($"Server={_configuration["TrinoServerIP"]};Port={_configuration["TrinoServerPort"]};");connection.Open();string sql = "SELECT * FROM hive.default.customer";PrestoCommand cmd = new PrestoCommand(sql, connection);PrestoDataReader rdr = cmd.ExecuteReader();while (rdr.Read()){ Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["Id"], rdr["Name"]));} PrestoAdo  Source: TrinoClientTests.cs line 91  Duration: 1.4 sec Message: Test method Juniper.Test.Trino.TrinoClientTests.PrestoAdo threw exception: System.Data.CData.Presto.PrestoException: [500] Could not execute the specified command: HTTP protocol error.

Hi all,We are migrating from on-prem tabular models to PowerBI Premium models. Most datasources work flawlessly (including the CDATA Snowflake connector). However, we have been unable to use another tabular model as a data source when using PowerBI Premium models…We have the same problem when trying to connect to our Power BI Premium models from our data catalog (Ataccama). OLD On-prem Visual Studio source:Friendly connection name: [model name]Server or File Name: [server] \ [Folder]Database name: [Database name]OLD Ataccama /CDATA JDBC connector:jdbc:cdata:ssas:User=[user];catalog="[catalog]";URL=http://[server]/OLAP/msmdpump.dllNew Connections that work:Excel Connection (Power BI Premium Data Source):Provider=MSOLAP.8;Integrated Security=[];Persist Security Info=[];Initial Catalog=sobe_wowvirtualserver-[GUID];Data Source=pbiazure://api.powerbi.com;MDX Compatibility=

The inquiry is as outlined in the title: I am looking to establish a setup enabling the modification of dashboards and lenses within CRM Analytics directly from an Excel worksheet, ideally facilitating a live two-way connection. If this solution is exclusive to Tableau, I will continue my search. Any recommendations on alternative solutions or platforms to explore would be greatly appreciated!

Hey guys, I´ve facing an error with this MongoDB component.When I´m trying to setup my data flow at SSIS, I´m facing an error warning that the view that I´ve setup doesn´t exist look to screen shot below:The problem is not in my connection manager, because I can use the same process with an other collection, for example, any view I set, this error appear, Have anyone else seen this before?

When using the Python connector in conjunction with SQLAlchemy, we introduced a new dialect with the "_2" suffix to accommodate SQLAlchemy 2.0. For instance, the QB Python connector features a dialect named "quickbooks_2."Previously, we utilized automap_base in the following manner:engine = create_engine("quickbooks:///?<connection string>")However, if the customer wishes to employ SQLAlchemy 2.0 and prevent potential errors when using automap_base, the following code should be used:engine = create_engine("quickbooks_2:///?<connection string>")

I am using the 2023 xBase driver in dBeaver, and receiving this error:SQL Error [HY000]: ORDER BY is mandated in the OVER clause for the function row_number. The Query is:select distinct       'BNK' swityp,       cast(c.cbank_acct as varchar) oldkey,       row_number () over (order by g.cid) newkey,       '' del,       g.cgroup_cod,       g.acct_no,       g.acct_descr,       g.active,       g.cidfrom checkreg cjoin glacct g on g.cid = c.cbank_acctorder by g.cid As you can see I have an ORDER BY in the OVER clause. BTW, changing it to upper case has no effect. What am I missing? Does xBase only partially support row_number? Is there any documentation on the xBase driver and which syntax it supports?

I am wondering if your SAP ERP JDBC driver will help me with my requirement where my Java application running on an external server needs to be communicated with SAP Server via SAP's interfaces like RFC, BAPI, and IDoc.I am new to SAP and found your SAP ERP JDBC driver and SAP Java Connector (SAP JCo) and tried to find the suitable driver that would solve the purpose.Please correct me if I am wrong. SAP Java Connector (SAP JCo) works at the application layer of the SAP R/3 architecture; however, your SAP ERP JDBC driver works at the database layer. Am I understanding it right?

Hi,I'm using the CData ODBC Driver for NetSuite (version: 21.0.7867.0 release) to access a customer's NetSuite data. Within the ODBC driver's connection properties, there are no options available to explicitly specify whether to connect to Netsuite.com or Netsuite2.com. Instead, I can provide the Account Id and Version (default 2021_1) for the connection. What data source the CData ODBC Driver for NetSuite is utilizing—Netsuite.com or Netsuite2.com when connecting to the customer's NetSuite? Where can I get this information, thanks. 

Hello Team,Can you are aware for  connectors authentication  in restricted environment would require URL Whitelisting and for  Facebook , I have to “facebook.com” done.Still  doesn't work. Am I missing anything,Any quick response would be appreciated.BTW we are working on Facebook, Instagram, LinkedIn and  YouTube CDATA Conectors. RegardsNS   

Current servers are running with SQL 2016 version and in these servers we have CData.SSIS.Excel  (18.0.6705) with 2018 version. This Cdata version is running fine in current server.In the new server which is running on SQL 2019 version, we cannot install this version, so we installed a updated version(22.0.8509) . Below steps are getting performed for package migration from 2016 to 2019: We are converting the solution configuration from 2016 to 2019 and build the solution and deploy the solution to 2019 server. Error That we are getting in package : which was earlier using CData.SSIS.Excel  (18.0.6705) on sql 2016  and now using updated version(22.0.8509) on 2019 SQL server. When we opened the package on new 2019 server, we could not able see the cdata excel connection manager there. So we have to manually create a connection manager, select connection manager on source and deploying the package. What we are looking for is there a way , all

Here is a simple example of a query that works in FDConnection but not FDQuery.  This was tested on the 30 row Excel table using the CDataExcel driver id.  The first component returns a 30 row result set.  The second component fails on “field 2023-01 not found in subquery ….”select "Budgeted Items", "2023-01", "2023-02", "2023-03", "2023-04", "2023-05", "2023-06", "2023-07", "2023-08", "2023-09", "2023-10", "2023-11", "2023-12"  from(  select "Budgeted Items", "MonthNo", "Amount"   from "BUDGETED") as SourceTablePIVOT(  sum("Amount")  for  "MonthNo" in ("2023-01", "2023-02", "2023-03", "2023-04", "2023-05", "2023-06", "2023-07", "2023-08", "2023-09", "2023-10", "2023-11", "2023-12"))

We are facing issue in connecting to Teradata. On debugging we found the below error. Can someone help? 2023-08-25T09:34:58.217+0000 0 [4|Q-Id] [INFO|Connec] Executed connect: Error: com.teradata.jdbc.TeraDriver2023-08-25T09:34:58.218+0000 0 com.teradata.jdbc.TeraDriverjava.lang.ClassNotFoundException at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:594) at XcoreXcdata.realdb.gld.loadClass(Unknown Source) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:527) at java.base/java.lang.Class.forName0(Native Method) at java.base/java.lang.Class.forName(Class.java:315) at XcoreXteradataX220X8462.fcf.p(Unknown Source) at XcoreXteradataX220X8462.fcf.o(Unknown Source) at XcoreXteradataX220X8462.fcf.i(

I have deployed CDATA Sage Intacct ODBC Driver on an Azure Virtual Machine that also hosts a SQL Server for which we want to copy data from Sage Intacct to table(s) on SQL Server. I have set up my environment 2 ways described in the bulleted list below and BOTH options experience very high latency and slowness when trying to query tables and views created within the Sage Intacct data model; I experience especially very high latency and slowness when querying view, GLDetail, from the CDATA Sage Intacct ODBC Driver:CDATA SQL Gateway/Linked Server: I set up the ODBC Sage Intacct Driver as a service in SQL Gateway and set up a Linked Service on the SQL Server instance that lives on the same machine the SQL Gateway sits on. I followed the steps in the below articles to set it up and also applied caching which did n

Hello Experts,Can CDATA process  unstructured and semi-structured data. Please give us some pointers.

Tip:  Build and Deploy a multidimensional model of Snowflake data If you need to create cubes from Snowflake data for more efficient and comprehensive data analysis and you use SQL Server Analysis Services (SSAS) for building enterprise-grade semantic data models, this tip is for you!In a few achievable steps, use CData’s ADO.NET Provider for Snowflake to:Create a data source for Snowflake. Create a data source view. Create a cube for Snowflake. Process the project – deploy the cube to SSAS.Read this article for the detailed steps. Although this example references Snowflake data, CData has hundreds of other low-code ADO.NET Providers, check out this page.NOTE: For

At CData, we are committed to providing top-notch data connectivity solutions that optimize data source APIs by leveraging the native functionality of source systems. We constantly improve and maintain our solutions to comply with emerging technologies. To this end, we regularly release driver updates and introduce new drivers to meet market needs.With the most recent release, we are excited to share some notable enhancements for SAP Fieldglass, Shopify, SugarCRM, and improved user experience when using the connection manager.SAP FieldglassSAP Fieldglass is a cloud-based vendor management system that manages the procurement of services and external workforce management systems.  The CData Driver connectivity to SAP Fieldglass now exposes a broader range of data. For example, CData reveals the download data format, custom fields, and Connector names enabled and configured in SAP Fieldglass. CData views use the default SAP Fie

Use the /S Flag to uninstall CData Connectors in silent mode.Assume, for example, that you have the SharePoint ODBC driver installed on your machine in the location which is as follow: C:\temp\new folder. The file we require for uninstallation is uninstall.exe, which can be found inside these folder. The sample command for the same is as below. Make sure to run the command from an elevated shell to avoid the UAC prompt. Command: C:\temp\new folder\Uninstall.exe /S  

I know I’m missing some fundamental context of query building - but I just want to cobble something together and could use a bit of assistance.I’d like to use the Google Sheets Excel Add-In, or even the ODBC Driver for Google Sheets, to pull some data down from a live aggregate that exists in one of our team’s Google Sheets - and automatically push it periodically into an Excel sheet. It’d be the entire contents of one sheet, read-only (mono-directional), placed into a named table in an Excel sheet - easy peasy. Or so I thought.I initially installed the ODBC driver, connected it successfully, but it only gives me a “This data source contains no visible tables” message. And since there aren’t really any options or configs, I bailed on that and installed the Add-In.With the add-in, however, I can only seem to get it to list my account’s folders, workbooks, and sheets.  I can’t actually get it to read the

We currently have configured Google Analytics 4 with custom dimensions. We want to get that custom dimension out of GA4 using the CDATA Google Analytics provider with Google Analytics 4 selected. We get data out of the correct property, so everything seems to be connected right. But these are all standards reports so it seems, I want to get custom data out of it.What should I do or what query can I use to get 1 custom dimension (customer_number), with 1 metric (event count) filtered by page_path contains 'example’ and another custom dimension (asm_user) <> 'null’?

DataSource.Error: ODBC: ERROR [HY000] Specified cast is not valid.  i have 8 table in my database but if i connect to a specific table then it gives this error                                                                                                           DataSource.Error: ODBC: ERROR [HY000] Specified cast is not valid.Details:    DataSourceKind=CdataMongodb    DataSourcePath={"dsn":"CData Power BI MongoDB"}    OdbcErrors=[Table]

how can I access previous versions of a NetSuite JDBC driver. In particular I want to view the exact schema, data model for NetSuite JDBC Driver version 22.0.8322.0The latest/current version is JDBC Driver for NetSuiteBuild 23.0.8565https://cdn.cdata.com/help/DNJ/jdbc/ 

Hello, I am trying to use CData Rest Task to call a Rest API from Azure DevOps.  The goal will be to pull the capacity information from the call.  https://dev.azure.com/AIZ-Global/_apis/projects/2ef0bfbb-5826-423d-a8e7-c970f2268f59/teams/64155638-69bf-4173-b301-2022f7bb356c/members?api-version=5.1When I enter the URI into the into URI field  under the connection section and select test connection I get the following error message.   I am sure that I am doing something wrong here but not being a developer I am a little lost here. Any help would be appreciate.  If you need additional informati

I stumbled upon CData API Server, installed it, and was immediately impressed!  It seems to be a fantastic product - very simple and intuitive.  However, I was left with a few immediate questions:I can’t find any real documentation for it.  Is there some? Which forum should I use to post questions or look for answers? Can I change the naming convention of the resources created?  It appears they are named “[database]_[schema]_tableorview” by default.  I’d like to drop the “[database]_[schema]_”. Is there any kind of bulk editing action on the resources?  I have a lot of resources and I’d like to remove some operations on all of them.If the resources are controlled by some kind of config file (e.g. json or XML), and I can find it, I can probably do the bulk edits myself.Thanks in advance, and thanks again for a GREAT product!