Data connections
At Sytex, we offer several alternatives when exporting data so that your team can manipulate them at your convenience.
ODBC connections
Steps to create an ODBC connection
.1First we must download the latest version of the "MySQL Connector/ODBC" connector, we can download it from the following link.
.2Then we will ask Sytex Support for a username and password for the credentials
It is recommended to download the direct installer (MSI Installer) corresponding to the version of your operating system.
Already installed from the Windows start menu we will look for the newly installed connector.
The next step will be to configure our connection to the database (our team must previously provide you with the necessary data once the order has been placed)
Within the connector we will activate the "Add" button.
This sketch cannot currently be displayed in exports
We select the MySQL ODBC 8.0 Unicode Driver option.
In this step it is important to check the data entered:
- Data Source Name: sytex_app
- TCP/IP Server: (data provided by our team and unique for each case) 54.233.70.14
- Port: 8080
- User: (data provided by our team and unique for each case)
- Password: (data provided by our team and unique for each case)
This sketch cannot currently be displayed in exports
After configuring all the data, it is recommended to perform a connection test with the "Test" button.
3. Once the connector has been created, the next thing to do is to use it within Excel.
Within Excel, in the "Data" section, we will find a button called "Obtain Data" that will allow us to select between several possible options, where we will select the "From ODBC" option within the "From other sources" submenu.
This sketch cannot currently be displayed in exports
And from the new window we will select the previously created connection
This sketch cannot currently be displayed in exports
This will show us all the database views/reports that we have available, where we can proceed to load it directly or transform it with Power Query if desired.
You can also generate a connection in the same way for Power BI
After that, a window will be displayed where you can select the already closed connector
Once selected and clicking the accept button, the system will show you the tables to which your user has access. You can select one or more tables and continue with the "load" or "transform data" buttons as needed.
