Skip to main content

Unanswered questions

7 Topics
luciaonmatteo
luciaonmatteoApprentice
asked in CData Connect Cloud
How to Optimize Data Integration Performance on a Rack Server Environment?

Hi everyone,I'm currently working on setting up a robust data integration solution using CData's drivers in a corporate environment, and I'm encountering some challenges in optimizing performance. Our infrastructure includes a mix of cloud and on-premises data sources, and we're using a rack server setup for the on-prem data center. The server hosts multiple virtual machines that are running data connectors to sync data with our cloud-based systems.The issue I'm facing is data throughput and latency. Although our rack servers are equipped with ample processing power and memory, I’ve noticed that data transfers between on-prem databases (SQL Server and MySQL) and cloud systems (like Salesforce and Azure SQL) seem to be slower than expected. I'm wondering if anyone here has experienced similar issues or has recommendations on how to fine-tune performance in this type of server environment?Some of the steps I’ve already tried:Configuring the connection properties within the CData ODBC dri

110
luciaonmatteo
2 days ago
T
TrenaATApprentice
asked in Connect Spreadsheets
Connect Excel from SharePoint

Hi, I need to use cdata to bring in data from excel docs saved in a SharePoint folder. I previously build the report using the SharePoint folder link but now i need to change to use the cdata. Right now, my option is to bring in the files as individual tables but i want to automate the process. The automation in place, combines the files and brings in only 1 table into powerbi. When a new file is added to that sharepoint folder, i can simply refresh in powerbi and data from the new file will be uploaded. Is it possible to do this using cdata?

241
C
6 days ago
luciaonmatteo
luciaonmatteoApprentice
asked in CData Connect Cloud
Best Practices for Integrating DAS Storage with CData Connectors

Hi everyone,I’m looking for advice on the best practices for integrating Direct-Attached Storage (DAS) with CData connectors. We’re planning to use DAS for storage and need to ensure smooth data flow using CData connectors for our integration needs.Here are a few areas I’m focusing on:Configuration Tips – How should I set up DAS to work seamlessly with CData connectors? Performance Optimization – Any suggestions on maximizing speed and reducing latency during data transfers? Data Security – What are the best practices for securing data when using DAS and CData together? Troubleshooting – Common pitfalls or issues to watch out for in this kind of integration?I’d appreciate any experiences or advice from those who’ve worked with this setup!Thanks in advance! 

230
luciaonmatteo
16 days ago
luciaonmatteo
luciaonmatteoApprentice
asked in CData Arc
What are the security benefits of using Intel Core M vPro with CData's cloud data connectivity solutions?

Hello everyone,I’m curious about the security advantages of combining Intel Core M vPro technology with CData’s cloud data connectivity solutions. We know that Intel vPro is built with security features like Intel Active Management Technology (AMT) and hardware-based encryption, which offer enhanced protection for enterprise devices. But how does this integrate with CData's connectors, especially for cloud-based applications and databases?For instance, CData’s JDBC and ODBC drivers provide seamless connectivity to a wide range of cloud data sources. Using these in tandem with Intel security features could potentially streamline secure data access and reduce the risk of unauthorized access during data transactions.I’m particularly interested in how Intel’s built-in remote management and secure boot options could enhance the security of data connections when using CData’s cloud solutions. How do these technologies work together to ensure encrypted, secure data flows, especially in hybrid

160
luciaonmatteo
16 days ago
L
liostyApprentice
asked in CData Arc
What is ERP Implementation?

ERP Implementation refers to the process of deploying an Enterprise Resource Planning (ERP) system within a business. ERP systems integrate and manage core business processes, such as finance, human resources, supply chain, and customer relationship management, into a unified platform.

210
L
17 days ago
P
PradeepApprentice
asked in CData Arc
Accessing Files from Server

Hi Team, I was calling files from XML map connector to do cross reference from Input values to pick the respective values from list. This function working fine, and from yesterday i am facing the below error “System error: Access to the path 'C:\Users\ligEDIAdmin\Documents\SCJ\SCJCode.xlsx' is denied”  Same function works fine in Production environment, but in Test system i am facing the issue, We have worked with all network / server team and there where no changes made with access / permission levels. Still i am facing the issue, could anyone please help me out by pointing what is to be done to fix this issue. 

331
lohith
22 days ago
marcellosalas
marcellosalasApprentice
asked in CData Drivers
Issues Connecting to SQL Server with CData ADO.NET Provider - Need Help with Authentication Setup!

Hello everyone,,I am working on setting up a connection between my SQL Server database and a C# application using the CData ADO.NET provider for SQL Server but I am running into some authentication issues. I would like to use Windows Authentication but it doesn’t seem to be working as expected: I have double checked the connection string settings and ensured that "Integrated Security" is set to true. However,,, I keep getting an error related to login credentials.Has anyone here dealt with similar authentication issues using CData’s ADO.NET provider: ?? Also, if there’s a workaround to ensure the connection uses the current user’s Windows credentials,,, I would really appreciate any guidance. I have already gone through this thread https://community.cdata.com/cdata-sync-47/cdata-sync-error-when-creating-a-source-connection-to-sql-server-rpa/ but couldn’t get enough solution.Thanks in advance for your help, any suggestions or resources would be a huge help as I troubleshoot this.With Re

551
L
29 days ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings