Skip to main content

Live Connectivity

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

153 Topics
J
JdotceeApprentice
asked in 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

2
J
6 days ago
leoarthur
leoarthurApprentice
asked in 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

0
leoarthur
6 days ago
M
muthuEOLApprentice
asked in 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

1
Ethem Q
12 days ago
leoarthur
leoarthurApprentice
asked in 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

0
leoarthur
12 days ago
leoarthur
leoarthurApprentice
asked in CData Drivers
Best Practices for Optimizing CData Data Connectors with Intel Arc GPUs

Hi everyone,I’m currently working on a project that involves using CData data connectors with Intel Arc graphics cards. I want to ensure that I’m getting the best performance and efficiency out of this setup. Could anyone share best practices for optimizing CData data connectors specifically when using Intel Arc GPUs?Best Practices:Update Drivers: Ensure that both Intel Arc drivers and CData connectors are up to date to benefit from the latest performance improvements and bug fixes. Adjust Connection Settings: Configure CData data connectors to utilize multi-threading options if available. This can enhance performance, especially with the parallel processing capabilities of Intel Arc GPUs. Monitor GPU Usage: Use Intel's performance monitoring tools to check if the GPU is being fully utilized. Adjust settings in CData to match the GPU’s performance profile. Optimize Data Queries: Design efficient queries and avoid over-fetching data to reduce processing load. This helps in balancing the

0
leoarthur
14 days ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Reason for ID change in Reporting Balance

5 days back  I get rows from Reporting balance and stored in one excel again I fetch same rows from reporting balance but i noticed that ID is changed for some rows Eg :228473716 where previously for one row but the same row ID is differed now like 2284765654Based on GLAccountCode Division and Reporting year I am fetching the rows any reason for this ? how to track this which row is changed ?Thanks

2
M
19 days ago
M
muthuEOLApprentice
asked in CData Connect Cloud
GLSchemeCode Change track

I have GL Account Classification Mapping In Dataverse Table i used automation to pull data from Exact online and pushed data into dataverse . I need help on how to track that GLSchemeCode Changes from previous version  to updated version Eg:RGS versie 3.3 to RGS versie 3.5 in overtime because based on this updation in exact online I want to update the same thing in dataverse table  how to track this change and update accordingly ?

1
Ethem Q
1 month ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Check GLAccountCode linked with Division

from which table we can check what are GLAccount code linked for a particular Division ? 

1
Ethem Q
1 month ago
Jerod
JerodCommunity Manager
posted in CData Connect Cloud
Powered by CData - Embedded Connectivity for Connect Cloud

Powered by CData is a way for customers to integrate CData Connect Cloud live data access capabilities for their end users within their own applications.Contact CData sales if you are interested in a Powered by CData account.What is it?Powered by CData is our OEM White label offering for Connect Cloud. It is an embedded solution for customer products and applications to enable their own users to create live data connections right inside their product. Behind the scenes, CData is building and running those data connections.​Who is it for?Powered by CData is for customers that are running and building their own products that need customer data onboarded or have to provide other embedded connectivity capabilities. Instead of building those features out themselves, customers can instead leverage CData's robust and wide selection of drivers and enable users to create those connections and add their credentials themselves.​Why embedded connectivity?A growing number of products require users

0
Jerod
1 month ago
G
GawriApprentice
asked in CData Drivers
Error : cdata.dynamicsgp.DatabaseError: [500] Could not execute the specified command: Failed to log into Dynamics GP Server, please check your settings. Error message: HTTP protocol error. 404 Not Found.

Hi All,I am trying to connect my dynamics GP web services through python but I am unable to do so. I was working out the basic code given on their website and still unable to work it out. Could you advise any probable solution for it?ERROR:cdata.dynamicsgp.DatabaseError: [500] Could not execute the specified command: Failed to log into Dynamics GP Server, please check your settings. Error message: HTTP protocol error. 404 Not Found.

1
Ethem Q
2 months ago
R
RajeshApprentice
asked in CData Drivers
Delta lake supported?

Hi,I don’t see a connector for “delta lake” on Azure Data Lake Store Gen2. Is this not a supported source? If not, is it on the roadmap? Thanks.

1
E
2 months ago
James T
James TEmployee
asked in CData Drivers
How can I set up Tableau Bridge with a CData ODBC Drivers?

I found out that I need Tableau Bridge in order to “bridge” my CData ODBC driver with Tableau Cloud. Do you have any instructions you can share?

1
James T
2 months ago
James T
James TEmployee
asked in CData Drivers
Can I use Custom Filters in Tableau to set up Incremental Refresh?

I have a lot of data in my data source that I am trying to use with Tableau. When using CData connectors, is there a way I can help improve performance by only pulling in changed data?

1
James T
2 months ago
S
shaiApprentice
asked in CData Connect Cloud
IICS target failing when encountering error records

I’m using the cdata connector to load from snowflake to Microsoft dynamics dataverse target.I have tested the following approach:I have tested with JDBC_IC connection and the reject records are captured in error file but processes the good records. While running with the JDBC V2 connection the mapping fails when it encounters a record and rolls back all record.Any suggestions on creating error record file with JDBC V2 would be very helpful

