Crystal Reports connection change

[reehan_mohammed]

What is needed to change a crystal report connection from Oracle/Teradata to Azure Data Lake so the the report works seamlessly?

My understanding: For instance changing a connection from Oracle to SQL Server is probably tweaking the syntax of the SQL statement provided the data model exists in the SQL Server database.

Thanks

-Reehan

[DellSC · Accepted solution]

If the table names and structures are essentially the same there are two possibilities:

1. If you're joining tables together in the Database Expert, you should just be able to go to Database >> Set Datasource Location and map everything from Oracle to Azure. If you are using any SQL Expressions, you'll probably need to tweak them if there's any Oracle-specific syntax used.

2. If you're using a command, you'll also use Set Datasource Location to change the connection. Then, you might have to tweak the syntax of the SQL in the command.

-Dell

[reehan_mohammed · Accepted solution]

Thanks Dell. Really appreciate your quick responses! You are such an asset to the SAP Community.

Regards

-Reehan