Kyriba is a global leader in cloud treasury and finance solutions, providing mission-critical capabilities for cash and risk management, payments, and working capital solutions. More than 2,500 clients worldwide rely on Kyriba to view, protect and grow their liquidity. Kyriba has connectivity in its DNA and is driven by research and innovation to uncover new ways to use APIs, artificial intelligence, and predictive analytics to support our customers. It unifies cloud offerings with a truly global community of customers, partners, and talented employees reaching over 100 countries worldwide.
A fully managed data warehouse service in the Amazon Web Services (AWS) cloud, Amazon Redshift is designed for storage and analysis of large-scale datasets. Redshift allows businesses to scale from a few hundred gigabytes to more than a petabyte (a million gigabytes), and utilizes ML techniques to analyze queries, offering businesses new insights from their data. Users can query and combine exabytes of data using standard SQL, and easily save their query results to their S3 data lake.
1. First, you need to obtain the API credentials from Kyriba. You can do this by logging in to your Kyriba account and navigating to the API section. Here, you can generate a new API key and secret.
2. Once you have your API credentials, you can add them to Airbyte by navigating to the Sources page and clicking on the "New Source" button.
3. From the list of available connectors, select "Kyriba" and enter a name for your source.
4. In the "Configuration" tab, enter your Kyriba API key and secret in the appropriate fields.
5. Next, you will need to specify the data you want to replicate from Kyriba. This can be done in the "Schema" tab, where you can select the tables and columns you want to include in your data pipeline.
6. After configuring your source, you can test the connection by clicking on the "Check Connection" button. If everything is set up correctly, you should see a success message.
7. Finally, you can save your source and start replicating data from Kyriba to your destination of choice.
1. First, log in to your Airbyte account and navigate to the "Destinations" tab on the left-hand side of the screen.
2. Click on the "Add Destination" button and select "Redshift" from the list of available connectors.
3. Enter your Redshift database credentials, including the host, port, database name, username, and password.
4. Choose the schema you want to use for your data in Redshift.
5. Select the tables you want to sync from your source connector to Redshift.
6. Map the fields from your source connector to the corresponding fields in Redshift.
7. Choose the sync mode you want to use, either "append" or "replace."
8. Set up any additional options or filters you want to use for your sync.
9. Test your connection to ensure that your data is syncing correctly.
10. Once you are satisfied with your settings, save your configuration and start your sync.
With Airbyte, creating data pipelines take minutes, and the data integration possibilities are endless. Airbyte supports the largest catalog of API tools, databases, and files, among other sources. Airbyte's connectors are open-source, so you can add any custom objects to the connector, or even build a new connector from scratch without any local dev environment or any data engineer within 10 minutes with the no-code connector builder.
We look forward to seeing you make use of it! We invite you to join the conversation on our community Slack Channel, or sign up for our newsletter. You should also check out other Airbyte tutorials, and Airbyte’s content hub!
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
Ready to get started?
Frequently Asked Questions
Kyriba's API provides access to a wide range of financial data, including:
1. Cash Management Data: This includes information on cash balances, bank accounts, and transactions.
2. Payment Data: This includes details on payments made and received, including payment method, amount, and date.
3. FX Data: This includes exchange rates and currency conversion information.
4. Risk Management Data: This includes data on financial risks such as market risk, credit risk, and liquidity risk.
5. Treasury Management Data: This includes information on treasury operations such as cash forecasting, cash positioning, and cash pooling.
6. Compliance Data: This includes data on regulatory compliance, such as anti-money laundering (AML) and know your customer (KYC) requirements.
7. Reporting Data: This includes data on financial reporting, such as balance sheets, income statements, and cash flow statements.
Overall, Kyriba's API provides a comprehensive set of financial data that can be used to manage cash, payments, risk, compliance, and reporting.