 |
VOOZH | about |
|
VOOZH | about |
This guide walks you through everything you need to get started with the CData ODBC Driver for Adobe Commerce. You'll learn how to install and license the driver, configure your first connection, and explore next steps for working with Adobe Commerce data in your applications.
You should have received your license key via email from the CData Orders Team. The license key looks like this: XXXX-XXXX-XXXX-XXXX-XXXX
Your license would typically be activated during installation. However, there are cases where you may need to activate it manually. The steps below walk you through manual activation:
Can I use my license on multiple machines?
Yes, depending on your subscription tier. Check your order confirmation or contact your account representative for details. If you are unsure of who your account representative is, contact [email protected].
I lost my license key. How do I retrieve it?
Email [email protected] with your order number, and we'll resend your license key.
Can I transfer my license to a different machine?
Yes. When transferring the license to a different machine, you will need to submit a License Transfer Request on our site linked below:
https://www.cdata.com/lic/transfer/
After the License Transfer Request is submitted and successfully processed, an activation will be added to your Product Key and you will be able to activate the full license on the other machine. Once this process is finished, the license on the previous machine will be invalid.
For additional licensing questions, contact [email protected]. Viewing and upgrading your license can now be done through our self-service portal at portal.cdata.com.
Once your driver is installed and licensed, you're ready to configure a connection to Adobe Commerce. The ODBC driver uses a DSN (Data Source Name) to store connection properties.
Adobe Commerce uses the OAuth 1 authentication standard. To connect to the Adobe Commerce REST API, obtain values for the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties by registering an app with your Adobe Commerce system. See the "Getting Started" section in the help documentation for a guide to obtaining the OAuth values and connecting.
You will also need to provide the URL to your Adobe Commerce system. The URL depends on whether you are using the Adobe Commerce REST API as a customer or administrator.
Customer: To use Adobe Commerce as a customer, make sure you have created a customer account in the Adobe Commerce homepage. To do so, click Account -> Register. You can then set the URL connection property to the endpoint of your Adobe Commerce system.
Administrator: To access Adobe Commerce as an administrator, set CustomAdminPath instead. This value can be obtained in the Advanced settings in the Admin menu, which can be accessed by selecting System -> Configuration -> Advanced -> Admin -> Admin Base URL.
If the Use Custom Admin Path setting on this page is set to YES, the value is inside the Custom Admin Path text box; otherwise, set the CustomAdminPath connection property to the default value, which is "admin".
Solution: Verify your credentials are current. For OAuth applications, you may need to authorize CData in your application's security settings. Contact [email protected] for authorization assistance.
Solution: Check firewall & proxy settings. Contact [email protected] for specific port requirements.
Solution: Verify database and schema names. Use the Data Model tab in the DSN configuration to browse available tables.
Solution: Verify the driver is correctly registered in odbcinst.ini. Contact [email protected] for further assistance.
For additional connection troubleshooting, contact [email protected] with your specific error message.
Now that you have installed, licensed, and configured the driver, here are some scenarios you can use to explore our ODBC Drivers:
If you need assistance at any point:
Driver={CData ODBC Driver for Adobe Commerce};RequiredConnectionProperty1=Value1;RequiredConnectionProperty2=Value2;
Be prepared to securely upload the log file upon request when reaching out to [email protected] for troubleshooting analysis.
For questions not covered in this FAQ, contact [email protected].
Download a free trial of the Adobe Commerce ODBC Driver to get started:
Download NowLearn more:
👁 Adobe Commerce IconThe Adobe Commerce ODBC Driver is a powerful tool that allows you to connect with live Adobe Commerce data, directly from any applications that support ODBC connectivity.
Access Adobe Commerce like you would a database - read, write, and update Customers, Inventory, Products, Orders, etc. through a standard ODBC Driver interface.