1
Ethem Q
2 months ago
T
thebank987Apprentice
asked in CData Drivers
How do I use ArcESB to retrieve data from restful API using a webhook, then take that data and import it into SQL Server Management Studio?

I have a project where I need to retrieve data from a RESTful API. I have already created my request script and tested it in POSTMan.  I would like to retrieve data from the RESTful API’s response, input the data into SQL Server Management Studio.  My Question is what is the appropriate flow of connectors to build this? The Goal is to use a Webhook to retrieve data from the RESTful API, then be able to import that data into tables in SQL Server Management studio.   

1
Rohit
2 months ago
N
ntropicApprentice
asked in CData Drivers
JDBC Azure DataBricks and AzureServicePrincipal Authentication

I am trying to understand the driver behavior when connecting to an Azure DataBricks workspace using AzureServicePrincipal. Given the Azure Service principal and secret it seems to first obtain the Azure AD token and then it tries to call DataBricks REST API using the Azure AD token to obtain a Personal Access Token for the service principal. This is a problem because we do not allow personal access tokens in our environment. Is there a reason why it cannot use the Azure AD token directly to obtain access? Appreciate any insights or help.

2
N
2 months ago
R
RajaApprentice
asked in CData Drivers
CDATA jdbc excel license for ODI Prod and non Prod servers both local and server agents

HiPlease anyone explain the licensing requirement for Oracle Data Integrator (ODI) using CDATA jdbc driver for excel? We have purchased the cdata jdbc excel driver for ODI however not sure if we can use the license on both PROD and non PROD servers as its two different servers and two ODI agents. Do we need to generate the license file on both server from one license? and also we have local agent and server agent in ODI so how do we use the licence wisely?  How do we make use of the license on both prod & non-prod and local & server agents in ODI?  ThanksRaja

1
Ankit Singh
2 months ago
P
PravallikaMApprentice
asked in CData Drivers
CDATA SFTP Driver

I am using CDATA SFTP control flow CDATA-sftp-download procedure to download all the files from SFTP server to sql server , its working fine when the files are available on SFTP server but getting  error unable to populate result columns for single row type, query returned a empty set  when trying to execute the when the files are not present on server.Any idea how to solve this error. Thanks,

1
Ethem Q
3 months ago
N
Naomi YEmployee
asked in CData Drivers
Error: 'Unable to create data source with driver 'DriverType=ODBC;Platform=64', Keyword not supported: 'DRIVER'.'.

I’m using the Dynamics365 ODBC Driver with SQL Gateway to create a Linked Server. When I try creating a Service within SQL Gateway using a new System DSN, I run into this error of  Error: 'Unable to create data source with driver 'DriverType=ODBC;Platform=64', Keyword not supported: 'DRIVER'.'. How do I resolve this issue?

1
N
3 months ago
Jerod
JerodCommunity Manager
posted in CData Connect Cloud
Connect your CData Connect Cloud account to your Snowflake account through Partner Connect

Snowflake users can now access CData Connect Cloud right from their Snowflake account and begin working with live Snowflake data using the applications and client tools they already use. Users can quickly create an account with a free trial of CData Connect Cloud and automatically configure a Snowflake connection to gain real-time bi-directional data integration from any cloud reporting, analytics, or business tool.Video TutorialWritten InstructionsIn Snowflake, click Data Products -> Partner Connect and search for "CData"   Review the permissions and click "Connect"   Click "Activate" to continue the activation   If you don’t have a CData Connect Cloud account, you will be asked to complete the sign-up process for a free trial.   Log into your Connect Cloud account and review your automatically configured connection (look for "Snowflake_PC_CDATA_DB" on the "Connections" page)  

0
Jerod
3 months ago
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
Freshbooks object error while using ssis cdata drivers

Hi Ethem, i am able to connect freshbooks, except invoices object, all other objects are showing an error. kindly assist me on this. i am attaching an error image please check and suggest Thanks,Chari

2
R
3 months ago
T
TheDataDevsApprentice
asked in CData Drivers
NetSuite SSIS connector issue

I am creating a simple ETL package in Visual Studio 2022. I have a data flow using Cdata DataSource, and an OLE DB as the destination. I open the cdata netsuite source editor, select the transaction via and hit ok and visual studio just sits there and hangs. 

1
Ethem Q
3 months ago
A
AbdulApprentice
asked in CData Drivers
CData ODBC Scheduled Refresh

I am using CData Connector (ODBC)  with PowerBI to access my data (Zoho CRM). Is there a way to configure a scheduled refresh? Is this even something that can help me?

2
L
3 months ago
D
DSistemasApprentice
asked in CData Drivers
No Firedac components to install in RAD Studio 12 Athena; is it planned to be released?

We have our subscription active; and installed Delphi 12/Athena and downloaded the 2023 components.But in the installer there is no option to install in RAD Studio 12.0 Athena:Will there be an update for this version 12?Regards

2
D
3 months ago
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
unable to connect Freshbooks using Cdata SSIS component

Hi Team, i am unable to connect my freshbooks using Cdata connection kinldy share me the connection properties. in Freshbooks site there is an option to create app under that app all settings are attached as an attachment. please check and suggeset Thanks,Chari 

2
R
3 months ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings