Managing Integrations
Last updated
Last updated
Integrating your existing database, APIs as well as 3rd party to Nected is a simple and easy process. You just need to create an integration for either a staging or a production database.
Log into Nected with your Email ID and password.
Click Integrations in the left navigation to open the Integrations page.
Click + Connect under the database type for which you want to create a connector. The connection information form for your database type opens, in this example MySQL.
Enter the connection information for your integrations. Enter the integration, following the configuration steps mentioned in Integration Libraries as per corresponding integrations. Click Test Connection.
Publish your connector to Staging or Production, based on your environment.
Note: The connection information is the same for both staging and production databases for all database types – MongoDB, MySQL, MS SQL Server, Postgres Redshift, and so on. Refer to the Connector Configuration Parameters for the list of database and REST API connector parameters.
After you successfully publish a connector, you can connect to the database to create Nected Datasets and Rules to run on the target database in the same environment.
You can edit integrations if you are moving to a new configuration or have a change in existing configurations.
Follow this procedure to edit an existing integrations:
Log into Nected with your Email ID and password.
Click Integrations in the left navigation to open the Integrations page.
Click three dots next to the connector state for the connector that you want to edit and select Edit. The connector configuration form for your integration opens.
Modify the connection configuration following the configuration steps mentioned in Integration libraries as per corresponding integrations.
Test the connection to your integration using the modified information.
After a successful connection to the database, publish your connector to Staging or Production, based on your environment.
Close the connection information form and check the connector status.
After you successfully edit a connector, you can connect to the database.
You may want to delete an integration in certain scenarios, such as:
Your integration does not exist anymore.
You want to create a new connector for a different staging/production database.
You no longer need to use the connector because you moved from the staging to the production database.
Follow this procedure to delete an existing database connector:
Log into Nected with your Email ID and password.
Click Integrations in the left navigation to open the Integrations page.
Click three dots next to the connector state for the connector that you want to remove and select Delete. The Delete Connector dialogue box opens.
Click Delete to confirm the delete operation.
Note: The delete operation will fail if a connector is being used in any of datasets or rules. You must first remove the connector & update your existing datasets or rules, and then delete the connector.
You can refer to integration states, allowed states in the dataset & rules as well as any error to do troubleshooting if you are facing any issues in managing integration.