This guide will take you through the steps of uninstalling the Fivetran proxy and undoing the SQL Server changes to CDC, SSL and logon services.
What's next
1. Uninstall Proxy
ℹ️ You may have installed multiple proxies on multiple servers. They will all have to be removed separately. If you aren’t sure how many you have, you can reach out to FleetOps to check the proxies associated with your account.
To uninstall the Fivetran Proxy, log into the server where it was installed and open the “Apps & Features” settings page. Search for Fivetran and click uninstall. There may be several confirmation popups - click “uninstall” or “ok” in each of them.
Fivetran proxy is now uninstalled. All data should be removed, but you can manually check the default location of C:\\fivetran is now gone.
2. Remove SQL Server User
If you used the defaults our setup guide, you should have created a user named fleetops which you can remove with the below steps:
use ;DROP USER fleetops1;DROP LOGIN fleetops1;
3. Disable CDC
⚠️You may have had CDC enabled for other uses before setting up Fivetran. In that case DO NOT disable CDC for the whole database. Check what tables/databases still need CDC and only disable the ones you no longer require.
3.1 Find what databases and tables have CDC enabled
First find out which databases in your SQL Server have CDC enabled.
Select name from sys.databases WHERE is_cdc_enabled = 1
Then run the below script to output all tables with CDC enabled in each database. If the output matches the schema and tables you enabled in the setup guide and you don’t have any other services using the CDC, you can skip ahead to disabling CDC for the whole database.
use ;SELECT s.name AS "schema", t.name AS "table", c.capture_instance AS "capture_instance" FROM cdc.change_tables AS c INNER JOIN sys.tables AS t ON c.source_object_id = t.object_id INNER JOIN sys.schemas AS s ON s.schema_id = t.schema_id where t.is_tracked_by_cdc = 1
3.2 Disable CDC per table
For each table you want to disable CDC for, you need to take the outputs from the query above and insert them into the stored procedure below:
use ;GO EXEC sys.sp_cdc_disable_table @source_schema = N'schema', @source_name = N'table', @capture_instance = N'capture_instance'GO
3.3 Disable CDC for the database
If you want to disable CDC for an entire database, you can use the command below:
use ;EXEC sys.sp_cdc_disable_db
4. Disable SSL
You probably had SSL certs and secure TCP/IP connections enabled before setting up Fivetran. If you did, DO NOT disable it. Only follow these steps if you originally followed our documentation for setting up a self signed cert.
Removing the SSL cert will require a restart of the SQL Server Service, which will disconnect any applications connected to it and will result in downtime.
If you are certain you want to remove the self-signed SSL cert that you added for the Fivetran integration, then you can do so via the SQL Server Configuration Manager. In the left hand pane, expand the “SQL Server Network Configuration”. Then right click the “Protocols for MSSQLSERVER” and select properties. Under the Certificates tab, click the clear button. Then click OK, and again on the confirmation dialog
Now you can restart the SQL Server Service. In the left hand pane select the “SQL Server Services” option. In the right hand pane right click the “SQL Server MSSQLSERVER” row and click Restart.
Once the SQL Server Service is back running, test that your applications (eg. TMS) can still connect and access your data from SQL Server.
Summary
You have successfully removed the Fivetran proxy service and reversed all changes to your database made for the FleetOps data sync.
If you encountered any problems or have any further questions, please reach out to FleetOps support.
Still using the FleetOps v1/v2 interface? View the legacy version of this article.