Trouble connecting to CDATA virtual databases in Airbyte Cloud

Summary

Unable to find stream when connecting to CDATA’s virtual databases in Airbyte Cloud


Question

Hello, team. I am part of a team that uses Airbyte cloud. I am trying to connect to CDATA’s virtual databases but it’s not finding the stream. I could use some help.



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["cdata-virtual-databases", "airbyte-cloud", "connector", "stream"]

Tell me more! What do you mean by CDATA virtual database? Can you point me at some docs?

https://www.cdata.com/kb/tech/odata-cloud-airbyte.rst

So this is the original documentation that they point you to.

But I noticed that the OData connector for Airbyte doesn’t exist.

https://cloud.cdata.com/docs/VirtualDatasets.html

Here are the docs for virtual datasets.

They are deprecating OData.

So previously you’ve used MSSQL connector?

This is a new connection.

We never made this connection before.

We are using CDATA to get data from SugarCRM. And then using AirByte to connect to CDATA.

But something is not working correctly. I can connect to CDATA using the SQL SErver connection but it doesn’t see any of the streams.

<@U0665FGTA8Z> this might be a good one to create a support ticket for. Otherwise if you could DM me your Cloud workspace I can take a quick peek.

https://cloud.airbyte.com/workspaces/87ac4759-05e5-42cd-9811-1a2bf4020e84/source

I have more questions, but going to follow up direclty