Your Data Journey Starts Here

Recent activity
Help others
Categories

Using Dataverse ODBC - how to query choicelabels?

Using the ODBC driver, I am trying to query ChoiceLabels - this simple query works in SSMS but not using the ODBC driver in my reporting application: select * from choicelabels The odbc driver returns:A table could not be found that matches choicelabels.Is there something else I need to do to query this table? I need to join it against an entity table in order to decode the choice value.

9 hours ago

matthewrEmployee

CData Drivers

Encountering "The catalog needs to be specified in the TABLE or VIEW property" error when querying an Oracle connection

When specifying the name of a table in the Tables connection property (or the name of a view in the Views property), you may receive the following error when querying a table in your Oracle connection (even if the connection was successfully tested):The catalog needs to be specified in the TABLE or VIEW property.However, Oracle does not make use of catalogs. With this in mind, what should be done to work around the error?

1 day ago

pmaharjanApprentice

CData DBAmp

Setup Two DBAmp Linked Server in SQL Server 2022

Is it possible to create DBAmp linked server for two salesforce instance in single SQL server with latest DBAmp setup? Seems like there is no option to configure two product key in DBAmp Config2. There was option to set it up in DBAmp v_59109.

2 days ago

pmaharjanApprentice

CData DBAmp

Salesforce Linked Server on SQL Server 2022, Windows OS 2022

is DBAmp v_50109 supported on SQL Server 2022 with Windows OS 2022? The linked server is not working on it. Same is working fine on SQL Server 2016.

2 days ago

SlackerApprentice

CData Sync

set default Schema for SQL Server

Is there a way to set a default Schema to default to when saving information into SQL server? I know how to do it by each table but find my self forgetting from time to time.

2 days ago

emmanuelkattoNewcomer

CData Drivers

Methods for achieving real-time data synchronization - Emmanuel Katto

Hello Everyone, My name is Emmanuel Katto. I wanted to know what are the methods for achieving real-time data synchronization using CData connectors? Are there particular connectors better suited for this? Looking forward to your suggestions. Thanks in advance! Best,Emmanuel Katto

3 days ago

Dorando MyslimiEmployee

Data Sources

Steps to create a custom role with RBAC permissions on Azure to manage an Azure Cosmos DB for NoSQL account.

Sometimes clients face permission errors while trying to authenticate using 'Azure AD' or 'Azure Service Principal' AuthScheme with our CosmosDB driver. One of them is the RBAC (role-based access control) error permission: java.sql.SQLException: [Forbidden] Request blocked by ........: Request for Read DatabaseAccount is blocked because principal [******] does not have required RBAC permissions to perform action [Microsoft.DocumentDB/databaseAccounts/readMetadata] on any scope. Learn more: https://aka.ms/cosmos-native-rbac. This kind of error is typically thrown due to some role missing. The main issue here is that this role isn't available to be configured from the UI just like we can configure other roles. The only way to add it, based on the API Documentation is by creating a custom role with the following RBAC permission (Microsoft.DocumentDB/databaseAccounts/readMetadata) from Cloud Shell which then will be assigned to an identity so that our applications can access resources in A

190

6 days ago

kristinabEmployee

Data Sources

Encountering “The schema name ‘REST’ is invalid” error when refreshing the published SharePoint data on Tableau Server

In this article we are going to explain how to overcome the “The schema name ‘REST’ is invalid” error, after publishing the data source configured with the CData Tableau Connector for SharePoint from Tableau Desktop to Tableau Server. The CData Tableau connector must first be registered with Tableau Desktop and then with Tableau Server before it can be used to publish workbooks or flows. Registering the connector in this case refers to installing the connector and properly placing the .taco files that come in the installation folder of the connector, in the correct directories. These files can be found in the lib folder of the installation directory. On Windows, they can be located at the following path: C:\Program Files\CData\CData Tableau Connector for Microsoft SharePoint 2023\lib\ Note that we have two types of .taco files: Versions between 2020.1 and 2020.3 of Tableau Desktop are supported via the legacy connector file (cdata.sharepoint.legacy.taco) and versions 2020.3 and hi

6 days ago

kmauzoulNewcomer

Developers

DBAmp - Replicating Field History Tracking objects

Good Day, Background: Our current business requires that the Field History Tracking objects be replicated for reporting. The initial replicate works, but the refresh we have scheduled to run hourly fails as the call to getDeleted returns 600000 or more deleted records - My initial thoughts are that these field tracking objects do not contain a SystemModstamp field and so DBAmp uses the data the table was created vs the last time the Refresh was ran (someone can correct me if I am wrong)I understand that there is a limitation of objects needing the SystemModstamp field for proper replication / refreshing but has anyone successfully replicated / refreshed (in a reasonable time interval) Field History Tracking objects? Any help would be greatly appreciated.

10 days ago

JohnCommunity Manager

CData Virtuality

Let’s Discuss the Exciting New Features in CData Virtuality 4.8!

Hey everyone, Great news! CData has just released Virtuality 4.8, and it’s packed with fantastic new features that could significantly enhance our data virtualization experience. I wanted to share some highlights and start a conversation about how these updates might benefit us. Resource Governor One of the standout additions is the new Resource Governor feature. It gives administrators greater control by allowing them to: • Set user-specific limits on the number of concurrent queries.• Restrict the size of data retrieved from queries.• Define maximum query durations for users. These enhancements aim to optimize resource usage and improve overall system performance. What are your thoughts on these new resource management capabilities? Do you see this helping to streamline operations in your environment? Time-Zone Based Job Management Managing jobs across different time zones can be a challenge, but Virtuality 4.8 introduces a solution: • Schedule jobs according to account-level or job-

14 days ago

DaveJones4Apprentice

CData Drivers

Using Dataverse ODBC - how to query choicelabels?

9 hours ago

pmaharjanApprentice

CData DBAmp

Setup Two DBAmp Linked Server in SQL Server 2022

2 days ago

pmaharjanApprentice

CData DBAmp

Salesforce Linked Server on SQL Server 2022, Windows OS 2022

is DBAmp v_50109 supported on SQL Server 2022 with Windows OS 2022? The linked server is not working on it. Same is working fine on SQL Server 2016.

2 days ago

SlackerApprentice

CData Sync

set default Schema for SQL Server

Is there a way to set a default Schema to default to when saving information into SQL server? I know how to do it by each table but find my self forgetting from time to time.

2 days ago

emmanuelkattoNewcomer

CData Drivers

Methods for achieving real-time data synchronization - Emmanuel Katto

3 days ago

JdotceeApprentice

CData Drivers

Visual getting started guide for JDBC ODBC driver

Do we have a visual JDBC ODBC bridge getting started guide? Unfortunately, I’m a visual learner and I can’t find visual resources on how to set it up on my device. I’m using Microsoft Server

16 days ago

leoarthurApprentice

CData Drivers

Best Practices for Organizing a Server Rack to Optimize Airflow and Cooling

Hey everyone,I’m looking for advice on how to effectively organize a server rack to optimize airflow and cooling. As we all know, proper airflow is crucial in preventing overheating and ensuring the longevity of our equipment. Here are a few best practices I’ve come across, and I’d love to hear your thoughts or additional tips!Top-to-Bottom Airflow: Position servers so that the air intake fans face the front of the rack, and the exhaust fans face the back. This helps create a clear path for cool air to flow in and hot air to escape. Use Blank Panels: Install blanking panels in unused rack spaces to prevent hot air from recirculating into the cold aisle, maintaining a consistent temperature. Cable Management: Keep cables organized and out of the airflow path. Using cable ties and management trays can help maintain clear airflow channels. Regular Maintenance: Regularly check and clean filters and fans to ensure that dust and debris don’t impede airflow. Monitor Temperature: Utilize tempe

16 days ago

muthuEOLApprentice

CData Connect Cloud

Deleted Reporting Balance Row Track

How to track which reporting balance row is deleted? because I am syncing record through Power automate. I am not able to track which row is deleted in reporting balance. if i get to know about that transaction I will sync that particular row related records again I am using cdata cloud

22 days ago

leoarthurApprentice

CData Connect Cloud

Best Practices for Integrating CData Connectors with Cloud Solutions

Hi everyone,I’m currently working on a project that involves integrating CData connectors with various cloud solutions. I want to ensure that I’m following best practices to optimize performance and maintain security.Great question! Here are some best practices to consider when integrating CData connectors with cloud solutions:Use Secure Connections: Always enable SSL/TLS for data in transit to protect sensitive information. Ensure that your cloud environment supports these protocols. Optimize Data Retrieval: Use pagination and filtering options provided by CData connectors to limit the amount of data retrieved at once. This helps reduce load times and resource consumption. Connection Pooling: Implement connection pooling to manage database connections efficiently, reducing overhead and improving response times. Monitor Performance: Regularly monitor the performance of your integrations. Use logging and analytics tools to identify bottlenecks or errors. Stay Updated: Keep your CData co

22 days ago

loisine.ann.mendozaCollaborator

CData Sync

The SQL Error Number is 102, State is 1, Severity is 15, Error is 'Incorrect syntax near 'f8a8d2f'.', Server name is AWDAPPINDB3, Line number is 1.The Token Type is 170

:45:17.636-06:00 1 [42|Q-Id] [META|Schema] Executed column schema query: [App_History] Success: 4 results (268 ms)2024-09-10T21:45:17.636-06:00 2 [42|Q-Id] [EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE SchemaName = @schema AND TableName = @table] Success: (268 ms)2024-09-10T21:45:17.636-06:00 2 [42|Q-Id] [EXEC|Parsed] Executing query: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]2024-09-10T21:45:17.636-06:00 2 [42|Q-Id] [EXEC|Parsed] Parameter: pk_b0 = 0f8a8d2f-1266-4f33-86ed-0d94f446125c2024-09-10T21:45:17.636-06:00 5 [42|Q-Id] [META|Schema] Engine Invalid object name 'App_History'2024-09-10T21:45:17.636-06:00 3 [42|Q-Id] [TCP |Send ] Send Begin - Length: 2742024-09-10T21:45:17.636-06:00 5 [42|Q-Id] [TCP |Send ] [SQL |Messag] Query Failed: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]. Error: The SQL Error Number is 102

24 days ago

Welcome

Everything you need to know about this community

Getting Started

31 topics
11 Replies

Foundations

0 topics
0 Replies

Live Connectivity

Ask questions, get answers, and engage in discussions about real-time data connectivity solutions from CData.

CData Drivers

122 topics
224 Replies

CData Connect Cloud

34 topics
46 Replies

Enterprise Data Virtualization

Ask questions, get answers, and engage in discussions about data integration solutions from CData.

CData Virtuality

66 topics
2 Replies

B2B Integration

Ask questions, get answers, and engage in discussions about B2B integration solutions from CData.

CData Arc

115 topics
224 Replies

CData Sync

72 topics
153 Replies

CData DBAmp

28 topics
37 Replies

Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Events Calendar

Leaderboard

Show full leaderboard

Awarded Badges widget

DaveJones4has earned the badge Product Expert
matthewrhas earned the badge Product Expert
pmaharjanhas earned the badge Product Expert
emmanuelkattohas earned the badge Product Expert
Dorando Myslimihas earned the badge Product Expert

Show all badges

Browse the community

Getting started

What's new?

Events

Knowledge base

Product topics

Groups

Featured topics

Welcome

Getting Started

Foundations

Live Connectivity

CData Drivers

CData Connect Cloud

Enterprise Data Virtualization

CData Virtuality

B2B Integration

CData Arc

CData Sync

CData DBAmp

Events Calendar

Leaderboard

Awarded Badges widget

Need more help?

Resources

Contact support

Your Data Journey Starts Here

Browse the community

Featured topics

Events Calendar

Leaderboard

Awarded Badges widget

Need more help?

Sign up

CData Community

Scanning file for viruses.

This file cannot be downloaded