In order to perform a successful connection to you MySQL database, we just need the following information and that's it!
- Host: This is the name or the IP address of the server where the database is located.
- Port: This is the port we use to connect and communicate with the Database.
- Database: This is the name of the database we are going to use to fetch the data.
- Table: The name of the table or tables we are going to use in order to fetch the data
- Username and password: Valid username and password to connect to the database.
- SSL certificate, SSL key and SSL certificate authority: please provide this certificates and key in order to perform a secure connection to the database.
Once we have a successful connection, it will enable us to populate your AlertFind instance with information such as:
- First Name
- Middle Name
- Last Name
- Personal Email
- Cell Phone
- Home Phone
- Alternate Phone
- Phone Extension
- Job Title
- Zip Code
How does our MySQL connector works.
The below graphic explains the various nodes involved in the transition of data from your MySQL database to AlertFind.
Detailed Steps Explaining Above Graphic:
- MySQL connector fetches the user information stored in your MySQL database via API.
- Based on your chosen frequency, our connector running on AWS Lambda fetches data from MySQL database.
- At this stage, data goes through the validation and processing and is finally transformed into a CSV.
- The CSV is compressed to a Zip File and sent into AlertFind API via the AlertFind connector running on AWS Lambda.
Data Storage Nodes in the Graphi Above:
- Node 5: Refers to Apache Cassandra Cluster which stores the data for execution purposes. It has a TTL of 7 Days after workflow execution has finished.
- Node 6: Refers to Elastic Search Cluster used for indexing data for 30 days so that it can be searched within the logs interface.
- Data Safety: All Data is encrypted in transit using HTTPS, using TLS 1.3 encryption internally. Sensitive customer data, such as access tokens, usernames, passwords are encrypted at rest using Amazon Key Management Service (KMS), which uses FIPS 140-2 hardware security modules.
We encourage you to keep searching the connector that suits your needs in our main AlertFind Connector List under the section System of Records Integrations by clicking the button below.