Live Connectivity

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!

1. ODBC Driver Download2. SQL Gateway

I am trying to connect my Neo4j Data with SQL server. I found that there are 2 options:1. CData Connect 2. CData ODBCBut for both I cannot connect my Neo4j Data. The following message is being shown:“Test connection failed. Error: Testing connection failed. Inner Error: Test Connection: Connection closed.”

If you are using an ODBC driver and wish to execute one of its stored procedures in Access, you will need to go to Create -> Query Design, and select Pass-Through. You can then write the query for the stored procedure, such as "EXECUTE CreateJob Action = 'Insert'". Upon selecting Run, you will be prompted to select your ODBC connection so the stored procedure can be used with it. 

When using a CData NetSuite connector for a NetSuite data source, you may encounter NULL data values that correspond to Date fields in your original data. This has been seen occurring when using the SuiteQL API in particular.To remedy the situation, one solution is to use a TO_DATE function in your SQL statement. For example, a field called “Purchase”.purchaseDate would be included in a manner such as the following:TO_DATE(“Purchase”.purchaseDate, ‘YYYY-MM-DD’) AS “purchase_date”where the date format and alias are adjustable based on your needs.

Hi, I am trying to use the NETSUITE ODBC driver within Visual Studio SSIS project, everything connects good but when selecting some tables, I noticed that there are some missing fields in the table, for example in the table item, the field subsidiary is missing:   But in the log file, the json has it:  Should I need to set something else in the configuration? How can I solve this? Thanks.

Hi , I am getting error while connecting GA4(Google Analytics 4) to Tableau desktop using cdata connect with cdata  connector and GoogleAnalytics by cdata.   If anyone has some suggestion on this or anyone is trying to achieve the same then let me know. Regards,Pankaj 

ObjectiveTrying to use a cData DSN in Excel to connect to an OLAP cube in Azure Analysis Services on macOS. I can successful setup the DSN in iODBC Data Manager and it tests successfully, but when I try to use the DSN in Excel I get a “Could not bind server socket: Operation not permitted”.   I have screen-grabbed all my steps below in the attached PDF.  

This error is thrown when querying Snowflake and indicates that a Snowflake object is unable to be accessed due to a permissions issue. To resolve this, please check that your user has access to (and that none of the user's roles are preventing access to) the Warehouse and Database listed in the connection string, as well as any specified Schema and Tables. Additionally, please check that these values have the correct spelling and casing (as Snowflake is case-sensitive).

Working on an Integration project with SAP Concur as source system. Need some clarity with the API versions and modules supported by JDBC driver. for SAP Concur. 

We are a new CData user, connecting Acumatica oData as the source to SQL Server OLE DB destination.  It works great for the initial configuration of the data flow, but we often change the underlying Acumatica query (i.e. add columns). I can’t seem to find a way to refresh the available columns in the CDdata Acumatica Source Editor screen.  If I click the preview button, the new columns appear there correctly with data, but how are the columns added to the Columns node of the Editor screen?  Along those lines, is there a way to refresh the list of available Generic Inquiries for new oData sources?  The first time you log into Visual Studio the list of available inquiries refreshes, but after that I have to just use the Advanced Editor and hand-write the name of the query.  Thanks for any feedback!

I am trying to insert a manual journal entry into Xero using below SQL insert statement. And I get the following error. “A validation exception occurred: The total Debits (1.50) must equal total credits (0.00)" It suggests that cdata is not processing it as one API post but as 2 posts and Xero spits back an error because it expects both lines in the POST api. INSERT into ManualJournals ( JournalLine_AccountCode, JournalLine_LineAmount, Narration) VALUES (620, 1.50, 'Test1'), (611, -1.50, 'Test1');Any ideas would be appreciated. 

The QuickBooks Gateway (formerly Remote Connector) is useful if you want to access QuickBooks in a situation where direct COM access to QuickBooks is not available, such as in ASP.NET, Java, or QuickBooks on a remote machine.To authenticate to the QuickBooks company file, you will first need to create a user in the QuickBooks Gateway. Upon pressing Test Connection on that user, a prompt will open and ask you to authenticate it to QuickBooks. Note that QuickBooks must be open as an administrator in single-user mode for this to succeed.Then, you will need to open the QuickBooks DSN/Connection Manager/Connection String Builder and, in the Remote section, enter the information on the QuickBooks Gateway user you just created. The User and Password will be the username and password of your QuickBooks Gateway user, and the URL will be the URL

Is it possible to connect to more than one QuickBooks company file? My organization uses a few company files, and I’m confused as to how to connect the driver to all of them.

Hi!I’m using the Excel add-in to connect to Zoho Books. I would like to get all “BillLineItems” from Zoho. The BillLineItems is a standard view or table.It is not possible to use the SELECT * command in order to retrieve all lineitems. It is required to a specify a BillID (key) number in order to get the data for that specific bill from this table (as I understand).Maybe it is my lack of knowledge of SQL. Do you have any suggestions how to get all BillLineitems? Thanks in advanve for your response.Regards,Marc

When double clicking on the CData source, I am getting the following error.  “Could not load file or assembly 'Microsoft.DataWarehouse, Version=17.3.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.” 

Issue encountered while extracting data using CDATA JDBC driver in Snaplogic. Specifically, we are receiving the following error message: "Class java.lang.Boolean cannot be cast to class java.lang.Number (java.lang.Boolean and java.lang.Number are in module java.base of loader 'bootstrap')" Thanks