Hi <@U04SE163WC8>, I need to push data to a Micros...
# replication-ask-aik
Kevin Morgan
10/20/2023, 4:22 PMHi @kapa.ai, I need to push data to a Microsoft Dynamics GP instance running on premises at a customer site. Does Airbyte support that?
k
kapa.ai
10/20/2023, 4:24 PMYes, Airbyte does support Microsoft Dynamics GP as a source. Microsoft Dynamics GP runs on the MSSQL database, and you can use the MSSQL connector to sync your MS Dynamics GP instance by connecting to the underlying database. You can find more details about this in the [Microsoft Dynamics GP documentation](https://docs.airbyte.com/integrations/sources/microsoft-dynamics-gp). To set up the connection, you need to ensure that your database is accessible from the machine running Airbyte. You can verify this using the check connection tool in the UI as mentioned in the [MSSQL documentation](https://docs.airbyte.com/integrations/sources/mssql). Once you've confirmed the accessibility, you can set up a new connection in Airbyte. Here are the steps: 1. On the left side of your main Airbyte dashboard, select Connections. 2. Choose your source (Microsoft Dynamics GP) and destination. 3. Configure the connection. You can refer to [this page](https://docs.airbyte.com/cloud/managing-airbyte-cloud/configuring-connections) for more information on each available configuration. 4. Toggle which streams you want to replicate, and set up the desired sync mode for each stream. More information on sync modes can be found [here](https://docs.airbyte.com/understanding-airbyte/connections/#sync-modes). 5. Click Set up connection to complete your first connection. After setting up the connection, you can monitor the data ingestion process as described in this [tutorial](https://airbyte.com/tutorials/measure-customer-support-sentiment-analysis-with-gpt-airbyte-and-mindsdb). Please note that you might need to reach out to your service representative or system admin to find the parameters required to connect to the underlying database.
k
Kevin Morgan
10/20/2023, 4:25 PM@kapa.ai Can you explain how airbyte works with on premises resources?
k
kapa.ai
10/20/2023, 4:26 PMA message from kapa.ai
kapa.ai
10/20/2023, 4:26 PMAirbyte can work with on-premises resources by connecting to your databases, warehouses, and other data sources that are hosted on your local network. The key requirement is that the machine running Airbyte should be able to access these resources. This is dependent on your networking setup. For example, if you're using databases like Redshift, TiDB, ClickHouse, or CockroachDB, you need to ensure that these databases are accessible from the machine running Airbyte. The easiest way to verify this is via the check connection tool in the UI as mentioned in the respective documentation for [Redshift](https://docs.airbyte.com/integrations/sources/redshift), [TiDB](https://docs.airbyte.com/integrations/sources/tidb), [ClickHouse](https://docs.airbyte.com/integrations/sources/clickhouse), and [CockroachDB](https://docs.airbyte.com/integrations/sources/cockroachdb). If you're deploying Airbyte on a platform like Restack, Airbyte will be deployed on your cluster and you can access it using the link under the URL tab. You can also check the workloads and volumes that are deployed within Airbyte as mentioned in the [Restack documentation](https://docs.airbyte.com/deploying-airbyte/on-restack). In the case of Airbyte Cloud, you'll be provided with an invite link to sign up and verify your email. After signing up, you can click on the default workspace and follow the onboarding directions to create your first connection as mentioned in the [Airbyte Cloud documentation](https://docs.airbyte.com/deploying-airbyte/on-cloud). Remember, the key to successfully using Airbyte with on-premises resources is ensuring that your networking setup allows Airbyte to access these resources.
7 Views